View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sjbeeny[_5_] sjbeeny[_5_] is offline
external usenet poster
 
Posts: 1
Default Enter data depending on Col A

Hi all,

Iwas just wondering if someone could help me with vb code that insert
a 'vlookup' formulae in Col B14 onwards only if there is a numeri
value in Col A14 and onwards

ie. I want to press an active X button and have Col A14 to Ax fille
with data from sheet 2 and then look up the corresponding values fro
sheet 1 using vlookup.


Cheers,
Simon:confused

--
Message posted from http://www.ExcelForum.com