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.
SEW-3-Point-Control-Log.xlsx
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I went with the Pivot Table. Thanks to both of you.
You're welcome Steve! Glad we could help.
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