Conditional copying into different worksheets

Closed
jleschyson - Jun 22, 2011 at 05:14 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 22, 2011 at 06:25 PM
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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 22, 2011 at 06:25 PM
What will cause the data to be copied to other sheets ? What about existing data on other sheets.
0