| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
One worksheet to calulate different items simultaneously
I have one worksheet (WORKSHEET 1) that I use to calculate the price of a
product. This worksheet needs manual input from 13 cells to calculate the end result. Now I want to create a second overview worksheet (WORKSHEET 2) that lists all the products with their price. The overview worksheet should look like a table with many rows. On each row I want to enter the input data. This data is used by WORKSHEET 1 to calculate the price of each product. WORKSHEET 1 reads the input data from the first row in WORKSHEET 2 and displays the price in WORKSHEET 2 Then it reads the input data from the second row in WORKSHEET 2 and displays the price in WORKSHEET 2 etc. etc. Anybody go a clue on how to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How many items can a pivot table hold? i.e. a worksheet taps out . | Excel Discussion (Misc queries) | |||
| Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
| Is it possible to copy only selected items to another worksheet... | Excel Worksheet Functions | |||
| Linking items GREATER THAN O on another worksheet in the same Work | Excel Discussion (Misc queries) | |||
| Worksheet name and Backward compatibility | Excel Discussion (Misc queries) | |||
Threaded Mode
