In Excel I can reference a cell in another worksheet/workbook, is this possible using Financial Reporter? If so how can I do it?

Hi,

Yes, you can. Use the reference function QUERYSHEET.

Following is from the Financial Reporter online Help:

QUERYSHEET(S, C [, F [, D [, Y])

Description

Returns the contents of the cell reference C from the sheet S calculated for the Fiscal Period F using Department D in Fiscal Year Y. If the optional parameters, fiscal period, department and fiscal year, are not passed then the current contents of the cell are returned. You cannot use this function to reference a cell on the same sheet. If a Named Range is used then the value from the top left cell in the Named Range is returned.

Parameters

S Sheet name
C Cell reference or Name Range
F Optional fiscal period
D Optional Department (if used then the Fiscal Period must also be used)
Y Optional Year (if used then the Fiscal Period and Department must also be used; values are 0 for current year, 1 for prior year, 2 for two years ago, etc.)

Example

Sheet 2 Cell A10 contains 99

If a cell in Sheet 1 has =QuerySheet(“Sheet 2”,”A10”) then 99 will be returned.

Sheet 2 Cell A10 has =ADGET(“GLDATA.Bal”,1000) = 347.67

If a cell in Sheet 1 has =QuerySheet(“Sheet 2”,”A10”) then the numeric value 347.67 will be returned.

If a cell in Sheet 1 has =QuerySheet(“Sheet 2”,”A10”,3,”100”) then Sheet 2 will be recalculated for Fiscal Period 3 and Department 100 and the resulting value will be returned.

If a cell in Sheet 1 has =QuerySheet(“Sheet 2”,”A10”,3,”100”,1) then Sheet 2 will be recalculated for Fiscal Period 3, Department 100 and the prior fiscal year, and the resulting value will be returned.

Using QuerySheet you can reference other worksheets in the same workbook. You cannot reference a worksheet in a different workbook.