Hi everyone!
I'm working on automating a program we're managing in an excel workbook and need this process to be as simple as possible for the user. Essentially, I have one sheet that has several columns, including one yes/no column. If the column in sheet one says "yes" I'd like all the other info from the columns to be pulled over to the next sheet and fill in that info in the next available row. I have included a sample spreadsheet.
I'm aware you can filter for yes or no and then copy this to the next sheet, but I would like this to be an automated process.
There will be instances where certain contacts will have skipped the first sheet and just be entered in the second, so the automation needs to account for that as well.
Thank you so much!! Any advice is much appreciated.
Bookmarks