Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Working with worksheets in the same workbook
I have 3 worksheets in the same workbook that I want to use the data from.
I am calculating financial ratios. I have 3 worksheets Ratios, Balance Sheet and Income Statement. I need the data from the Balance Sheet and Income Statement to compute the ratios. i.e. to calculate the Quick Ratio I need the information from 2 cells of the Balance Sheet to be divided in the Quick Ratio cell in the Ratio's Sheet. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Working with worksheets | Excel Worksheet Functions | |||
workbook linking cells not working within a workbook | Excel Discussion (Misc queries) | |||
working with multiple worksheets | Excel Worksheet Functions | |||
Working across multiple worksheets | Excel Discussion (Misc queries) | |||
Working with several worksheets | Excel Discussion (Misc queries) |