hello
I have this sample simple just to understand what I want , my original data begins from COL A to COL H it should create whole data with the headers from COL K: S , so each column contains duplicated strings as in COLS B,C,G should merge as one , as for the values should summing for duplicated data and insert column(TOTAL) to summing the values for any item I put the result from COL K:S and my real data at least 5000 rows and every time is increasing
thanks in advance
thanks
but I have two questions , why it doesn't work in standard module and this is my mistake and can you mod the code to make create the headers with borders and formatting as in range from COL A to COL H when merge data ?
According to your attachment headers are already created but as a beginner starter you can amend the code to add anything …
It can not work in a standard module as it is designed for a worksheet module but for a standard module
you can add a valid worksheet reference to all statements relative to the worksheet …
Bookmarks