Hello, I've searched high and low and can't find the exact code I'm
looking for... and unfortunately, I'm unable to figure how to string
together bits of code to achieve the desired result.

What I'd like to be able to do is have VBA copy and paste a specific
range from all worksheets in all workbooks in a folder to be selected
by the user.

Anybody got any ideas?

Any help at all would be greatly appreciated.

Hi ?

See
http://www.rondebruin.nl/copy3tip.htm


--

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


wrote in message oups.com...
Hello, I've searched high and low and can't find the exact code I'm
looking for... and unfortunately, I'm unable to figure how to string
together bits of code to achieve the desired result.

What I'd like to be able to do is have VBA copy and paste a specific
range from all worksheets in all workbooks in a folder to be selected
by the user.

Anybody got any ideas?

Any help at all would be greatly appreciated.

I've found this to be very useful

http://www.rondebruin.nl/copy3.htm


" wrote:

Hello, I've searched high and low and can't find the exact code I'm
looking for... and unfortunately, I'm unable to figure how to string
together bits of code to achieve the desired result.

What I'd like to be able to do is have VBA copy and paste a specific
range from all worksheets in all workbooks in a folder to be selected
by the user.

Anybody got any ideas?

Any help at all would be greatly appreciated.

Hello,

I tried to post a response thanking both of you for your help and
adding detail to the description of what I'm trying to accomplish. But
I don't see it on here so I'll summarize just in case:

Basically, the only thing I need to do now --that is not already
achieved by the code Ron so graciously posted-- is to have the range
from each worksheet paste into a new worksheet in the master workbook
by a name derived from the original sheet (i.e. An original sheet name
is "Task # 78-000102-CC" and I'd like the name to be "78-000102-CC",
etc).

Thanks again for your input Ron and Barb.

I really appreciate it!

Amy

Hi amy

Which code example do you use now ?
Is only tje naming of the sheet your problem now ?

--

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


wrote in message oups.com...
Hello,

I tried to post a response thanking both of you for your help and
adding detail to the description of what I'm trying to accomplish. But
I don't see it on here so I'll summarize just in case:

Basically, the only thing I need to do now --that is not already
achieved by the code Ron so graciously posted-- is to have the range
from each worksheet paste into a new worksheet in the master workbook
by a name derived from the original sheet (i.e. An original sheet name
is "Task # 78-000102-CC" and I'd like the name to be "78-000102-CC",
etc).

Thanks again for your input Ron and Barb.

I really appreciate it!

Amy

Hey Ron,

I'm using the code you recommended above: http://www.rondebruin.nl/copy3tip.htm
....and the problem remaining to be solved is two fold.

I need to have:

1) the range from each worksheet pasted to a new worksheet in the
master workbook

and

2) the new worksheet to be named something similar to the original
(i.e. from "Task # 78-000102-CA" to "78-000102-CA").

Thanks,
Amy

Are you sure that there are no duplicate sheet names then in all the workbooks ??

Bedtime for me now but I will make a example for you tomorrow after work

--

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


wrote in message oups.com...
Hey Ron,

I'm using the code you recommended above: http://www.rondebruin.nl/copy3tip.htm
...and the problem remaining to be solved is two fold.

I need to have:

1) the range from each worksheet pasted to a new worksheet in the
master workbook

and

2) the new worksheet to be named something similar to the original
(i.e. from "Task # 78-000102-CA" to "78-000102-CA").

Thanks,
Amy