Delete Rows that have partial info

[dlafko1]

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.

[Purfleet]

i Would be happy to try and help but not 100% on what you are after. How would we identify what names are to be deleted? what do you mean by

I would also like to automate the names across the sheets

[dlafko1]

Thanks I think I got it figured out. for now LOL.

[dlafko1]

Originally Posted by Purfleet

i Would be happy to try and help but not 100% on what you are after. How would we identify what names are to be deleted? what do you mean by

I think the biggest thing is how to create a report that wont need alot of editing. I made a pivot table but it does not automatically update and you have to mess with the page breaks to get everything to print right.. So I you can help with that.. Would be happy to share emails