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