i was advised by dreamboat from a different forum to post my problem here.

heres the post
thanks dreamboat had a look at those links - one works perfectly
but this one
http://www.vbaexpress.com/kb/getart...kb_id=151#instr
does not seem to work.
i have 3 worksheets, with data in
all it copies over is the name of the worksheet into column A and repeats that down the rows for the same number of records
so worksheet 1 called one has 20 rows
worksheet 2 called two has 24rows
worksheet 3 called three has 10 rows
I get in column A
the word one repeated 20 time in the rows
under that I get
the word two repeated 24 times in the rows
under that I get
the word three repeated 10 times

should i be altering the macor for the columns - the code looks like it counts those
I wanted to be able to combine data from a number of worksheets into one worksheet and was advised to look at this site and an example - see url below {seems that anything i type after the url is hyperlinked and underlined }
I tried this on some sample data and it did not work
I have attached an example {note the data will be across about 30 columns } spreadsheet of the worksheets and results.
can anyone advise if i need to make anychanges to this macro to work.



http://www.vbaexpress.com/kb/getarti...b_id=151#instr