View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pepe Pepe is offline
external usenet poster
 
Posts: 3
Default automate data entry on Excel?

Simply cannot find it! All I wanted to find out is what would be the best way
to automate data entry i.e. there are three columns, 1st one with the venue
name, 2nd one with the address and the 3rd one with the postcode or zipcode.
So I have created the drop down list for the 1st column but wanted to find a
way to automate data entries on the 2nd and 3rd columns. So that when a
selection is made from the drop down menu then automatically the 2nd and 3rd
column are completed! Would be grateful if you could point me in the right
direction. Many, many thanks.!