Linking 2 sheets together for info

**AlanR** · 04-30-2010, 05:16 PM

Hi All,

I'm new to Excel and now using the 2007 version, I think I have the basics sorted. Would like some advise on how to go about the following situation. The customers I have I would like to enter them on a worksheet when I enter there name into a cell, by that i mean I would like to enter there full address when I just enter there name. I was thinking of enetering there full name and address on sheet 2 of the work sheets then when I enter there name in sheet 1 it will automaticly enter there address. Is this possible to do if it is how would I go about setting it up. On sheet 2 would I need to enter just one part of the address in each of the cells in a row. What sort of formula would I need in the cell on sheet one to call the address up. Hope this is not too much in one go or whether I should break it down and just ask you to answer it in sections.

Alan

**DonkeyOte** · 04-30-2010, 05:23 PM

If sheet 2 has the client names in Column A and the address in Column B then from Sheet1 you can use a VLOOKUP to retrieve the address from Sheet2.

If you want to store the various parts of the address in different cells (street, county, post code etc) then the technique used for retrieval on Sheet1 will largely depend on how you intend to list those same parts on Sheet1 (ie concatenated in a single cell or split in the same manner as Sheet2)

If in doubt - post a sample file and outline some desired results etc...
(dummy names and addresses of course)

**AlanR** · 04-30-2010, 05:35 PM

Thanks ote, as for having address as sheet 2 or all in one cell is somethig I'm trying out.

How do I show a part of my worksheet as an example on a question have tried to just copy and paste but the data ends up all over the place.

Alan

**DonkeyOte** · 04-30-2010, 05:38 PM

In the reply window click on the paperclip icon to attach a file - if you can't see it click advanced.

I can't guarantee I'll be able to help you specifically (it's late as you know), however, if you post a file illustrating requirements someone will.

**AlanR** · 04-30-2010, 05:40 PM

Thanks ote.

**Baron Georg** · 05-03-2010, 04:43 AM

This is not my day..... I have 2 simple questions.
I have forgotten how to take the data in a cell and have it read also on another worksheet in the same book.....HELP!

The other problem: How may I SIMPLY have a "Last modified" cell on each worksheet without ALL the worksheets register the same data?

[email protected]

**teylyn** · 05-03-2010, 05:11 AM

BaronGeorg,

unless you're dying for more spam in your inbox, don't publish your email addy in a forum.

Other than that:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

**royUK** · 05-03-2010, 05:31 AM

Baron Georg,

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

**AlanR** · 05-03-2010, 12:00 PM

Hopefully will show my example worksheets, On sheet 2 are my addresses and what I'm looking to do is when I enter the town in the location cell I want the address to appear on sheet 1. OTE was helping me out. Not sure if my excel sheets are going to show up but here goes. Forgot to mention would like the address to appear in a single cell.

Alan