Vlookup fill down blank cells in column

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Vlookup fill down blank cells in column

FAQ

Thread Tools

Display Modes

09-23-2016, 02:46 PM

mbesspiata mbesspiata is offline

Windows 7 64bit Vlookup fill down blank cells in column

Office 2010 64bit

Advanced Beginner

Join Date: Mar 2011

Location: Virginia

Posts: 57

Vlookup fill down blank cells in column

See attached files. One is the macro text currently in use where I have to manually drag the E2 formula down through all blank cells.
The other two are the main report and the one used for the lookup number.
Hope this helps.
I've cleaned up unnecessary data from the reports.

Mike

Attached Files

	Seizures Pending Acceptance.xlsx (76.3 KB, 12 views)
	CBP Port and Other Agency Listing.xlsx (87.9 KB, 12 views)
	Add Region Macro.txt (2.8 KB, 10 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto Fill only Blank Cells in a Column	mbesspiata3	Excel Programming	1	09-22-2016 07:18 PM
Return Sum value of one column from cells not blank in another column	zulugandalf	Excel	3	08-14-2014 03:37 AM
How-TO format cells (FILL) by comparing cells	zanat0s	Excel	1	07-03-2012 04:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:02 PM.