pulling from one sheet to another
in [General]
|
Prev: How can I increase the amount of visible text in a cell?
Next: display list selection in a different cell
From: Norm on 27 Apr 2010 11:35 I am having trouble pulling data from one sheet to another: SHEET 1 A B C D E 4/21/2010 34287 74 3 4 4/21/2010 39210 90 1 4 4/21/2010 13969 56 3 3 4/21/2010 33369 45 2 2 SHEET 2 A B C D E 04/16/10 13969 04/16/10 39210 04/16/10 34287 04/16/10 33035 I want to pull the data from SHEET 1 column C,D,E .....if A and B match on both sheets The data in a columns on sheet 1 is entered manually and changes each day
From: Pete_UK on 27 Apr 2010 12:01 You could contatenate column A and B values together in a helper column on both sheets, and use this to determine an exact match. For example: =A1 &"_"& B1 will give you something looking like this in your helper cell: 40289_34287 where the first number is the serial value of the date in A1. Hope this helps. Pete On Apr 27, 4:35 pm, Norm <N...(a)discussions.microsoft.com> wrote: > I am having trouble pulling data from one sheet to another: > > SHEET 1 > A B C D E > 4/21/2010 34287 74 3 4 > 4/21/2010 39210 90 1 4 > 4/21/2010 13969 56 3 3 > 4/21/2010 33369 45 2 2 > > SHEET 2 > A B C D E > 04/16/10 13969 > 04/16/10 39210 > 04/16/10 34287 > 04/16/10 33035 > > I want to pull the data from SHEET 1 column C,D,E .....if A and B match on > both sheets > The data in a columns on sheet 1 is entered manually and changes each day
From: Norm on 27 Apr 2010 13:27 I'm not sure I am explaining this right I want the data from C21 on sheet 1 in a cell on sheet 2 if the A & B column data matches SHEET 1 row 21 A B C D E 4/21/2010 34287 74 3 4 SHEET 2 row 20 A B C D E 4/21/2010 34287 74 "Pete_UK" wrote: > You could contatenate column A and B values together in a helper > column on both sheets, and use this to determine an exact match. For > example: > > =A1 &"_"& B1 > > will give you something looking like this in your helper cell: > > 40289_34287 > > where the first number is the serial value of the date in A1. > > Hope this helps. > > Pete > > On Apr 27, 4:35 pm, Norm <N...(a)discussions.microsoft.com> wrote: > > I am having trouble pulling data from one sheet to another: > > > > SHEET 1 > > A B C D E > > 4/21/2010 34287 74 3 4 > > 4/21/2010 39210 90 1 4 > > 4/21/2010 13969 56 3 3 > > 4/21/2010 33369 45 2 2 > > > > SHEET 2 > > A B C D E > > 04/16/10 13969 > > 04/16/10 39210 > > 04/16/10 34287 > > 04/16/10 33035 > > > > I want to pull the data from SHEET 1 column C,D,E .....if A and B match on > > both sheets > > The data in a columns on sheet 1 is entered manually and changes each day > > . >
From: Terry Cano on 27 Apr 2010 18:58
Sounds like the same sort of thing I can't figure out... in QP I did a range for data query and criteria that data range and extracted it to another sheet...can't figure it out in Excel...let me know when you figure it out Thanks "Norm" wrote: > I'm not sure I am explaining this right > I want the data from C21 on sheet 1 in a cell on sheet 2 if the A & B column > data matches > SHEET 1 row 21 > A B C D E > 4/21/2010 34287 74 3 4 > > SHEET 2 row 20 > A B C D E > 4/21/2010 34287 74 > > "Pete_UK" wrote: > > > You could contatenate column A and B values together in a helper > > column on both sheets, and use this to determine an exact match. For > > example: > > > > =A1 &"_"& B1 > > > > will give you something looking like this in your helper cell: > > > > 40289_34287 > > > > where the first number is the serial value of the date in A1. > > > > Hope this helps. > > > > Pete > > > > On Apr 27, 4:35 pm, Norm <N...(a)discussions.microsoft.com> wrote: > > > I am having trouble pulling data from one sheet to another: > > > > > > SHEET 1 > > > A B C D E > > > 4/21/2010 34287 74 3 4 > > > 4/21/2010 39210 90 1 4 > > > 4/21/2010 13969 56 3 3 > > > 4/21/2010 33369 45 2 2 > > > > > > SHEET 2 > > > A B C D E > > > 04/16/10 13969 > > > 04/16/10 39210 > > > 04/16/10 34287 > > > 04/16/10 33035 > > > > > > I want to pull the data from SHEET 1 column C,D,E .....if A and B match on > > > both sheets > > > The data in a columns on sheet 1 is entered manually and changes each day > > > > . > > |