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" <(E-Mail Removed)> wrote in message news:063C49AB-9CDE-49B4-88AE-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message news:71711226-F878-44CD-A703-(E-Mail Removed)...
> >> > 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?
> >> >
> >>
>
Similar Threads
