Working with worksheets in the same workbook

O

ofcbill

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?
 
P

Per Jessen

Hi

In the Quick Ratio cell type an equal sign, then select the Balance Sheet
and click on the desired cell, enter division sign and select divisor cell.

Regards,
Per
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top