Formulas between sheets

[vania]

I hope I can exlpain this. I have two sheets, the formula I am using in sheet 2 is =A1+'Sheet 1'!A1. This gives me the correct formula but when I copy a third worksheet I need the formula to be between worksheet 2 and 3 instead of 1 and 2. Is there a way to write a formula that adds the previous worksheet info instead of always going back to sheet 1. Please help...thank you!!!

 

[Andrew Poulsom]

Maybe this will help you:

http://spreadsheetpage.com/index.php/tip/a_custom_function_for_relative_sheet_references/

 

[vania]

Thank you....i went to that link and here is the formua i used =SHEETOFFSET(-1,E17)+D17 when I did this #NAME? was the error I got in that cell.

 

[Andrew Poulsom]

You need to copy the function into a General module in the Visual Basic Editor.

 

[vania]

Never mind...That worked perfectly!!!!! Thank you!!!!!!!!