Hi Guru's
Need help in creating a Macro that updates data in several worksheets.
My data is added on "Sheet1" via a range of validations.
How it works:
I add my Name (Rick) and staff number (123456) (this will be the unique reference), I then select a system by a drop down box which populates a range of sub systems. I then select my level of experience of every sub system within the system I selected.
I then click the add button and a macro sends the data I entered to that Systems worksheet in a single row (colume A will be the name colume B will be the staff number) all other data spreads out on C,D all the way to Colume Q.
When the next staff's details are entered, and for the same system, their details will move to the next row down on the worksheet.
WHAT I WANT IT TO DO.... is if for example I enter my deatils again for the same System, I want it to find my staff number and replace only the changes made in that row. Currently it is adding a new row of data.
Anyone want a challenge?
Heres my Macro
Please Login or Register to view this content.
Bookmarks