Find and Replace All not working as it should.

%3CLINGO-SUB%20id%3D%22lingo-sub-2021519%22%20slang%3D%22en-US%22%3EFind%20and%20Replace%20All%20not%20working%20as%20it%20should.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2021519%22%20slang%3D%22en-US%22%3E%3CP%3EFor%20a%20number%20of%20years%20I%20have%20been%20maintaining%20multiple%20spreadsheets%20to%20track%20my%20investments%20and%20I%20maintain%20a%20file%20of%20the%20detail%20data%20from%20month%20to%20month%20and%20also%20a%20summary%20report%20spreadsheet.%20In%20both%20spreadsheets%20I%20copy%2C%20modify%2C%20and%20rename%20them%20with%20a%20mmyy%20code%20so%20I%20end%20up%20with%20a%20copy%20of%20each%20for%20each%20month%20as%20a%20historical%20record.%20Therefore%2C%20each%20month%20I%20modify%20the%20summary%20sheet%20using%20a%20find%2Freplace%20function%20on%20a%20segment%20of%20the%20cell%20command%20that%20extracts%20the%20data%20from%20the%20detail%20sheet%20into%20the%20summary%20sheet.%20For%20some%20weird%20reason%2C%20a%20few%20months%20ago%20the%20normally%20very%20simple%20task%20of%20changing%20the%20portion%20of%20the%20command%20that%20relates%20to%20the%20month%20of%20the%20year%20(changing%20the%20month%20from%2006%20to%2007%20for%20example)%20which%2C%20when%20clicking%20on%20Replace%20ALL%20performed%20the%20change%20on%20all%2080%2B%20cells%20in%20a%20split%20second%20no%20longer%20does%20that.%20It%20now%20finds%20the%20first%20cell%20to%20change%20then%20asks%20for%20more%20directions%20such%20as%20what%20file%20to%20work%20on%20and%20then%20which%20sheet%20within%20the%20file%2C%20and%20repeats%20these%20steps%20for%20every%20cell%20in%20the%20summary%20sheet.%20Or%20it%20doesn't%20and%20circles%20back%20to%20the%20original%20Find%2FReplace%20window.%26nbsp%3B%20To%20see%20the%20sequence%2C%20view%20the%20attached%20file%20showing%20screen%20shots%20of%20each%20of%20the%20windows%20and%20the%20convoluted%20workflow%20that%20presents%20to%20me.%20I%20was%20able%20to%20find%20a%20way%20to%20make%20it%20work%20again%20for%20a%20month%20or%20so%20but%20then%20it%20went%20off%20the%20tracks%20again%20and%20I%20am%20struggling%20to%20understand%20what%20is%20happening.%20Any%20help%20would%20be%20happily%20accepted.%3C%2FP%3E%3CP%3EThanks%20in%20advance...%3C%2FP%3E%3CP%3EFred%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2021519%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

For a number of years I have been maintaining multiple spreadsheets to track my investments and I maintain a file of the detail data from month to month and also a summary report spreadsheet. In both spreadsheets I copy, modify, and rename them with a mmyy code so I end up with a copy of each for each month as a historical record. Therefore, each month I modify the summary sheet using a find/replace function on a segment of the cell command that extracts the data from the detail sheet into the summary sheet. For some weird reason, a few months ago the normally very simple task of changing the portion of the command that relates to the month of the year (changing the month from 06 to 07 for example) which, when clicking on Replace ALL performed the change on all 80+ cells in a split second no longer does that. It now finds the first cell to change then asks for more directions such as what file to work on and then which sheet within the file, and repeats these steps for every cell in the summary sheet. Or it doesn't and circles back to the original Find/Replace window.  To see the sequence, view the attached file showing screen shots of each of the windows and the convoluted workflow that presents to me. I was able to find a way to make it work again for a month or so but then it went off the tracks again and I am struggling to understand what is happening. Any help would be happily accepted.

Thanks in advance...

Fred

 

0 Replies