A
arepemko via OfficeKB.com
HERES THE SITUATION I HAVE SHEET1!B6 THAT HAS A DATE. I WANT TO RUN A MARCO
THAT GETS THAT DATE AND LOOKS THREW SHEET4!A:A AND MATCH THAT DATE THEN PASTE
SPECIAL VALUES, IN THE FIRST THREE CELLS TO THE RIGHT.
EXAMPLE:
SHEET 1
A B C D E
1
2
3
4
5
6 9/6/2006
FOR 9/6/2006 I HAVE THREE TOTALS 25 (WHICH WOULD GO IN COLUMN B), 45(COLUMN C)
, 15 (COLUMN D).
SHEET 2
A B C D
4 1/1/2006
5 1/2/2006
251 9/5/2006
252 9/6/2006 25 45 15
253 9/7/2006
DO YOU HAVE ANY IDEAS?
THANK YOU SO MUCH FOR YOUR HELP
THAT GETS THAT DATE AND LOOKS THREW SHEET4!A:A AND MATCH THAT DATE THEN PASTE
SPECIAL VALUES, IN THE FIRST THREE CELLS TO THE RIGHT.
EXAMPLE:
SHEET 1
A B C D E
1
2
3
4
5
6 9/6/2006
FOR 9/6/2006 I HAVE THREE TOTALS 25 (WHICH WOULD GO IN COLUMN B), 45(COLUMN C)
, 15 (COLUMN D).
SHEET 2
A B C D
4 1/1/2006
5 1/2/2006
251 9/5/2006
252 9/6/2006 25 45 15
253 9/7/2006
DO YOU HAVE ANY IDEAS?
THANK YOU SO MUCH FOR YOUR HELP