I have a sheet that is imported from and access query. This sheet will change depending on the data from access.
The fields are:
Date Amount
8/18/2004 ($17,020,966.67)
8/19/2004 ($90,789,680.01)
8/20/2004 ($395,559.34)
8/23/2004 ($13,782,879.05)
8/25/2004 ($27,531,708.33)
8/26/2004 ($3,719,690.34)
In my Primary sheet I will have the same fields
Date| Amount, but the date field will contain 30 dates (including weekends) and the Amount field will initially be blank.
What I want to do is to write a macro that searches through the Date field from the access query and when the dates match, it pastes the corresponding amount in the cell next to it.
Any ideas?? I'm an excel newb and I have no clue how to do this. I'm thinking it has to match the string values and paste accordingly.
Thanks
The fields are:
Date Amount
8/18/2004 ($17,020,966.67)
8/19/2004 ($90,789,680.01)
8/20/2004 ($395,559.34)
8/23/2004 ($13,782,879.05)
8/25/2004 ($27,531,708.33)
8/26/2004 ($3,719,690.34)
In my Primary sheet I will have the same fields
Date| Amount, but the date field will contain 30 dates (including weekends) and the Amount field will initially be blank.
What I want to do is to write a macro that searches through the Date field from the access query and when the dates match, it pastes the corresponding amount in the cell next to it.
Any ideas?? I'm an excel newb and I have no clue how to do this. I'm thinking it has to match the string values and paste accordingly.
Thanks