Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Not sure if question is "if-then".....
I don't know what this function would be called (which is probably why I
haven't already found an answer!). I use a template for purchase orders and I would like to be able to choose the size/dimensions (Column C) of the piece we are ordering first and THEN have the item number fill in (Column A) once the size is ordered. This is how I am given the part to order - by size/dimension only, never by item number. I have the sizes/dimensions in a validation list currently but I am using copy/paste to fill in the item number. I tried to make a validation list with the catalog number in 1 column and the size/dimensions in the column next to it but it messes up my formatting that way. This is basically how the PO format is laid out: Column A Column B Column C Item# Item Size/Dimension (i.e. OSG404-0312-BN11 Drill Bit 1/32 4FLSE REG CARB BALL-TiAIN) Any suggestions? I hope this makes sense to everyone out there. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Follow-Up (Clarification) to MIN question | Excel Discussion (Misc queries) | |||
Benefits many people - Question | Excel Discussion (Misc queries) | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions |