• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Column Change Based on Dropdown Selection

C

Choname

New Member
Hi,

Not sure if I'm even phrasing this right, but essentially I would like to have a sheet set up so that for example, Column A is a static, locked list of parameters and in B1 I have a dropdown list with selections (ie: Data Set 1, Data Set 2, Data Set 3). When I select Data Set 1 from the dropdown, I would like the column below (B2-B50) to show up blank and allow data entry values based on corresponding parameters in column A. Then when I select Data Set 2, the column B2-B50 ends up blank again allowing for a different data set.

Is there a way to accomplish this? Thank you in advance for any help!
 
Choname

Firstly, Welcome to the Chandoo.org Forums

I would suggest that you upload a sample file with what ever data you have

If you want 2 or 3 entry screens, examples will be required
If you want to simply calculate values that may be simple, but if you want to store the data it may require the use of VBA code
 
You must log in or register to reply here.
Back
Top