Hi Peer

If you find what you are looking for in the column what do you want to do
Copy the row or ???

Tell exactly what you want to do and I will try to help you today or Tomorrow.


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Peter" wrote in message ...
Hi Ron, that works well for sequential retrievals, but do
you have any examples of code that will allow you to
search a column looking for matches to a value such as a
state abbreviation?

-----Original Message-----
Try
http://www.rondebruin.nl/copy3.htm


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Ed R" wrote in
message ...
All of our invoices are seperate excel files. How can I
easily summarize them (grab certain cells) from every
file in a specific folder?

Thanks


.