copy range from different worksheets

[CThai]

Hi -

I have a workbook with 58 worksheets in it... each worksheets is name T01, T02....T58, I need to copy a range from different worksheets...

I don't need all the worksheets in Master.xls I only need some of the worksheets...

for example :

I need -
T01 - range from A3:N59
T03 - range from D3:P50
T05 - range from D4:O60
T07- range from D3:N72
T08 range from B3:N55
ect...


I would like to copy the Value and format ...

please help

thank you

Cthai

 

[ADAMC]

Hi....

Use the macro recorder to select sheet T01 and highlight and copy the range A3 to N59.

Stop the macro recorder and view the code....
Tailor it to suit your requirements above. by copying the code but changing the sheet reference.

 

[Jonmo1]

Where do you want to PUT them ?

 

[Norie]

Well I'm sure we could give you code for those 5 sheets.

But what about the rest of them?

The ranges seem totally random and you've not actually told us where to copy them to either.

 

[CThai]

Hello everyone-

I want to copy them to a new workbook... all in all I need to copy about 38 worksheets out of the 58 worksheets in the Master.xls...

and Norie you are right - all the range are different for each worksheets... so the codes will have to let me select the worksheets and range i want to copy from...

 

[Jonmo1]

WHERE in the new workbook?

You want to copy for example
Sheet T01 - range from A3:N59

To Workbook Jan.xls...

WHAT SHEET, and What Range????

 

[CThai]

Hi Jonmo1 -

I want to copy worksheets T01 to a new workbook called Jan.xls worksheet T01... so the name of the worksheets doesnt change...

the range are different for each worksheets needed to be copy so for worksheet T01 range from A3:N59 but it's not the same range for worksheets T03... all these worksheets will be put in Jan.xls

 

[CThai]

sorry i forgot to answer one of your question

[WHERE in the new workbook?]

i would like to put them at A1... in the Jan.xls worksheets name T01

 

[Jonmo1]

You can't put them ALL at A1, they will overwrite each other. And all that would be there would be the last one you copy....


do you mean you want to put them in column A, starting in row 1.
So if the first one covers A1:A50, the next one would go in A51 ??

 

[CThai]

No, I want to copy worksheets T01 from Master.xls and put it in workbook called Jan.xls worksheets T01 - then i want to copy T03 from Master.xls and put it in workbook called Jan.xls worksheets T03 --- so the workbook Jan.xls will have 38 worksheets...