Combining data from two different workbooks
I am trying to combine data from one workbook to another according to type of
information. Is it possible for me to designate a column in one workbook and paste it to another workbook, creating a new page with each row that is copied? I am looking to do something similar to mail merge in Word. |
Combining data from two different workbooks
I don't see the similarity to Mail Merge, but it does seem like you could
simply filter your data and just have the one spreadsheet. A simple filter should work so you should not have to get complicated at all. . http://www.contextures.com/tiptech.html -- --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "EmZ" wrote in message ... I am trying to combine data from one workbook to another according to type of information. Is it possible for me to designate a column in one workbook and paste it to another workbook, creating a new page with each row that is copied? I am looking to do something similar to mail merge in Word. |
All times are GMT +1. The time now is 08:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com