Hello all, I have twelve tables on a sheet, one for each month. Additionally, I have one table at the top of the sheet that I want to use to make entries based on a drop down list.
I'm trying to think of a way for the user to select the month from the drop down and it then updates the corresponding table. IE, user selects March and then punches numbers into the table and those numbers go to the March table, user changes to May, and then the entry table clears out, the March numbers stay in March and then the user can start adding May's numbers and so on.
I can do it with VBA or just formulas, whatever works best. I should maybe mention that all the tables share identical columns and rows. Thoughts?
Thanks for any help
I'm trying to think of a way for the user to select the month from the drop down and it then updates the corresponding table. IE, user selects March and then punches numbers into the table and those numbers go to the March table, user changes to May, and then the entry table clears out, the March numbers stay in March and then the user can start adding May's numbers and so on.
I can do it with VBA or just formulas, whatever works best. I should maybe mention that all the tables share identical columns and rows. Thoughts?
Thanks for any help
