Printable View
I could use some help with these formulas. I have a spreadsheet I am working on that has 1 workbook with several sheets. I go to my total sheet which is Sept-June and in the column for each month I type the = sign I then hit the tab at the bottom for Oct and go to the total column and hit enter. This creates the relationship for the individual months. I have attached the file I need to do. Is there a quicker way to do this instead of doing each cell individually.
I appreciate any help.
My interpretation of this is that you want to include all the formulas in the Sept - June sheet as easily as possible.
You kept everything consistent on each sub-sheet. That's nice, and it makes working with everything so much easier.
On the Sept - June Sheet:
1. Click cell C4 and enter =Sept!$AH5
This is the reference for the equivalent value on the Sept sheet.
2. Drag cell C4 over to L4
This duplicates cell C4 of to column L
3. Change each cell to the appropriate MONTH in each cell from C4 to L4 with no other changes.
Now each cell in row 4 should be specified with its related month and referencing the total in column AH row 5 for each month.
4. Highlight from C4 to L4 and drag down to row 44
All references will change to the equivalent reference on their monthly sheets.
5. Highlight all the blank rows, right click, and select CLEAR CONTENTS.
Do this for each empty row, and you are done.
NOTE: A quick way (if you don't make a mistake) to clear the contents of all empty rows at once:
1. Select C7, SHFT+R.ARROW TO L7
2. Press Ctrl and click C10
3. Shft+R.Arrow to L10
4. Press Ctrl and click C13
You should get the picture by now, so
5. Continue the above for all empty rows.
6. Right click, select CLEAR CONTENTS.
7. Done!
I would also include the TOTAL row to reference each MONTHLY sheet, but the formulas you are already using work well too.
Thanks so much for the reply. I will work on this soon. You gave so much more information than I found in books etc. My wife will be pleased that I can finish this up for her.
Thanks again, I really appreciate it.
After successfully applying the formula <=SUM(C4:L4)>, highlight the cell, then drag the formula from the lower right corner of the cell to the last cell <M48>.
Hope this helps..........
I have completed my mission rather quickly to say the least. Your help was great and it when exactly as you advised. Thanks again for your help.
Glad I could help Coach17 :)