Hi Ron de Buin,
I actually now realize that what I should of been saying is that I need to
copy from workbooks in a folder that are used as forms with data on them in
the cells mentioned and copy these cells to a summary workbook. Any help
with code would be greatly appreciated.
Thanks,
drose

"Ron de Bruin" wrote:

Hi drose

It is possible to do this

You can adapt example 2 on the same page

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"drose" wrote in message ...
Thanks Ron de Bruin,
I got the macro to run and copy the data over but only if I selected the
folder and then the worksheet to be copied. Is there a way that the macro
would detect whenever a new worksheet is added to this folder and then would
copy only from the new worksheet?
Thanks,
Drose

"Ron de Bruin" wrote:

Hi drose

You can start with this macro that create links for you
http://www.rondebruin.nl/summary2.htm

If you want to do it for all worksheets in each workbook post back


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"drose" wrote in message ...
I'm sure this would take VBA but I need to copy the values in cells B1, D1,
K1, D4, E4, F4, I4, J4, K4 for each worksheet put into folder A to a
worksheet (column A through I) in Folder B. Is this possible?