agnesz
09-01-2009, 02:40 PM
I have this spreadsheet that lists locations vertically and days horizontally. Each location has a plan as does each day. Is there any formula/macro that can adjust each day for each location to hit the that day's plan and that location's plan???
I am attaching a report as a sample. If you row 3. That location is under $26 to the plan and each day should be adjusted to hit that number, but keeping in mind that each day also has to hit the plan. As you can see though there is more than one location???
I don't even know if this is possible, but figured I could at least put it out there. Right now we do this manually and it is becoming impossible to deal with because I have a lot more locations than that.
any thoughts/suggestions would be super appreciated!:help
I am attaching a report as a sample. If you row 3. That location is under $26 to the plan and each day should be adjusted to hit that number, but keeping in mind that each day also has to hit the plan. As you can see though there is more than one location???
I don't even know if this is possible, but figured I could at least put it out there. Right now we do this manually and it is becoming impossible to deal with because I have a lot more locations than that.
any thoughts/suggestions would be super appreciated!:help