+ Reply to Thread
Results 1 to 1 of 1

Selecting Data Based on User Input

  1. #1
    Registered User
    Join Date
    St Louis, MO
    MS-Off Ver
    Excel 2007

    Selecting Data Based on User Input

    Hi, I'm an amateur programmer and a noob to Excel, so I'm hoping you can help me out.

    I need set some cells in my sheet based on user input in a cell (before program runs). Basically, if user chooses 1, B1:B5 needs to match data from H6:H10. If the user chooses 2, the B1:B5 needs to use data from I6:1:10, etc. How can I change which column the data is being pulled from?

    Thanks in advance,

    Last edited by famousp; 06-23-2009 at 05:10 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1