Creating multiple sheets depending a cell count

A bit rough and ready, but try this ...

Please Login or Register  to view this content.

Brilliant! Thanks for the quick response and the great code. Keep up the great work and have a marvelous day.

Can I ask you to make one tweak to the code? Can you instead copy all information on that first tab and have it pasted on each subsequent tab?

So instead of add sheets, do a copy sheet, and have that A1 cell replaced based on sheet.1 column.a data.

I can clarify if you need a better understanding

Yup, this isn't quite as neat as it will start inserting after any additional sheets that exist in the workbook, but other than having to delete 1 or 2 surplus sheets it should be fine...

Please Login or Register  to view this content.

Couldn't you build the code such that:

If number of entries in column A = 5, copy/paste all information onto 5 sheets
then
copy A1 to sheet.2 A1
copy A2 to sheet.3 A1
copy A3 to sheet.4 A1

Thank you - I really appreciate your help.

It's a pain cutting and pasting data, rather than whole sheets, but this should produce the same results:

Please Login or Register  to view this content.

There we go!

Thanks so much again. I really appreciate the time you take out of your day to do this. Have a wonderful day/week/month/year/life