I have a spreadsheet for tracking inspection activities. I have several column fields including 'Part Number' and 'Date Complete' field. I want to be able to quickly print a report on all the line items on the spreadsheet whose 'Date Complete' field is still blank. Can anyone help?
Select the data, then go to Data > Filter > Auto-filter, then sort blanks on Date Completed field
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Yeah, I can do that, but I want to automate a report based on this and print only select fields.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks