I would like the output to include the Id and name and then if there's a
secondary ID, to list all 3. Thanks for the help.

"JLatham" wrote:

First job is to decide which piece of information on the individual software
sheets it is that you're going to use to identify a person; ID? secondary ID?
Name? or some combination of the three? The preference would be to have
whatever item or combination available on all software sheets in use.

If it is a single item, then it's easy to get the mark in the particular
columns with a MATCH() or even VLOOKUP() formula. If it is a combination of
entries on the software sheets, then a SUMPRODUCT() formula will probably be
the one to use.

A little more information about how you're going to determine who is who
over on the summary sheet will help make a final decision as to what type of
worksheet function will best meet your needs.

"NeedExcelHelp07" wrote:

I have a workbook with several worksheets. Each worksheet is divided by the
software they have access to. There's overlapping names in each worksheet as
some names have access to more than one software. How can I make this into a
report listing the names on the left column, the names of the software listed
across the top row, and a mark below each column if that person has access to
that software.
There's a login ID down Column A, and in some instances there's a secondary
ID down Column B, then the names in Column C. Each sheet represents a
different software as mentioned previously.

Thanks!!!