Hope I'm not being a pain, but I need help one more time... a manager at my POE is trying to help one of her team work smarter, not harder. On the attached spreadsheet, you can see she's got it set up so that when the employee enters data in the front page, depending on the contents of the drop down in column "C", the data in the row gets moved to the appropriate worksheet. She's accomplishing this through IF statements. The issue is that it moves the data laterally, instead of putting it in the first available row in the appropriate worksheet. Is it possible to get the data to move to the first available row when it copies from the main sheet to the secondary sheet; and if so, how?
You guys rock, btw... thanks so much for your help!
PVC REQUESTS COPY .xlsx
Bookmarks