I need help getting info from one worksheet to copy to others

Closed
syrenitytoo Posts 1 Registration date Wednesday January 16, 2013 Status Member Last seen January 16, 2013 - Jan 16, 2013 at 08:41 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 17, 2013 at 10:24 AM
Hello, I have an Accounts Receivable worksheet for each year. I want to log each entry into the main spreadsheet and then into a separate worksheet by state; can you help? Please. Because the entries on the main sheet will be far greater than the broken down sheets, I don't see how linking will work and save time; I am thinking of code or something easier if possible as I don't have much code experience. I simply want to be able to log the info and then have it pop over to the appropriate sheet maybe based upon the State I put in the furthest column.



1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jan 17, 2013 at 10:24 AM
Hi Syrenitytoo,

Rows can be copied to other sheets according to a value in a column.

I just need to know which column you use for State.
And which State will copy the row to which sheet.
Also the name of the master sheet will be nice to know.

Example:
Column G on sheet MasterSheet is used for State.
If State is Complete, copy row to sheet Completed.
If State is Testing, copy row to sheet Test
etc.

Best regards,
Trowa
0