I have two worksheets - one named MASTER and another named TEMPLATE. Is there a way to go through column A on MASTER that looks like this:
A B 1 A - Access 2 A1 blah blah blah 3 A2 blah blah 4 FO - Followup 5 FO1 blah blah blah 6 FO2 blah 7 FO3 blah blah
So using column A, it should skip cells A1 and A4 (not "A###" or "FO##"), and then use TEMPLATE and create a copy of it (keeping all formulas and conditional formatting) renaming it to A1, A2, FO1, FO2, and FO3. Is this something that is easy to do?
Bookmarks