Offset Formula in Separate Workbook

Hi there

I am using two separate workbooks and would like to offset a cell in Workbook B by one row. The problem is that I need to offset the formula (which references Workbook A) within the cell, and not the cell itself.

E.g. Cell AC4 in Workbook B should reference the formula in Cell S4 in Workbook B and offset it by one row.
The formula in Workbook B Cell S4 is ='[WorkbookA]LocationName'!$B$31
so
The formula in Workbook B Cell AC4 should therefore return the result from ='[WorkbookA]LocationName'!$B$32

Hope this is clear. If anyone could help I would be very grateful.

Thanks!

Hi
Perhaps

Formula:

Please Login or Register  to view this content.

Hi,

I'm not sure I understand what you're getting at. Are you saying you want to use a number in another cell to use as the offset. i.e. if AC4 contains the number 3 you want the S4 formula to offset the B31 cell by 3 and read B34 from the other workbook.

If not I think you need to upload a workbook with some before an after situations so that we can see in context.