Copy Row based on value of cell, and update row data back

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

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

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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