I'm hoping someone can make a repetitive task a whole lot simpler for me!
I am looking to take data from excel and create a batch of forms in Word:
- I'd like the filename of the word documents to be taken from a cell in excel (eg store number and name).
- Then I'd like a cell in the excel document (eg the one containing the store address) pasted into the corresponding word file.
- I'm guessing I will need to use Macros, which I can use to do the copy and paste but I'm struggling to figure out how I can get it to use the cells for the file name or move down to the next cell once it has done one line containing the required information.
Hopefully that makes sense? Help would be greatly appreciated.