Userform - copying the title from new sheet to index page

Hi,

Very new to VBA in excel. There are two of us at work trying to sort this.

Using excel 2007

Short background....

The first sheet is called 'Index'. The next sheet is called 'master'

Using a userform it collects 3 pieces of data...a ref number, client name and address.

The code copies the 'Master' sheet and renames it to the ref number (TF) and adds to it the client name (CN) and address (SA).

I can do that no problem.

Please Login or Register  to view this content.

Where TF is the ref number, CN is the client name and SA is the site address.

The next task is to copy those 3 pieces if data that are input via the userform into the 'Index' page as well....and then for every subsequent new record/copied sheet to add its ref number(TF), name (CN) and address (SA).

This is what we have come up with...

Please Login or Register  to view this content.

It sort of works but the problem is that the first record data is added to the index sheet at line 28 as the code. However the next record gets entered down at line 814 for example...if i then run the userform again it the next line of data is at 815, then 816 etc....we are lost as to why or how !!!!!

I have attached a de-personalised version of the spreadsheet.

Any comments appreciated.

Just a thought...does VBA look at cells which are coloured as having data in them?

The index page has cell background color....just a thought.