Auto-entering data from another sheet

L

Lupo

Hello all,

Hopefully someone can help me.

I am wanting to automatically enter data from one sheet into the next
by a text prompt. For example:

On sheet 2 I will have 3 static columns that will have data entered in
the format: text / text / number respectively.

On sheet one I want to be able to enter the text from the first column
on sheet two and have excel automatically fill in 2 other cells with
the data from cell B and C from sheet 2.

For example:

Sheet 2 contains hello / how / 123 in row 1 and column A,B,C.

I enter: hello (on sheet 1 cell A) and in cell B and C I automatically
get how / 123 automatically

Can this be done?!?!

Please help
 
A

A.W.J. Ales

Lupo,

On sheet1 un cell B1 put the formula :
VLOOKUP(A1,Sheet2!$A$1:$C$100,2,0)

and in cell C1 (on sheet1) put :
VLOOKUP(A1,Sheet2!$A$1:$C$100,3,0)

This is set up on the assumption that you enter your hello in cell A1 on
sheet1 and that the static columns in sheet2 range fron A1 to C100

Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 

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

Cell data entering slow! 0
Excel does not accept text format! 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
Need Help with a VBA subroutine 0
Auto Fill Word Documents 4
Copy Data from One sheet to Different Sheets 1
VBA Macro - Copying specific data to different sheets in a workbookand linking the InputBox to a com 7
MS Project Center-Autolink column fields 0

Top