How to I combine excel worksheets?

M

msnyc07

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?
 
M

msnyc07

Thanks for the script!

What if I simultaneously pull the sheet name into ColumnX for each record so
I can retain categorization?
 
M

msnyc07

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.
 
R

Ron de Bruin

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top