I have 3 sheets, "WHOLESALE", WEB SALES" & "ORDERS".
If "WHOLESALE" or "WEBSALES" have a value "SPECIAL" in Column "A", it must copy the entire row to a new blank row in "ORDERS"
Also, If I change a value in Column "T" in "ORDERS", it should update the row which it was originaly copied from. This value in column "T" is blank in "WHOLESALE" & "WEBSALES" when it was first copied.
In other words: New row is made with Column "A" having the value "SPECIAL" in "WHOLESALE" - Excel then copies the entire row into "ORDERS" in a new blank row.
After I have changed the value from blank to anyhting in Column "T" of that same row (IN "ORDERS"), it updates the data of that row in "WHOLESALE".
Regards
Related:
Copy Row based on value of cell, and update row data back
I do not have clear idea about few things.
1. Is copying done in some batch processing ?
2. How "original" rows are tied. Once the row is copied, how one identify original row
if you could post a sample file at some public file sharing site and post back link to actual file back here one can see what can be done
