Click here for important information about

How Do I Change Excel Formulas?

Microsoft Microsoft office excel 2007 ac...
January 4, 2010 at 18:52:08
Specs: Windows Vista
Is their any way of saving me time instead of manually changing every formula for example.. in excel spreadsheets?

='C:\Users\Liane\Documents\[salesreport201209.xls]Food calc'!$E$49

='C:\Users\Liane\Documents\[salesreport271209.xls]Food calc'!$E$49

='C:\Users\Liane\Documents\[salesreport030110.xls]Food calc'!$E$49

All im wanting to do is have the same formula but change the date instead of going through and changing it myself?

See More: How Do I Change Excel Formulas?

January 4, 2010 at 20:23:55
Maybe I'm missing what you are aking for?

Have you tried Edit...Replace?

For multiple changes use Replace All

Report •
Related Solutions

Ask Question