Hi everyone, I am trying to build a robust Excel workbook for popcorn sale tracking for Cub Scouts where at the end the end user just has to enter data and then the workbook calculates everything else.

I am looking to delete rows that have no orders. The problem is those blank orders still have a name in them and other calculations that is not allowing me to remove blanks the easy way. Figure its going to need VBA Coding

I can send the sheet if your able to help
I would also like to then create an easy to read report for the order picking part



Example Column A has First name B has Last Name C thru y are products ( could be blank if no order) Then other columns and rows might have 0 because there was nothing in the order.

There are alot of moving parts.

Take order sheet this is really where I want to delete info.

I would also like to automate the names across the sheets but IDK how to do it because once you start deleting names then that will affect the other sheets

I attached the work book. The Specific sheet i am look for help with is the Take Order sheet.

Attached Files

Test Master Workbook.xlsx (52.0 KB, 12 views)