If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating a 'mail merge' using data (in a Range)from multiple workb
I have data in a worksheet cell range (say A1:A10 for argument's sake - and
it's NOT a list). This is replicated over numerous workbooks, all with different names. I want to produce a report (.doc) containing the values from cells A1:A10 from workbook 'A', then on the next line down in the report, I want the contents of cells A1:A10 from workbook 'B', then on the next line down in the report, the contents of cells A1:A10 from workbook 'C', and so on. This is to be automated somehow (suggestions welcome!!), so a number of workbooks can be selected, either graphically or progammatically, and the process will take the data from each workbook in turn, and place it in the report, as detailed above. This is a little like a Mail Merge, but the data is not contained in a list (The rows of data in A1:A10 have no headings), and the data comes from multiple workbooks instead of just one. If it isn't possible to do this as described, is it possible to read the data from the separate workbooks into a list in a single worksheet, and then do the equivalent of a mail merge into the report? Maybe there's a piece of 3rd Party software that will do the above???!!! Regards, KG |
Thread Tools | |
Display Modes | |
|
|