is_utf8:0,
 
Search : in
By :

Auto fill by extracting from other sheet

Last answer on May 13, 2009 7:55:32 am BST JEG, on Dec 9, 2008 6:22:03 am GMT 
 Report this message to moderators

Hello,

I have a work book where i have diff sheets containing information of different persons. now i have a new sheet where i can enter th persons name. This sheet is a like a form which requires specific data only;

Requirement: when i enter the name in the form the other details should be automatically filled with the values got from the corresponding sheets of the name....

Thanks in advance....

Configuration: Windows XP
Internet Explorer 6.0

Best answers for « Auto fill by extracting from other sheet » in :
Extracting the sound from a video ShowExtracting the sound from a video If you ever want to extract the soundtrack from a video the simplest way is to use VLC player Link:http://www.videolan.org/vlc/ Once installed: File menu /Open File (advanced) File tab / Browse...
Grand Theft Auto IV (GTA4) - Bugs ShowGrand Theft Auto IV (GTA4) - Bugs Minimum official requirements Officially Recommended configurations Setting the compatibility with Vista Note GTA4 For many people the game does not start after installation. In most cases,...
Replacing Variables in Bash/shell ShowReplacing Variables in Bash/shell Intro: Expression:Defininition Intro: First of all make sure that you the variable is defined before replacing it, or in other cases determine that it is not empty, and to initialize with a default...
Download Webm8 Portable Edition Show
Download SSH Secure Shell ShowSSH secure shell for workstations is a flexible client SSH allowing to connect in a secured way to remote applications. http://www.commentcamarche.net/faq/images/NHc6wz5jOYBhPXTis.png
Download Vista Live Shell Pack - Pink ShowIf you want to have Vista on your computer but your shape is not rather powerful or if simply you cannot have to be paid this version yet? Then resolution is to change the appearance of your good old XP. Vista Live Shell Pack is a topic of office...
UNIX system - The shell ShowIntroduction to the shell The command interpreter is the interface between the user and the operating system, hence its name "shell". The shell therefore acts as an intermediary between the operating system and the user using command lines...
Linux - The shell ShowIntroduction to the shell The command interpreter is the interface between the user and the operating system, hence the name "shell". The shell therefore acts as an intermediary between the operating system and the user thanks to command lines...
Declaring a style sheet (CSS) ShowDeclaring a style sheet Style sheets are not directly integrated into the W3C's HTML recommendations. For this reason, you need to include elements in the HTML code indicating both the type of document, meaning the version of the HTML and CSS...
Ask your question Reply

1

TheParoxysm, on Dec 9, 2008 5:24:16 pm GMT
  • +1

I assume you mean excel. I'll help you but next time please state excel as you would be surprised how vague some people are.

What you are trying to do is called a 3d reference, meaning referencing data from one cell in a worksheet from another cell/worksheet.

http://www.bettersolutions.com/excel/EED883/QN620422111.htm

There you go!

Make sure to mark this as resolved!

   
Reply to TheParoxysm

2

Dan, on Jan 22, 2009 8:05:16 am GMT
  • +1

3D Formula allow you to reference other worksheets but do nothing for auto fill...

3D formula allow for a summery sheet to be constructed that will auto update when you edit or add data to your other workbooks

As I understand it I am having trouble with the same issue and this does not help at all.

the question is:
I have a worksheet that contains data
ie.
Joe Smith | 23 | 1 | 1986 |
Fred blogs | 20 | 5 | 1972 |

I have another worksheet that looks like a traditional database retrieval screen with blanks to be filled in
ie.
name:

when I enter a name (like joe smith) the other values should reference and auto fill.

logically it would be something like IF A1=Joe Smith THEN B1=Sheet2!B1

but this would require a LOT of formulae and there does not seem to be an IF THEN function?

I hope this is clearer (and what you mean?)

   
Reply to Dan

3

Duf, on Mar 20, 2009 7:08:54 am GMT
  • +1

Hi Dan
I think best thing to do here is to make use of VLOOKUP function, define a table in first sheet with names in first column (sorted!). Look at help function to use VLOOKUP, it is very easy and handy to use, e.g. =VLOOKUP(A5,'TableName',4) will use value in A5 and return value in column 4 of your first sheet.

goodluck

   
Reply to Duf

4

KOONELOS, on May 13, 2009 7:49:12 am BST

Dear friend,

If I understood your question correctly, what you need can be easily done with the "IF" function.

Let's take for example that in one sheet you have two columns, one with names and a second with corresponding numbers, e.g.:

Michael 34
John 74
Nick 57

If I understood correctly, what you want is in another sheet to type, for example, "John" and get the "74" filled in automatically.

Name column A as "name" ang column B as "number".
Go to cell B2 and choose the "IF" function.
Logical_Test: IFB2=(click on the cell on the original sheet containing the name)
Value_if_true: (click on the cell fron your original sheet that contains the number corresponding to the name)
Value_if_false: (you can put in anything here, for example 0)

and press enter.

Now, when you type in the name (be carefull, it should be EXACTLY as it's typed in the original sheet) you should see the number come out automatically

   
Reply to KOONELOS

5

 KOONELOS, on May 13, 2009 7:55:32 am BST
  • +1

(cont)

Now, when typing in a name in the "name" column, you should see the number fill in itself automatically. If you have to, drag down the cell with the if function to make it available for more names in the row.
Just be careful: you should type in names EXACTLY as they are typed in the original sheet. Otherwise you will get zeros.

Hoped this helped

   
Reply to KOONELOS
Ask your question Reply
They need your help