|
|
#1
02-12-2018, 06:21 AM
|
|||
|
|||
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. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Split data in cells and duplicate rows | ballpoint | Excel Programming | 6 | 02-07-2018 05:52 PM |
| eliminating blan rows between cells in a column cantaining data | FUGMAN | Excel Programming | 6 | 03-01-2017 07:35 AM |
| Formula to hide '0' from blank referenced cells | formuladummy | Excel | 3 | 05-08-2014 02:33 AM |
| Hide Rows | YounesB3 | Excel | 2 | 10-29-2012 05:40 AM |
 Sum Formula in the range with Numeric and NonNumeric data cells
|
Spanec | Excel | 2 | 01-12-2012 09:15 AM |
Windows 7 32bit 
Office 2003
Threaded Mode