I need to input data into worksheet 1 "dataentry" and then extract the data from that record into worksheet 2 and then repeat this for the next record etc..
I would use the data list option to enter data but I can change the form in worksheet 1 (this has been set up my company)
Each record has a unique identifier, all data inputed will be in the green cells.
See attached file
Dave
Bookmarks