rhino4eva
Active Member
- Joined
- Apr 1, 2009
- Messages
- 260
- Office Version
- 2010
- Platform
- Windows
So i work in a laboratory , we currently have data that comes out in a specific non numerical order. I Cant sort these positions as there are fixed.
We that have to do 1of 4 tests on these specimens. Not all specimens get all tests, its kind of cherry picking. The request forms we receive are in numerical order.
So here's the thing . I can design a userform to have a number box and four tick boxes. What i'm not sure about is how to search in column "A" for a the 7 digit lab number and transfer the tick correct selection from the userform to the master sheet
i don't know whether its a vlookup in the vba or a match/index search i need
any help would be gratefully recieved
We that have to do 1of 4 tests on these specimens. Not all specimens get all tests, its kind of cherry picking. The request forms we receive are in numerical order.
So here's the thing . I can design a userform to have a number box and four tick boxes. What i'm not sure about is how to search in column "A" for a the 7 digit lab number and transfer the tick correct selection from the userform to the master sheet
i don't know whether its a vlookup in the vba or a match/index search i need
any help would be gratefully recieved