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,
famousp
Bookmarks