Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
links
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
links
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 --------------- Jacob Skaria "Pammy" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
Links: Re-establishing Links | Excel Discussion (Misc queries) | |||
EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
can't update links...can't find links | Excel Discussion (Misc queries) |