This has been SOLVED. Please see comment below for solution.
Confusing, I know. Let me explain further. I want to use macros to:
- Copy value from Cell A1 from Workbook A
- Paste Cell A1 value to Workbook B Cell A1
- SaveAs with filename as the Cell A1 value to a separate folder
- Repeat steps 1-3 with all values in Column A from Workbook A
Does this make sense? Is it possible?
Something like a Mail-Merge in Word, but only in Excel.
Bookmarks