zombiemaster
Board Regular
- Joined
- Oct 27, 2009
- Messages
- 241
Hi, All... I'm not looking for specific coding solutions at this point in the process, but hoping there may be tutorials of some kind that folks might be able to share...
I want VBA that will take data from cells in an Excel row and populate sections of a Word template.
I am going to have a spreadsheet with hundreds of rows of data, and I want to be able to select a cell somewhere in column A, click the macro button and it will scrape data from that row and populate a Word template that can be printed off. Click the next cell down, run the macro again and it populates a new sheet, etc on down the line.
Is this possible? Are there online tutorials for this sort of functionality? The project is still in the draft phase, but I am hoping to be able to present this as part of the solution.
Thanks for any thoughts, or website suggestions!
~ZM~
I want VBA that will take data from cells in an Excel row and populate sections of a Word template.
I am going to have a spreadsheet with hundreds of rows of data, and I want to be able to select a cell somewhere in column A, click the macro button and it will scrape data from that row and populate a Word template that can be printed off. Click the next cell down, run the macro again and it populates a new sheet, etc on down the line.
Is this possible? Are there online tutorials for this sort of functionality? The project is still in the draft phase, but I am hoping to be able to present this as part of the solution.
Thanks for any thoughts, or website suggestions!
~ZM~