View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] amorrison2006@googlemail.com[_2_] is offline
external usenet poster
 
Posts: 53
Default 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