How to hide rows that have no data but has formula in cells?

		Microsoft Office Forums > Microsoft Excel > Excel Programming
How to hide rows that have no data but has formula in cells?

FAQ

Thread Tools

Display Modes

02-12-2018, 06:21 AM

LearnerExcel LearnerExcel is offline

Windows 7 32bit How to hide rows that have no data but has formula in cells?

Office 2003

Advanced Beginner

Join Date: Nov 2016

Posts: 82

LearnerExcel will become famous soon enough

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

	AutoFill.xlsm (49.1 KB, 16 views)
	TempData.xls (43.5 KB, 12 views)

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:20 AM.