justmeok
New Member
- Joined
- Jul 27, 2011
- Messages
- 42
- Office Version
- 365
- Platform
- Windows
Hi everyone not sure if this is even possible?
I have a list of 100 store id's (in an excel file) and I have an excel template workbook that I need to have one workbook for each store id. I would like the macro to populate cell A1 with the first store id on the list then save to a specified folder using the store id as the filename with the current year on the end. eg STOREID1 2016.xlsx. The macro needs to repeat that action for every store id on the list.
The solution doesn't have to be a macro I am happy to do whatever will work rather than having to do it all manually.
I currently use Excel 2016 on a pc
Thanks everyone
I have a list of 100 store id's (in an excel file) and I have an excel template workbook that I need to have one workbook for each store id. I would like the macro to populate cell A1 with the first store id on the list then save to a specified folder using the store id as the filename with the current year on the end. eg STOREID1 2016.xlsx. The macro needs to repeat that action for every store id on the list.
The solution doesn't have to be a macro I am happy to do whatever will work rather than having to do it all manually.
I currently use Excel 2016 on a pc
Thanks everyone