Thread: How do I make a report listing Names and corresponding programs?
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NeedExcelHelp07 NeedExcelHelp07 is offline
external usenet poster
  
Posts: 30
Default How do I make a report listing Names and corresponding program
What I'm getting:

PRIMARY SECONDARY ID NAME Software A Software B Software C
Software d....
BZ0T23 Jeanne Doe X
BZ0T23 Doe JEANNE X
X
BZ0T23 Doe JEANNE
X

Ok the above is what I'm getting after running the Macro.

So I'm asking how to merge them to make it look like below:
PRIMARY SECONDARY ID NAME Software A Software B Software C
Software d....
BZ0T23 Jeanne Doe X X
X X

Other than this, the Macro works well.

Thanks alot for the help.
Reply With QuoteReply With Quote