I am trying to extract certain data from one file and place it int
another.
The main sheet contains data on wines. The name, type , variety, pric
etc. I am trying to create a conditional function to select only th
red wines and attach any other approperate data that those red wine
have and copy it to another sheet.
Help please
Thank

--
Message posted from http://www.ExcelForum.com

Hi
see: http://www.rondebruin.nl/copy5.htm

--
Regards
Frank Kabel
Frankfurt, Germany


I am trying to extract certain data from one file and place it into
another.
The main sheet contains data on wines. The name, type , variety,
price
etc. I am trying to create a conditional function to select only the
red wines and attach any other approperate data that those red wines
have and copy it to another sheet.
Help please
Thanks


---
Message posted from http://www.ExcelForum.com/

Use the advanced filter under Data=Filter=Advanced Filter

--
Regards,
Tom Ogilvy

"marvontherim " wrote in
message ...
I am trying to extract certain data from one file and place it into
another.
The main sheet contains data on wines. The name, type , variety, price
etc. I am trying to create a conditional function to select only the
red wines and attach any other approperate data that those red wines
have and copy it to another sheet.
Help please
Thanks


---
Message posted from http://www.ExcelForum.com/