Very new to VBA in excel. There are two of us at work trying to sort this.
Using excel 2007
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.
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...
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.