Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calling up cells from a table.
I'm trying to create a form that draws information from a table on a
seperate spreadsheet. This is an order form and the table carries the product information....see below. What I need is when the user selects a product and color, the adjacent cells in the product table, with values and formulas, are copied to the form. Item Color Quantity Weight Units/row Paleo Beige 123 23.5lbs 42 Bergerac Grey 123 32 lbs 38 So if I have a drop down list on another sheet that chooses Paleo, then the adjacent formulas and cells from the table would be copied over. Maybe I should be doing this through a macro tied to a button. Thanks again for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you divide two cells in a pivot table to equal a %? | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
removing the word (blank) from pivot table cells | Excel Discussion (Misc queries) | |||
Excel - pivot table - how do i format cells with data mm/dd/yyyy . | Excel Worksheet Functions | |||
formulas referencing pivot table cells | Excel Worksheet Functions |