How do I set up a querry that copies and pastes
 

I have a Workbook with 5 sheets. I need to set up either a querry or Macro
on Sheet 2 to look for data on Sheet 5 and if there copy it to the next blank
row in Sheet 2. Is this possible and how do I do this? HELP!

How do I set up a querry that copies and pastes
 

Hi

Start here to copy to the next blank row
http://www.rondebruin.nl/copy1.htm

to look for data on Sheet 5 and if there copy it to the next blank
Have you more information ???

--
Regards Ron de Bruin
http://www.rondebruin.nl


"SAR_Dave" wrote in message ...
I have a Workbook with 5 sheets. I need to set up either a querry or Macro
on Sheet 2 to look for data on Sheet 5 and if there copy it to the next blank
row in Sheet 2. Is this possible and how do I do this? HELP!