| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
if then insert and add
I am trying to put together a bill of materials for requesting hardware quotes.
My worksheet has drop down validation for getting the part numbers and descriptions. What i need to happed is that when I a certain part number is selected it automatically inserts a row below with another part numer and quantity. There are several partnumbers that would need to generate the same additional required part number. How can I tell it that if "Part A" selected add "Part C with qty X" or "Part B" selected add "Part C with qty Y" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert new Worksheet with name, and insert the sheet into itsalphabetical / numerical location | Excel Programming | |||
| insert row / insert column command buttons | Excel Worksheet Functions | |||
| How can I insert a date with an icon (calendar) insert | Excel Discussion (Misc queries) | |||
| Macro to insert copy and insert formulas only to next blank row | Excel Programming | |||
| Insert cell/format/text/fontsize and auto insert into header? | Excel Programming | |||
Threaded Mode
