Combine sheets

Put this into a standard codemodule and run it... you may need to mess around with the date values - VBA is US-centric with dates, and I have no way to test against your date settings.

Please Login or Register  to view this content.

Originally Posted by Mverm0

Hmm thnx.
The name of the the worksheets is the date, but also (1) or (2) or (3) and going up by on before the date.

It was not clear what you wanted, and there were only two sheets, both of whose names were valid dates - no (1) (2) or (3). The macro worked on the example workbook, copying the numbers out of the tables. So....... what do you actually have, if the sample is not really what you have?

Originally Posted by Mverm0

Hmm thnx.
The name of the the worksheets is the date, but also (1) or (2) or (3) and going up by on before the date.

It was not clear what you wanted - what did "And under this sheet type 2" actually mean.. I thought a sheet under the sheet.... And there were only two sheets, both of whose names were valid dates - no (1) (2) or (3). The macro worked on the example workbook, copying the numbers out of the tables. So....... what do you actually have, if the sample is not really what you have?

That is completely different from your original post. And how does Type 1 have values against Type 1, when in the (X) sheets, the value is /? And where are you getting the dates from? Are you always combining just two sheets?