View Single Post
 
Old 10-16-2020, 07:00 AM
dlafko1 dlafko1 is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Apr 2019
Posts: 31
dlafko1 is on a distinguished road
Default 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.
Attached Files
File Type: xlsx Test Master Workbook.xlsx (52.0 KB, 10 views)
Reply With Quote