Hi,
Im looking for help, i have 5 userforms which are all linked to the same spreadsheet.
The spreadsheet is to log Non-Conformances. The reference number will start with "NC0001" and then go up sequentially.
The userforms are labelled Part1, Part2 to Part5.
Everytime i enter details on the userforms and submit, it automatically goes to the bottom of the list, what im looking for is to have some sort of lookup so when i enter details from "Parts2-5" it will lookup the value entered and then continue to fill the rest of the row in.
Any ideas of what code i need?
Im looking for help, i have 5 userforms which are all linked to the same spreadsheet.
The spreadsheet is to log Non-Conformances. The reference number will start with "NC0001" and then go up sequentially.
The userforms are labelled Part1, Part2 to Part5.
Everytime i enter details on the userforms and submit, it automatically goes to the bottom of the list, what im looking for is to have some sort of lookup so when i enter details from "Parts2-5" it will lookup the value entered and then continue to fill the rest of the row in.
Any ideas of what code i need?