hello Everyone,
I need to conditionally copy from one excel worksheet to another. The condition is date and item number so I have two sheets, sheet1 and sheet2. In sheet1, I have dates listed like
Sheet1
7654
08/01/2010 12
08/02/2010
08/03/2010
sheet2 has
dates
7654
1
2
3
if 08/01/2010 matched with 1 and 7654 in sheet1 matches with 7654 in sheet2, I want the number 12 to be displayed right next to 1 in sheet2
I have the whole months date in my sheet1 and numbers are 7654, 7655, 7688, 14 numbers are displayed like this.
Can anyone help me with this.
Thanks
I need to conditionally copy from one excel worksheet to another. The condition is date and item number so I have two sheets, sheet1 and sheet2. In sheet1, I have dates listed like
Sheet1
7654
08/01/2010 12
08/02/2010
08/03/2010
sheet2 has
dates
7654
1
2
3
if 08/01/2010 matched with 1 and 7654 in sheet1 matches with 7654 in sheet2, I want the number 12 to be displayed right next to 1 in sheet2
I have the whole months date in my sheet1 and numbers are 7654, 7655, 7688, 14 numbers are displayed like this.
Can anyone help me with this.
Thanks