Results 1 to 2 of 2

Thread: Distilling data using drop boxes

  1. #1

    Question Distilling data using drop boxes



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hey all,


    I need your help. I am trying to develop a spreadsheet that will allow me to enter data once and manipulate it in a number of ways and I have figured out the full spreadsheet bar one section, the calculation for distillation.


    Let me explain. I have three worksheets that I am working from: one for entering all data, a source one for drop down menus and one to be used to provide information based on certain criteria. I want the latter of these to display all the data entered on the data entry sheet until I select certain criteria either collectively or individually.


    Information sheet should display all data and then I want to select either a project name, company or type of company or any combination of the above and for it to dismay only that data.


    Does that make sense? Can anyone help? I am happy to explain further but hopefully this sets out what I am trying to do.


    Thank you in advance,
    Graeme

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    Excel Version
    Excel 2016
    Perhaps a sample workbook showing your requirements would better help explain.


Posting Permissions

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