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.
Related:
I need help getting info from one worksheet to copy to others
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.
