automate data entry on Excel?

P

Pepe

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to rank multiple columns by different contribution levels to rankin Excel? 4
Restrict choices in one drop down list by response to another 4
modify linked cells without breaking link 1
Delete Every Second Duplicate Code 0
import data from txt file to an existing excel file 1
Access to Excel Question 2
Page numbering in a template 5
Satisfying two variables entered via popup 1

Top