J
Jim
Following is a sheet where I enter data:
1 2 3 4 5 6
7
Date Acct # Scheduled Actual 101 111 325
11/4/2008 6744-08 11/4/2008 11/4/2008
11/5/2008 6744-09 11/4/2008 11/4/2008 1 2 2
11/5/2008 6744-10 11/4/2008 11/4/2008 1 2 1
11/6/2008 6744-11 11/4/2008 11/4/2008 2 2 1
11/7/2008 6744-12 11/4/2008 11/4/2008 1 8 1
I will have a second sheet where I will change the date and would like to
match and pull over data based on the date:
For example if I put in 11/5/2008 I would like to match the entries. but
the bigger question is what formula is needed to read from row to row?
Date
11/5/2008
Account number 101 325 30001
Thanks for the help
1 2 3 4 5 6
7
Date Acct # Scheduled Actual 101 111 325
11/4/2008 6744-08 11/4/2008 11/4/2008
11/5/2008 6744-09 11/4/2008 11/4/2008 1 2 2
11/5/2008 6744-10 11/4/2008 11/4/2008 1 2 1
11/6/2008 6744-11 11/4/2008 11/4/2008 2 2 1
11/7/2008 6744-12 11/4/2008 11/4/2008 1 8 1
I will have a second sheet where I will change the date and would like to
match and pull over data based on the date:
For example if I put in 11/5/2008 I would like to match the entries. but
the bigger question is what formula is needed to read from row to row?
Date
11/5/2008
Account number 101 325 30001
Thanks for the help