This is difficult to explain so please bear with me.
i need to select Si from the table below. At present the user has to select assy = 1 and notes = 2 to get Si = 1111 to be displayed (Comboxes in a user form are used to select the data). The SI data is entered in to a spreadsheet.
If possible i would like for the user to select NOTES = 2 (from the combox, this part isnt a problem) and then for the Si info to be be entered in to the spreadsheet, then i would like the data to be deleted and then for the next set of data for Notes=2 to be enterd in this case it would be where assy=2
ID Assy NOTES Si
1 1 2 1111
2 1 2 1111
3 2 3 2222
4 2 3 2222
5 2 3 2222
6 3 4 3333
7 3 4 3333
8 3 4 3333
9 3 4 3333
10 4 2 4444
11 4 2 4444
I know this is longwinded, i applologise for this - but its the only way i could get what im trying to say accross.
Thanks for reply and thanks for reading this (if you made it this far)
i need to select Si from the table below. At present the user has to select assy = 1 and notes = 2 to get Si = 1111 to be displayed (Comboxes in a user form are used to select the data). The SI data is entered in to a spreadsheet.
If possible i would like for the user to select NOTES = 2 (from the combox, this part isnt a problem) and then for the Si info to be be entered in to the spreadsheet, then i would like the data to be deleted and then for the next set of data for Notes=2 to be enterd in this case it would be where assy=2
ID Assy NOTES Si
1 1 2 1111
2 1 2 1111
3 2 3 2222
4 2 3 2222
5 2 3 2222
6 3 4 3333
7 3 4 3333
8 3 4 3333
9 3 4 3333
10 4 2 4444
11 4 2 4444
I know this is longwinded, i applologise for this - but its the only way i could get what im trying to say accross.
Thanks for reply and thanks for reading this (if you made it this far)
