Intersect Formula VBA Help
I need help with a VBA Intersect Formula. I have
locations identified going across the top of my
spreadsheet and then locations identified going down the
side of my spreadsheet. At the appropriate row/column
intersect cell the distance between the two locations is
identified.
I am going to have a userform pop-up and the staff can,
using a combo box, select the to and from location. I
need a formula that will look accross for the from
location and down the side for the to location and then
give me the intersect value????
SDC
|