Hello Excel Experts! I've made a worksheet that includes 1200+ cells that
are linked to another workbook which houses monthly totals. The worksheet I
created is my "June" worksheet and I plan to use this as a template and copy
to blank worksheets, and do a Find "June" and Replace with "July", and so
on...to create a sheet and get totals from every month. This works, but
takes about an hour to do the Find and Replace on each month. Is there a
faster way to replace text in formulas when there are this many? I've tried
switching "calculation" to "manual" under options, thinking that it would
update at the end, rather than after each cell replacement. But, no luck.
Any ideas would be GREATLY appreciated!! Thanks!

Hi
are you using the "Replace" or the "replace ALL" button?
With "replace all", I can imagine you would do this only once on each
worksheet (replace all June by July in one click so 12 times only, right?

"ClintG" wrote:

Hello Excel Experts! I've made a worksheet that includes 1200+ cells that
are linked to another workbook which houses monthly totals. The worksheet I
created is my "June" worksheet and I plan to use this as a template and copy
to blank worksheets, and do a Find "June" and Replace with "July", and so
on...to create a sheet and get totals from every month. This works, but
takes about an hour to do the Find and Replace on each month. Is there a
faster way to replace text in formulas when there are this many? I've tried
switching "calculation" to "manual" under options, thinking that it would
update at the end, rather than after each cell replacement. But, no luck.
Any ideas would be GREATLY appreciated!! Thanks!

Thanks Frederique...Yes I am using "Replace All" on each sheet. There are
1200+ cells where "June" needs to be replaced by "July". So yes, I will need
to do this replacement process 12 times (11 actually, since my June sheet is
already done). When there are several hundred replacements, does it just
take a long time?

Thanks!!


"Frederique" wrote:


Hi
are you using the "Replace" or the "replace ALL" button?
With "replace all", I can imagine you would do this only once on each
worksheet (replace all June by July in one click so 12 times only, right?

"ClintG" wrote:

Hello Excel Experts! I've made a worksheet that includes 1200+ cells that
are linked to another workbook which houses monthly totals. The worksheet I
created is my "June" worksheet and I plan to use this as a template and copy
to blank worksheets, and do a Find "June" and Replace with "July", and so
on...to create a sheet and get totals from every month. This works, but
takes about an hour to do the Find and Replace on each month. Is there a
faster way to replace text in formulas when there are this many? I've tried
switching "calculation" to "manual" under options, thinking that it would
update at the end, rather than after each cell replacement. But, no luck.
Any ideas would be GREATLY appreciated!! Thanks!