I am in the food service industry and I have a sheet filled with data on what we sold. I use this data to "forcast" the upcoming period. The first 5 col's are filled with REAL numbers on what we sold. It then averages everyday, every item. The second 5 col's are pars that are bumped up so we are always ahead.
I then have other formulas off to the side to figure usage, pounds, counts so on and so forth.
All I want to do is have a macro to have it switch variables to these cells (wed,thu,fri,sat,sun,mon,tue) from the real averages and the pars.. So anywhere it is now hardcoded to read from the par rows, it can switch to the other.
Bookmarks