Combining some sheets into another sheet

Hi all.

Really appreciate everyone's help on this.

I have a number of sheets in my workbook which I want to combine to a single sheet.

The Data I want to copy is from A2:M? on Sheets called F1, F2, F3, F4, and pasted into a 5th sheet called FCombined.

All of the above sheets have exactly the same layout.

I did a search on combining sheets but the results threw up solutions where the sheets were the only ones in the entire workbook, I have other sheets which do different things.

The only issue is that the quantity of records could change.

I would be enormously grateful if anyone could help me out on this.

Thanks in advance.

Simon

Try:

Please Login or Register  to view this content.

Dom

Untested (ie coded on the fly) but perhaps:

Please Login or Register  to view this content.

the above assumes

a) final sheet has header row

b) final sheet should be purged with each collation

c) values only copy


EDIT: 12:14 - missing comma in the .Clear line at beginning of routine - did say it was untested

I'm sure Donkey's works but if not...

Please Login or Register  to view this content.

Dom

Originally Posted by Simon

Donkey...

Note my edit - I'd omitted a comma in the Clear which will if left unchanged cause problems on re-run (will not purge correctly).