View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ofcbill ofcbill is offline
external usenet poster
 
Posts: 1
Default 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?