I have a simple spreadsheet used for liquor inventory and the user can add liquors as they come available. I have added extra lines to use as more space is needed but I would like to create a worksheet for printing off their "count sheets" that omits all the blank cells.
I will keep the headings on the new worksheet so it comes up as
Any help would be appreciated, I am a beginner/intermediate user and know a little of macros, but would like to do this through a formula if possible.
Thank you for your help!