Avatar of Steve Eckerman
Steve Eckerman

asked on 

Display Data With No Blanks

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.
Microsoft OfficeMicrosoft ExcelVBA

Avatar of undefined
Last Comment
Subodh Tiwari (Neeraj)
Avatar of Michal Ziemba
Michal Ziemba
Flag of Poland image

Blurred text
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
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.
Avatar of Steve Eckerman
Steve Eckerman


I went with the Pivot Table. Thanks to both of you.
You're welcome Steve! Glad we could help.
Microsoft Excel
Microsoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews


IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo