Hi all,

After some more research & trial & error I think I am on the right track but my syntax is wrong. Hopefully this will help explain what I'm trying to do.

We have a template to create a monthly analysis workbook. It contains a sheet for each day (labeled 1,2,3...etc), a sheet named 'Check Register' and a sheet named 'Last Years Numbers'.

Here is the file path:
C:\Users\(Username)\Desktop\Cash Reconciliation\(Year)\(Month).xls

In the past we have gone to the previous years sheet, for example-this month we open the 10/2013 workbook and copy the needed data then "Paste Value" in to the 'Last Years Numbers' sheet of the 10/2014 workbook.

We are wanting to make it more automatic so there is no potential for pasting errors. The date is entered onto sheet '1'!B3.

Here is the formula I think will work with the correct syntax:

=C:\Users\Username\Desktop\Cash Reconciliation\=Year('1'!B3)-1\'[=Month('1'!B3)]Check Register'!G35

Am I on the right track?

Thank you for any help on this.
Jeremy