VLOOKUP

  • Thread starter Thread starter tc
  • Start date Start date
T

tc

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.
 
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.
Click to expand...

Sheets? Macro?
Sounds like you are using Excel.

You have posted this message to the wrong newsgroup.
The access in this group's name refers to Microsoft Access, a database
program.
Please repost to the correct newsgroup for whatever Office program you
are using. I would suggest you include your Windows and Office version
number in the message.
 
Back
Top