I have a Totals workbook with 52 sheets for 52 weeks of the year, the formula
in the cells are linked from cells in an input workbook. Somehow, I have
linked the wrong cell in several of my formulas. (on my totals workbook, one
cell should be pointing to "G32 sheet 1 input" from the input workbook but
instead it is pointing to "J32 sheet 1 input") , and sheet 2 should be "G32
sheet 2 input" instead of J32, etc. and this is pulling input information
from sheet to sheet) to my Totals Workbook. Is there a way to change the J
to G without having to do all 52 worksheets manually?