Hey smart folk...
I am working w/ an excel file that has multiple sheets that I want to program automatic functions into. One is "Waitlist" which is the primary sheet where data is entered. Once a date is entered into column Q "assigned date," I would like that entire row to be transferred (moved entirely, not just duplicated) into the first available row in a second sheet "Assigned." Currently data is being cut and pasted manually, which has led to multiple user initiated errors. I am unfamiliar w/ coding, so any info would help! I found something online before, but it kept bringing up an error that I couldn't figure out. (Naturally, I can no longer find this old thread, so I can't even show it as an example.)
Mahalo in advance for any and all of your help!
Lei
Bookmarks