I am trying to create a big spreadsheet for a salesperson and need to drag through some data from another page on the spreadsheet....
So on the first page I have a drop down list using data validation. This works well enough. Basically I enter a postcode and a list of clients from that postcode appear in a drop down menu. Thats perfect. What i want to know is if it is possible to also pull through the corresponding telephone number automatically.
So on the data entry sheet I have mas an example....
Postcode WA Client Address Client Phone Number Company A, 123 Rajah Street WA2 6BG Company B, 124 Rajah Street WA2 6BG Company C, 125 Rajah Street WA2 6BG
And on the raw data sheet I have...
Company A, 123 Rajah Street WA2 6BG 0151 288 3352 Company B, 124 Rajah Street WA2 6BG 0151 288 3353 Company C, 125 Rajah Street WA2 6BG 0151 288 3354
So is there any way for the Client Phone Number column to automatically fill the telephone number adjacent to the data being pulled through on the raw data sheet? I know how to bring it through from a drop down but I want it to automatically fill the phone number part once the drop down is selected on the client address list.
Does that make any sense? Any help would be greatly appreciated!
Reply With Quote
Originally Posted by Reech
