#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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
Quote:
|
#3
|
|||
|
|||
Thanks I think I got it figured out. for now LOL.
|
#4
|
|||
|
|||
Quote:
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Delete blank rows between the two rows that contain data | beginner | Excel Programming | 5 | 12-26-2014 12:29 AM |
Delete All empty Rows - Print - Undo all Rows deleted | Bathroth | Word VBA | 1 | 10-01-2014 01:40 PM |
Is it possible to take a row on sheet 1 and transfer the info to sheet 2 by rows on conditions. | rogcar75 | Excel | 3 | 08-28-2014 05:21 PM |
Delete all rows but the last. | elky1967 | Word VBA | 14 | 09-21-2012 05:27 AM |
Add/Delete data in a Document based on User info | vishal17 | Word | 5 | 04-14-2011 05:02 PM |