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" 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.