Conditional copying into different worksheets

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


i have excel 2003. what i am trying to do is set up a complaint sheet for 4 different people.
In total there are 5 sheets (Main, Al, Brian, Ken, George)

I want it to pull the name(one of the 4 above) from the G colomn on the Main sheet and copy the information in that row into one of the 4 different work sheets.


All of the worksheets have a header row

this has been bugging me all day :S

Thanks!!

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
What will cause the data to be copied to other sheets ? What about existing data on other sheets.