Hey
I will really appreciate if you can help me
Every day I need to do a presentation using graphics containing sales of the last week, that is, the last seven days. So, every day I ad data in the sheet, but I need to do manual change in intervals to change the graphics too, because I need to consider the new day and eliminate the last day.
Actually, the graphics contain comparison of sales of seven last days, for the current and last two weeks, so I have a lot of intervals to change.
I've heard there's a way to do it with VBA, but I'm new using these tools, so if you could give a hand I will really appreciate it.
Tks
I will really appreciate if you can help me
Every day I need to do a presentation using graphics containing sales of the last week, that is, the last seven days. So, every day I ad data in the sheet, but I need to do manual change in intervals to change the graphics too, because I need to consider the new day and eliminate the last day.
Actually, the graphics contain comparison of sales of seven last days, for the current and last two weeks, so I have a lot of intervals to change.
I've heard there's a way to do it with VBA, but I'm new using these tools, so if you could give a hand I will really appreciate it.
Tks
