Hi I have a excel budget template that i am working on. i want to automate the daily expenses in 4-week periods.
day 1-7 week 1
day 8-14 week 2
day 15-22 week 3
day 23-31 week 4
in other words, i only have to file the daily expenses and everything else will be automated.
in addition, i would like to have resume graphs that represent real vs budget sub-categories, and categories.
FINALLY after using vlookup and if function, the file is a bit slow, i need it to be fast, please.
i dont mind using macros if needed. i just need the data entry to be as minimal as possible.