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!