lucky12341
Board Regular
- Joined
- Nov 4, 2005
- Messages
- 121
Got stumped and even professor is a bit confused on this...
We are tracking things in a warehouse for our school and the basic file layout is like so:
Location P.O. Item # P/N Pc Mark etc.
111A1
111A2
111A3
111B1
etc.
Is there a way to ENTER data into single row and have it find that location and enter in the corresponding data, example:
Location: 111F2 P.O.: 2156-365 etc.
Then have excel find this location and enter the data into that line? I am not accustomed to macro or VBA very well and am unsure if this is possibel.
We are tracking things in a warehouse for our school and the basic file layout is like so:
Location P.O. Item # P/N Pc Mark etc.
111A1
111A2
111A3
111B1
etc.
Is there a way to ENTER data into single row and have it find that location and enter in the corresponding data, example:
Location: 111F2 P.O.: 2156-365 etc.
Then have excel find this location and enter the data into that line? I am not accustomed to macro or VBA very well and am unsure if this is possibel.