I need help writing a macro that will
1. Open another workbook with a path
2. I have a listbox in the original workbook and I would like to push the checked options into a range A1:A10 on the opened workbook.
3. I would then like to "save as" for the opened workbook.
I don't think I would need to upload a sample workbook, can someone just put in filler values for the path and workbook names for 1 & 2?
Any help is appreciated.
Bookmarks