Delete Rows that have partial info
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.
|