i have two sheets, one has a list of names and corresponding amounts.
the other sheet contains a second list of names and amounts in the
next two columns. Some of the names are appearing in the first list. i
need to create a macro which will scan through the two sheets, and if
the same name is in the two list then i want those names to appear on
the third sheet and in the next three columns i want the amounts from
the first list and the amounts from the second and third columns of
the second sheet.