Thread: [Solved] Vlookup fill down blank cells in column
View Single Post
 
Old 09-23-2016, 02:46 PM
mbesspiata mbesspiata is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
  
Join Date: Mar 2011
Location: Virginia
Posts: 57
mbesspiata is on a distinguished road
Default 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
File Type: xlsx CBP Port and Other Agency Listing.xlsx (87.9 KB, 12 views)
File Type: txt Add Region Macro.txt (2.8 KB, 10 views)
File Type: xlsx Seizures Pending Acceptance.xlsx (76.3 KB, 12 views)
Reply With Quote