| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving data in one excel column to another sheet based on user input
I have a spreadsheet that contains all my data on sheet1. The columns
have Years as headings and dollar amounts underneath them. I have a drop down list for the user to pick the year from in cell R2. Whatever year they choose I want the appropriate column to move to sheet 3. Ex. if they choose 2009 I want Column M to move to sheet 3, if they choose 2010 I want column N to move to sheet 3. Any ideas??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Incrementing Data based on user input | Excel Discussion (Misc queries) | |||
| I would like to sort a work sheet based upon user input value,(dat | Excel Worksheet Functions | |||
| I would like to sort a work sheet based upon user input value,(dat | Excel Worksheet Functions | |||
| Retreive data based on multiple column input | Excel Worksheet Functions | |||
| Finding a record based on user input | Excel Discussion (Misc queries) | |||
Threaded Mode
