I need help getting info from one worksheet to copy to others [Closed]

Report
Posts
1
Registration date
Wednesday January 16, 2013
Status
Member
Last seen
January 16, 2013
-
Posts
2761
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2021
-
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

Posts
2761
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2021
462
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!