Populate form using data from reference sheet using drop list filters

  • Hi all,
    I am attempting to create an automated OSHA log for my company which populates information based upon a drop list. The information is all being added from a data dump from another software program so the information is provided as needed but I need to be able to sort and populate the format by facility and full company. I've attached a copy of what I'm trying to achieve. I can very easily get the full company one but sorting by facility isn't working well as the closest I can get in formatting provides me only the first record for that facility rather than all the needed records. In the attachment is an example of how the data is pulled currently without any filtering, what Im trying to accomplish is that the records in the table reflect the selection in drop list on the first tab. Any assistance would be greatly appreciated!forum.ozgrid.com/index.php?attachment/60136/

  • Re: Populate form using data from reference sheet using drop list filters


    I attempted to do this with vlookup but it returns the same record over and over, is there a way to pull all records with that specification and not have duplicates?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!