| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Accessing Cells in Separate Worksheet
I have a list of a bunch of prices which I total up by month at the bottom of the worksheet. What I want to do is instead of totally up the prices at the bottom, I want to move the total to another worksheet and keep the original sheet just for raw data. But right now, all my formulas and math assumes the cells I am totally are in the same sheed, if I move all that, it will not be looking at the correct cells. How can I tell the formula to get the value from another worksheet? -- mrjeffy321 ------------------------------------------------------------------------ mrjeffy321's Profile: http://www.excelforum.com/member.php...o&userid=30618 View this thread: http://www.excelforum.com/showthread...hreadid=502726 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula references vertical cells in a separate worksheet | Excel Worksheet Functions | |||
| Find & Replace within Unlocked Cells in a Protected Worksheet | Excel Discussion (Misc queries) | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
| Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Threaded Mode
