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