Macro to combine the sheets only if the number of rows are two.

Hiii,

thanks for helping.

I have a macro that combines all the sheets in the workbook.

i need to alter this macro so that only those sheets with two rows in total gets combined and those with more than two rows remain separate.

Please Login or Register  to view this content.

Any ideas??

Many thanks

Gokz

Gokz,
When you say two rows, does this include the heading? The code will look for a last row in a sheet including a heading, i.e it will count the heading as a data as well.
Let's say you have 3 sheets. 1 sheet has 3 rows of data, the first row being the header, the last row in this case is 3, so the code will ignore this sheet as it has over 2 rows. I think there are few unknowns on your data, so would be easier if you could attach a sample of your book.

Hiiiii AB33,

sorry...i missed the heading...so it should be 3.....

i have large amount of data that is very difficult to replace with dummy data.

can i amend the above macro??

thanks

Gokz

i have around 150 sheets with 3 rows of data and 5 rows data. i need to combine only those with 3 rows of data.

Gok,
I have came up with different code and changed some of the names. It is partly guess work, as I could not see the format of your data.
A number of assumptions on my code.
The code clears any data and repopulate the Murex with the new data.
The header on Murex is copied from one of the sheets .
The headers from each sheet are not copied, ie the code only copies from row 2, but the header will be counted towards deciding if a sheet has 3 rows. Have a go and see

Please Login or Register  to view this content.

hiiii,

Thanks, but it dint work..the sheet was blank.

i am attaching an excel dummy sheet where i tried.

Please let me know.

Thanks

Gokz

Any ideas friends??

Gokzee,
The code works as it was, so I do not know what the issue is. I did not get the time to check it this morniing. I now have checked it again and you do not need to split up the copy in to two rows. If you have any issue, let me know and will attach the code with your data

Please Login or Register  to view this content.