Moving data in one excel column to another sheet based on user input

  • Thread starter Thread starter mweigel
  • Start date Start date
M

mweigel

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???
 
Back
Top