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!Automated Osha Log.xlsx