Hiding Cells...

Hello All,

I am relatively new to Excel beyond very basic formulas and I wanted to see if you guys could help me get what seems like a fairly easy question answered. (I stole the current formulas from what a previous manager used for a different sheet if you're curious as to how I even got to the point I did). What I have now is the far Lane in the "Data" sheet coordinating to the "Cooler Outline" sheet. When I put a number in the "Lane #" column it shows up with the desired information in the "Cooler Outline." My only problem is all the blanks. I'd love to have it so any of the empty rows or even columns that aren't filled get sorted out. I tried to use a table to do this but the way the info is I couldn't figure how to do this... All the info I tried to pull had me deleting blanks or trying to get rid of every blank one but the work space. Any help is appreciated!

Best,
Jake

Thanks for your help dflack! But I'd really like the info to work in the Cooler Outline Sheet, rather than have two other sheets. Is this possible? All I need is to be able to hide the unused cells and columns in Cooler Outline.

Thanks again!
Jake

Still trying to figure out how to do this?