Hi Ron de Bruin
I just learning VBA so I'm sure it's me.
I am using the example 2 and I can get it to copy what I need but only if
when I run the macro, I select the folder and then the work book to be
coppied.

Can I have it when I select run... go find the Folder and search for new
workbook and if found then copy automatically to summary worksheet?

If this is in example 2 please let me know where so I can try and see what
I'm doing wrong.

Once I get this working the other thing I need is for it to copy data from
15 work books and then skip 5 rows and copy the next 15 work books etc...

The 5 rows skipped have formulas in them to calculate mean, Std. Dev., etc.

Thanks so much for all your help,
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?