|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 25th, 2010, 05:33 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to I combine excel worksheets?
I have a large worksheet with about 200 sheets all with the same field layout.
I want to combine into one worksheet and pull the sheet name into columnX so I keep the organization. Can this be done easily? 
|
|
#2
May 25th, 2010, 06:14 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to I combine excel worksheets?
With a macro it is easy (I think)
Start here http://www.rondebruin.nl/copy2.htm If it is for a few cells check out http://www.rondebruin.nl/summary.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "msnyc07" wrote in message ... I have a large worksheet with about 200 sheets all with the same field layout. I want to combine into one worksheet and pull the sheet name into columnX so I keep the organization. Can this be done easily?
|
|
#3
May 25th, 2010, 08:47 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to I combine excel worksheets?
Thanks for the script!
What if I simultaneously pull the sheet name into ColumnX for each record so I can retain categorization? "Ron de Bruin" wrote: With a macro it is easy (I think) Start here http://www.rondebruin.nl/copy2.htm If it is for a few cells check out http://www.rondebruin.nl/summary.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "msnyc07" wrote in message ... I have a large worksheet with about 200 sheets all with the same field layout. I want to combine into one worksheet and pull the sheet name into columnX so I keep the organization. Can this be done easily? .
|
|
#4
May 25th, 2010, 09:52 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to I combine excel worksheets?
Which columns do you want to merge
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "msnyc07" wrote in message ... Thanks for the script! What if I simultaneously pull the sheet name into ColumnX for each record so I can retain categorization? "Ron de Bruin" wrote: With a macro it is easy (I think) Start here http://www.rondebruin.nl/copy2.htm If it is for a few cells check out http://www.rondebruin.nl/summary.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "msnyc07" wrote in message ... I have a large worksheet with about 200 sheets all with the same field layout. I want to combine into one worksheet and pull the sheet name into columnX so I keep the organization. Can this be done easily? .
|
|
#5
May 27th, 2010, 08:53 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to I combine excel worksheets?
Well I am merging basically columns 1-5, each has the same name convention in
row 1. I want to combine in one sheet, but in row 6 I want to push the name of the sheet so once it is combined i retain the categories I used the sheets for. "Ron de Bruin" wrote: Which columns do you want to merge -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "msnyc07" wrote in message ... Thanks for the script! What if I simultaneously pull the sheet name into ColumnX for each record so I can retain categorization? "Ron de Bruin" wrote: With a macro it is easy (I think) Start here http://www.rondebruin.nl/copy2.htm If it is for a few cells check out http://www.rondebruin.nl/summary.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "msnyc07" wrote in message ... I have a large worksheet with about 200 sheets all with the same field layout. I want to combine into one worksheet and pull the sheet name into columnX so I keep the organization. Can this be done easily? . .
|
|
#6
May 27th, 2010, 09:19 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to I combine excel worksheets?
Change the H to the column you want in this line
'Optional: This will copy the sheet name in the H column DestSh.Cells(Last + 1, "H").Resize(CopyRng.Rows.Count).Value = sh.Name -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "msnyc07" wrote in message ... Well I am merging basically columns 1-5, each has the same name convention in row 1. I want to combine in one sheet, but in row 6 I want to push the name of the sheet so once it is combined i retain the categories I used the sheets for. "Ron de Bruin" wrote: Which columns do you want to merge -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "msnyc07" wrote in message ... Thanks for the script! What if I simultaneously pull the sheet name into ColumnX for each record so I can retain categorization? "Ron de Bruin" wrote: With a macro it is easy (I think) Start here http://www.rondebruin.nl/copy2.htm If it is for a few cells check out http://www.rondebruin.nl/summary.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "msnyc07" wrote in message ... I have a large worksheet with about 200 sheets all with the same field layout. I want to combine into one worksheet and pull the sheet name into columnX so I keep the organization. Can this be done easily? . .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
