Need to change a set of cells based on the date (on excel)

June 22, 2012 at 02:09:23
Specs: Windows XP
I need help please. I need to create a basic calender which shows the month on the top and when you click an arrow the month will change and a set of cells underneath will change. I intend to write into the cells details and when i click on the arrow to change the month the data will disappear.

when I click on the arrow to go back a month, I will need this data to reappear.

I would appreciate any help.

I have created the arrows that change the month.


See More: Need to change a set of cells based on the date (on excel)

Report •


#1
June 22, 2012 at 17:21:21
Why not just create a new tab for each month and switch to the tab for the month you are interested in?

Visually you would accomplish the same goal and you could go directly to any month you wanted.

How have you created arrows to change months?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question