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.

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" <EmZ@discussions.microsoft.com> wrote in message news:2B2DC8A3-842B-4BCC-BEBD-5AF9D655AA51@microsoft.com...
> 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.