I created an Excel workbook that functions as a log for certain events that occur at my place of work. It also uses the information from the log to make another tab ("Open vs. Closed Events") that shows the part # that the event occurred for and whether or not the event is currently open or closed. What I need is another tab called "Scheduling Report" that will look at the "Open vs. Closed Events" tab and pull only the part # from the OPEN events. I started a "scheduling report" tab and I can pull the information from the other tab into the scheduling report and make the open part #s show up, but there would be spaces between all of the open part #s where closed part #s are. I would like the scheduling report to list all of the part #s that have an open event from the "Open vs. Closed Events" tab in Column A6:A105 without leaving blank spaces between when there are closed events.
I attached the file that I have been working on and entered some data to try to help you understand what I need.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
-Mike Kapnisakis, Warner Bros
With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros. You'll also be able to connect with highly specified Experts to get personalized solutions to your troubleshooting & research questions. It’s like crowd-sourced consulting.
We can't always guarantee that the perfect solution to your specific problem will be waiting for you. If you ask your own question - our Certified Experts will team up with you to help you get the answers you need.
Our certified Experts are CTOs, CISOs, and Technical Architects who answer questions, write articles, and produce videos on Experts Exchange. 99% of them have full time tech jobs - they volunteer their time to help other people in the technology industry learn and succeed.
We can't guarantee quick solutions - Experts Exchange isn't a help desk. We're a community of IT professionals committed to sharing knowledge. Our experts volunteer their time to help other people in the technology industry learn and succeed.