Inputting data in different columns via input template(sheet) which changes by dropdown.

brightoke

New Member
Joined
Apr 30, 2013
Messages
1
I would like to create a template for inputting 20 pieces of data on a weekly basis. The data will ultimately be presented on a seperate sheet with week 1 to 52 as column titles and the 20 parameter titles down the first column.

For the input sheet I would like to have 20 blocks and a dropdown selector. When 'Week 2' (for example) is selected in the dropdown, I would like the user to input 20 numbers in the boxes on the "Input sheet", and these will then store themselves in the Week two column on the results sheets ( another sheet) vertically. When the user changes the dropdown to 'week three', I would like all data inputted into the same boxes to store in the 'week three' column.and ditto for 52 weeks!
You should also be able to review and change the data by just changing the dropdown selection on the "Input" sheet.

It would be preferable to do this all with formulae and not macros. Can this be done?

If not , what would be the macro to make this happen?
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Watch MrExcel Video

Forum statistics

Threads
1,108,855
Messages
5,525,229
Members
409,637
Latest member
LT TASL

This Week's Hot Topics

Top