Previous Topic Next Topic

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

Closed
JEDEMEYER1 - Mar 20, 2013 at 07:29 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 - Mar 23, 2013 at 08:00 AM
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

Answer 1 / 1
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 770
Mar 23, 2013 at 08:00 AM
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
0