links

P

Pammy

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?
 
J

Jacob Skaria

Please let us know the formula you have..

When you say "pulling input information from sheet to sheet to my Totals
Workbook". Is this pulling the sum or count from Sheet1 to Sheet52..??

If so you might be able to use the below formula which gives you the sum or
count from all sheets in your Total sheet.

=SUM(Sheet1:Sheet52!A1)
will adds up the total of cell A1 in all sheets from Sheet1 to Sheet52.. Not
sure whether this will be helpful...


If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top