dear freinds i am a hvac estimator and using one boq templets to make boq,when i put required data to boq templets its gives complete boq in excel but some rows without quantity,these rows i want to hide in one shot,manually we can hide but it takes time,any can help me how i can hide these empty rows in one shot.write me at ehank2009@gmail.com thanks
Select your range and apply an autofilter. Open up any of the dropdowns and go to the end... there will be "blanks" checked off. Uncheck it and they will be hidden.
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks