Sales and PO Template Help

[logansauter6]

I have these templates I have been working on. One is a sales template where I have all the selections a client can choose from. The other is a PO template that pulls data from the sales template and populates the PO template. I am trying to get it to where the PO template hides all the unused rows that are not populated. For example if a client does not want a cabinet selection instead of pulling nothing from the sales template I would like the PO template to just hide these selections.

 

[Smitty]

Welcome to the Board!

Have you tried AutoFilter?

 

[logansauter6]

I have not tried that yet. This is a work in progress and I am not the most resourceful when it comes to excel.

 

[Smitty]

With the cursor anywhere in your data range just goto Data-->Filter. You'll then see drop-downs to the right of each column in your header row. Just select the column you want to filter on (maybe Quantity) and uncheck Blanks and Zeros. Note that if your data isn't contiguous you'll need to put some fillers in (0's), and you can set the font color to match the background color.