Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-16-2020, 07:00 AM
dlafko1 dlafko1 is offline Delete Rows that have partial info Windows 10 Delete Rows that have partial info Office 2016
Advanced Beginner
Delete Rows that have partial info
 
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
  #2  
Old 10-16-2020, 09:43 PM
Purfleet Purfleet is offline Delete Rows that have partial info Windows 10 Delete Rows that have partial info Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

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:
I would also like to automate the names across the sheets
Reply With Quote
  #3  
Old 10-17-2020, 06:26 AM
dlafko1 dlafko1 is offline Delete Rows that have partial info Windows 10 Delete Rows that have partial info Office 2016
Advanced Beginner
Delete Rows that have partial info
 
Join Date: Apr 2019
Posts: 31
dlafko1 is on a distinguished road
Default

Thanks I think I got it figured out. for now LOL.
Reply With Quote
  #4  
Old 10-17-2020, 07:21 AM
dlafko1 dlafko1 is offline Delete Rows that have partial info Windows 10 Delete Rows that have partial info Office 2016
Advanced Beginner
Delete Rows that have partial info
 
Join Date: Apr 2019
Posts: 31
dlafko1 is on a distinguished road
Default

Quote:
Originally Posted by Purfleet View Post
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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete Rows that have partial info Delete blank rows between the two rows that contain data beginner Excel Programming 5 12-26-2014 12:29 AM
Delete Rows that have partial info Delete All empty Rows - Print - Undo all Rows deleted Bathroth Word VBA 1 10-01-2014 01:40 PM
Delete Rows that have partial info 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 Rows that have partial info Delete all rows but the last. elky1967 Word VBA 14 09-21-2012 05:27 AM
Delete Rows that have partial info Add/Delete data in a Document based on User info vishal17 Word 5 04-14-2011 05:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:14 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft