Macros???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

allinsca - 14 Dec 2005 18:21 GMT

Hi,

I have a worksheet with rows of information and varying coloumn headings. I
am trying to find a way to be able to grab information from a single row and
pull it onto a separate worksheet. (I want to be able to type in a
respective # on the separate worksheet and the corresponding info show up.)

I am not sure what this is called but I know it is common. Any help would
be fantastic!

Signature

Thanks!

Reply to this Message

Bernie Deitrick - 14 Dec 2005 19:26 GMT

allinsca,

Take a look at the VLOOKUP function.

HTH,
Bernie
MS Excel MVP

> Hi,
>
[quoted text clipped - 5 lines]
> I am not sure what this is called but I know it is common. Any help would
> be fantastic!

Reply to this Message

CLR - 14 Dec 2005 19:29 GMT

What you are looking for is the VLOOKUP function. To accomplish what you
want would require a separate VLOOKUP formula in each cell where you wish
data to appear...........this is done all the time.........check the HELP on
VLOOKUP and if you still have problems, post back with specifics........

Vaya con Dios,
Chuck, CABGx3

> Hi,
>
[quoted text clipped - 5 lines]
> I am not sure what this is called but I know it is common. Any help would
> be fantastic!

Reply to this Message

Gord Dibben - 14 Dec 2005 20:11 GMT

Not a macro, but some VLOOKUP formulas.

Assuming on sheet1 you have data in A1:F10 with number ID in column A

On sheet2 select B1:F1

In B1 enter =VLOOKUP(A1,sheet1!$A$1:$F$10,{2,3,4,5},FALSE)

Now hit CTRL + SHIFT + ENTER to enter as an Array formula.

Type an ID number in A1 on sheet2 and B1:F1 will fill in.

You could amke a Data Validation dropdown in sheet2 A1 based on the list of ID
numbers in sheet1 A1:A10 so users could simply click on A1 and pick a number.

Gord Dibben Excel MVP

>Hi,
>
[quoted text clipped - 5 lines]
>I am not sure what this is called but I know it is common. Any help would
>be fantastic!

Reply to this Message