Display Data With No Blanks

Steve Eckerman
Steve Eckerman used Ask the Experts™
on
Hello Experts,

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.

Any help is appreciated. Thank you.
SEW-3-Point-Control-Log.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
IT Administrator
Commented:
Use the pivot table.

See the proposal attached.
SEW-3-Point-Control-Log.xlsx
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
The another way is to use VBA to get the desired output.
On "Scheduling Report" Sheet, in cell B4 (yellow cell), select the Event from the drop down and the related Part# will be appeared in column A.
See if that setup works for you.

Since this workbook contains macros, you will need to enable the editing/content after opening the file first time.
SEW-3-Point-Control-Log.xlsm
Steve EckermanSystems Administrator

Author

Commented:
I went with the Pivot Table. Thanks to both of you.
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
You're welcome Steve! Glad we could help.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial