Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Help: Keeping Data
Using a spreadsheet book I am using multiple tabs. In one tab I have a drop
down list of "Customers", "Sales Price", "Quantity" and "Products." I have another tab that has "if" & "and" functions that test to see what "Customers", "Sales Price", "Quantity" and "Products" are being referred to. What I want to do is have Excel record the data when I am referring to a specific customer/product/price/quantity, but when I pick a new customer from the drop down list I want the data for previous customer to remain. As of now when I choose one customer the other customers data turns to "False" given the if & and functions. How can I have the data change only when I refer to it via the drop down list and not change when I am not referring to it in the drop down list. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping data together using Query | Excel Discussion (Misc queries) | |||
Keeping pictures with data | Excel Worksheet Functions | |||
Adding data to celss but keeping the remaining data intact. | Excel Discussion (Misc queries) | |||
Copy old Data from web query while keeping previous days data | Excel Worksheet Functions | |||
Using Max & keeping other data | Excel Worksheet Functions |