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???
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Moving columns from one sheet to another based on user input 2
Variable Column Lookup 7
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How to update data from multiple sheets to one specific sheets 4
pulling from one sheet to another 3
Subtotaling one sheet on another sheet 3
Moving data from one sheet to another 2
moving answer from one sheet to another 1

Back
Top