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
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 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 reply

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
514
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