How to append multiple sheets in a file?

[jk51]

Hi,
Do you know VBA excel macro to create a new sheet called "Appended" and append all the multiple sheets in a excel workbook file.
I am using Excel 2010.

Thank you.

Mr Singh

 

[Gireesh]

Hi Singh,

Can you please put more information. I am not understanding completely. Thank you.

 

[jk51]

Hi Gireesh,

Thank you for your reply.

Sorry for not clarifying in my last message.

I meant by each sheet had some number of rows of data
for example sheet1: 100 rows; sheet2: 75 rows and sheet3: 50 rows. All 3 sheets of first row contains header fields and they are all same each sheet.
new sheet called 'appended': 225 rows altogether (100 + 75+ 50)
I want to add something at the end. For example, you can append one sheet to another or you can append a field to a record. Append always means to add at the end.

For VBA code
1) create a new sheet called "Appended"
2) append one sheet to another ( sheet 1 add to sheet 2 add to sheet3 = appended)

Hope this make sense.

Thank you

Mr Singh

 

[Monty]

Mr Singh

Hope you are doing good..Always with interesting questions..i really like to answer but please be advised to attach sample file.

I created a dummy data, Click on consolidate button in the first sheet..and let me know any challenges..

Hope you like this!