Thread: [Solved] How to hide rows that have no data but has formula in cells?
View Single Post
 
Old 02-12-2018, 06:21 AM
LearnerExcel LearnerExcel is offline Windows 7 32bit Office 2003
Advanced Beginner
  
Join Date: Nov 2016
Posts: 82
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default How to hide rows that have no data but has formula in cells?
How to hide rows that have no data but has formula in cells? I am retrieving data from C:\TEST\TempData.xls to C:\TEST\AutoFill.xlsm. I want to hide the rows which have no data but has only formula in the Cells. Empty data rows are vary time to time. Sometimes I require around 200 hundred records and sometimes it exceeds 400 records. That's why there are lot of blank rows. See the attached files for reference.
Attached Files
File Type: xlsm AutoFill.xlsm (49.1 KB, 16 views)
File Type: xls TempData.xls (43.5 KB, 12 views)
Reply With Quote