Thread: [Solved] data migration
View Single Post
 
Old 06-29-2016, 07:36 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default
You already have a formula type suggestion.

A macro approach could go something along the lines of this.
Drawback is the time taken to do the looping.
Filtering might speed things up.

... just an idea.
Attached Files
File Type: xlsm WindSeaker-Vlook-1.xlsm (168.3 KB, 8 views)
Reply With Quote