SOLVED

Excel Document Issue - Laptop

%3CLINGO-SUB%20id%3D%22lingo-sub-2245524%22%20slang%3D%22en-US%22%3EExcel%20Document%20Issue%20-%20Laptop%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2245524%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20issues%20with%20this%20document%20again.%26nbsp%3B%20I%20am%20not%20used%20to%20working%20in%20Excel%2C%20have%20very%20limited%20knowledge%20of%20Excel%20and%20I%20am%20not%20real%20familiar%20with%20the%20terminology%20used%20within%20Excel%2C%20so%20please%20take%20this%20into%20consideration%20when%20and%20if%20you%20are%20gracious%20enough%20to%20respond.%3C%2FP%3E%3CP%3EThe%20document%20attached%20was%20created%20by%20the%20previous%20admin.%26nbsp%3B%20I%20copied%20the%20whole%20document%2C%20from%20an%20old%20job%20that%20was%20completed%20in%20September%2C%20into%20a%20new%20folder%20which%20started%20a%20new%20job%20that%20we%20began%20in%20November.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20take%20information%20that%20is%20given%20to%20me%20and%20enter%20into%20the%20document.%26nbsp%3B%20There%20is%20information%20on%20the%20top%20of%20the%20page%20and%20the%20bottom%20of%20the%20page%20that%20I%20am%20having%20issues%20with.%26nbsp%3B%20I%20add%20these%20numbers%20from%20one%20week%20to%20the%20following%20week%20and%20continue%20to%20the%20following%20week%2C%20etc.%20and%20the%20numbers%20total%20each%20week%2C%20taking%20totals%20from%20the%20beginning%20of%20the%20document%20(week%201%2C%20Nov%2030-Dec%206)%20)%20to%20the%20last%20page%20of%20the%20document%2C%20which%20will%20be%20approximately%20(week%20%3F%2C%20Sept%2020-26)%20.%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EEach%20week%20when%20I%20copy%20and%20paste%20a%20new%20page%20into%20the%20document%2C%20I%20have%20to%20go%20in%20and%20re-enter%20the%20formula%20for%20each%20cell%20because%20it%20is%20not%20carrying%20over%20the%20formula%20from%20the%20previous%20week.%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20told%20to%20just%20copy%20and%20pasted%20the%20document%20and%20the%20formulas%20would%20transfer%20over.%26nbsp%3B%20I%20have%20copied%20and%20pasted%20by%20highlighting%20the%20content%20from%20one%20page%20and%20then%20going%20to%20the%20next%20page%20and%20highlighting%20and%20pasting.%26nbsp%3B%20I%20have%20also%2C%20clicked%20ctrl%20and%20drag%20the%20document%20to%20the%20right%20on%20the%20bottom%20toolbar.%26nbsp%3B%20I%20hope%20I%20am%20making%20sense%20in%20explaining%20my%20dilemma.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%20and%20thank%20you%20for%20your%20assistance!!%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3ETerrie%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2245524%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2246257%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Document%20Issue%20-%20Laptop%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2246257%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F903899%22%20target%3D%22_blank%22%3E%40sumrall90%3C%2FA%3E%26nbsp%3BOh%20my!%20what%20an%20awful%20workbook.%20The%20designer%20made%20the%20classic%20mistake%20of%20trying%20to%20combine%20capturing%20data%20and%20making%20a%20summary%20report%20in%20the%20same%20sheet.%20But%20since%20it%20seems%20to%20fulfil%20the%20needs%20of%20the%20organisation%2C%20I%20made%20a%20few%20adjustments%20to%20the%20last%20sheet.%20All%20formulae%20that%20refer%20the%20the%20previous%20week's%20sheet%20are%20now%20fixed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENext%20week%20(Apr%205-12)%20you%20can%20create%20a%20sheet%20for%20the%20new%20week%2C%20like%20you%20always%20have%20done.%20The%20formulae%20will%20NOT%20automatically%20%22roll-forward%22%20one%20week.%20They%20will%20still%20point%20to%20sheet%20%22Mar%2022-28%22.%20But%2C%20no%20panic.%20You%20can%20use%20%3CEM%3EFind%20and%20Replace%3C%2FEM%3E%20to%20update%20the%20references%20in%20one%20go.%20No%20need%20to%20re-enter%20each%20formula%20one-by-one.%20%26nbsp%3BSelect%20the%20entire%20sheet%20for%20the%20new%20week.%20Press%20Ctrl-H.%20A%20Find%20and%20Replace%20window%20opens.%20In%20the%20Find%20box%20type%20%3CSTRONG%3EMar%2022-28%3C%2FSTRONG%3E.%20In%20the%20Replace%20box%20you%20type%20%3CSTRONG%3EMar%2029-Apr%204%3C%2FSTRONG%3E.%20Replace%20All.%20Now%2C%20all%20references%20to%20the%20'old%20previous%20week'%20have%20been%20updated%20to%20the%20'current%20previous%20week'.%20Do%20the%20same%20thing%20every%20week%20from%20now%20on.%20Find%20the%20name%20of%20the%20old%20reference%20(like%20Mar%2029-Apr%204)%20and%20replace%20it%20by%20the%20new%20reference%20(like%20Apr%205-12).%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I am having issues with this document again.  I am not used to working in Excel, have very limited knowledge of Excel and I am not real familiar with the terminology used within Excel, so please take this into consideration when and if you are gracious enough to respond.

