i want to create a excel table, so that if i select date from drop down box, entire table values should change.
eg: If i enter data for month of January, it should be saved. And then if i enter data for Feb, in the same table, it should also be saved.
if i want to go back and look at January's data, i should just select the date from the drop down box for date and then entire data that was saved previously, should populate.
I have created the drop down box for the date, but i dont know how to do for the entire table.
Bookmarks