Assume a worksheet with formulas referring to the previous worksheet.  When this sheet is copied by right clicking the sheet and selecting Move or Copy > Copy, formulas in this newly created sheet, should change to refer to the previous sheet.

In other words, if sheet2 has formulas referring to sheet1, then when sheet3 is created (by Move or Copy > Copy of sheet2), the formulas in sheet3 should refer to sheet2.

You may refer to my solution and Instructions in this workbook.

• Hi,

You may refer to my solution in this workbook. Please note the following:

1. Ensure that the table which shows the summary of every worksheet is in range E39:F41. I have done this for the first four worksheets. Please do the same for the rest.
2. Copy range I39:L43 of the FEB 2014 worksheet and paste it in cell I39 of each worksheet. I have done this till APR 2014

Hope this helps.

• Larry says:

Very Much !! Thank you so much Ashish and also for your patience with me

• Brittany says:

I have formated my table to include a cell referencing the current tab name and another cell referencing the previous tab name.

From there I have a table of products all with pricing. My goal is to reference the previous tab to update the table with a change in pricing column.
I’m using the following formula.

=+C5-IFERROR(INDIRECT(“‘”&\$D\$2&”‘!C5″),””)

Because the “C5” referencing the previous tab is within the “” it is propagating down the list as C5 and not changing to C6… C7… C8 and so on.

Is there a way to get the formula to update down the column?

Thank you.

• Hi,

Assuming you are writing that formula in cell row 17 (any column), try this

=C5-IFERROR(INDIRECT(“‘”&\$D\$2&”‘!C”&ROW()-12),””)

• Fábio says:

Hello, Ashish Mathur!