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.!

This is usually done with a VLOOKUP() formula. See:

http://www.contextures.com/xlFunctions02.html
--
Gary''s Student - gsnu200782


"Pepe" wrote:

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.!