The document attached was created by the previous admin.  I copied the whole document, from an old job that was completed in September, into a new folder which started a new job that we began in November. 

I take information that is given to me and enter into the document.  There is information on the top of the page and the bottom of the page that I am having issues with.  I add these numbers from one week to the following week and continue to the following week, etc. and the numbers total each week, taking totals from the beginning of the document (week 1, Nov 30-Dec 6) ) to the last page of the document, which will be approximately (week ?, Sept 20-26) .    

Each week when I copy and paste a new page into the document, I have to go in and re-enter the formula for each cell because it is not carrying over the formula from the previous week.   

I was told to just copy and pasted the document and the formulas would transfer over.  I have copied and pasted by highlighting the content from one page and then going to the next page and highlighting and pasting.  I have also, clicked ctrl and drag the document to the right on the bottom toolbar.  I hope I am making sense in explaining my dilemma.  

Please help and thank you for your assistance!!  

Terrie

5 Replies
best response confirmed by sumrall90 (Occasional Contributor)
Solution

@sumrall90 Oh my! what an awful workbook. The designer made the classic mistake of trying to combine capturing data and making a summary report in the same sheet. But since it seems to fulfil the needs of the organisation, I made a few adjustments to the last sheet. All formulae that refer the the previous week's sheet are now fixed.

 

Next week (Apr 5-12) you can create a sheet for the new week, like you always have done. The formulae will NOT automatically "roll-forward" one week. They will still point to sheet "Mar 22-28". But, no panic. You can use Find and Replace to update the references in one go. No need to re-enter each formula one-by-one.  Select the entire sheet for the new week. Press Ctrl-H. A Find and Replace window opens. In the Find box type Mar 22-28. In the Replace box you type Mar 29-Apr 4. Replace All. Now, all references to the 'old previous week' have been updated to the 'current previous week'. Do the same thing every week from now on. Find the name of the old reference (like Mar 29-Apr 4) and replace it by the new reference (like Apr 5-12).

Thank you so much Riny van Eekelen! I am going to save this document again in a different location so I can work on it and not mess us the issues you fixed and then try what you told me to do for the following weeks! I appreciate your help!!
Well, I have an error message that comes up when I try this. "We couldn't find anything to replace. Click options for more ways to search." "FYI: It's possible the data you're trying to replace is in a protected sheet. Excel can't replace date in protected sheets."
I am sure I am not doing something correct. Any suggestions or fixes for me to correct what I am doing wrong?
Thank you!!

@sumrall90 Well the first obvious suggestion is to be absolutely sure that you typed the sheet names names exactly as you have them. That is, no quotation marks or spaces that aren't in the actual sheet name. Tried it my self on the file you uploaded. Worked perfectly.

Thank you again for your help! I was not entering the dates correctly...I knew it was something I was doing wrong. Thank you!!!!!!!