copy data from worksheet in folder a to worksheet in folder b

[drose]

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?

 

[Ron de Bruin]

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

 

[drose]

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]

Hi drose

It is possible to do this

You can adapt example 2 on the same page

 

[drose]

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

 

[drose]

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]

Hi Drose

Yes it is possible what you want but I have no time on this moment to change the
macro for you.
I flag this thread and try to get back to you next week(end)