combining data from multiple worksheets

[tuktuk]

would anyone be able to write the code that will combine the data from all rows from all worksheets within a workbook. i've struggled with this one....

here is the deal:

all worksheets have the same columns and column headings but differnet amount of row counts. the width of the sheets is to Column "M" or "13" and there are no blank columns.

There is no need to have the columns headings repeat within the compiled worksheet.

the amount of worksheets will vary depending on when i run it so it will not be able to use specific naming conventions.

thansk so much who help with this one!!!!!

tuktuk

 

[ravishankar]

HI
Tuktuk: Try pasting this piece of code and see if it makes any difference

Worksheets("Master").Range("E:E").NumberFormat = "@"

Winshent: Do you wish to combine/spread data across worksheets?
Ravi