View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jan Jan is offline
external usenet poster
 
Posts: 159
Default VSB more efficient then standard functions?

hi,

i have linked 1 worksheet to 2 other worksheets (all 3 in the same file)
using VLOOKUP

this in total pulls over 3 different cells into 3 different columns for all
65536 rows.
a update will take 30 minutes. i assume thsi could be more efficient,
however i don't know how to do that. any suggestions?

thanks.