I am trying to write a macro to compare data from two different tables and write a value in a different cell.
For Example
Would like to compare A1:A900 (Dates) of Table 1 to C1:AB1 (Dates) of Table 2 if true, then compare B1:B900 (Sites) of Table 1 to A1:A900 (Sites) of Table 2. If both conditions are met then I should be able to write the value found in say "c15"in a new cell.
Pls help.. I know this is confusing, if I can attach a sample sheet I would be able to but I am not sure how to do that.
THanks in advance, any help would be appreciated.
For Example
Would like to compare A1:A900 (Dates) of Table 1 to C1:AB1 (Dates) of Table 2 if true, then compare B1:B900 (Sites) of Table 1 to A1:A900 (Sites) of Table 2. If both conditions are met then I should be able to write the value found in say "c15"in a new cell.
Pls help.. I know this is confusing, if I can attach a sample sheet I would be able to but I am not sure how to do that.
THanks in advance, any help would be appreciated.