Macro to look for three rows of everything
Hi there,
I need a macro to look down say columns A B and C and find three rows
which match in amount, date, and order number.
I would prefferably like to have it look for a specific entry in that
column D must be say X and Columns A B and C match.
And another row that says Y andcolumns A B and C match.
And another one that says Z and columns A B and C match.
The thing is my system needs to have three rows which are the same to
be input in different systems.
I need to check to see if any data from Z above is missing from X and
Y.and then reinput them manually to make sure all three of the
accounts are matching,
I hope this makes sense to someone,
Thanks
Andrea
|