I have posted reply with sample w/book.

HTH

"mwilso0823" wrote:


--------------------------------------------------------------------------------

Hi,

I am very knew to using macros and VB in excel. Basically I am
attempting to perform a defect analysis for user profile access, to a
system, between two worksheets in excel.

I need to identify in one worksheet, all the profiles a specific user
has access too. Then I need to take this information and compare it to
another worksheet and determine, which profiles cannot coexist on a
users account. Basically, the second worksheet is a grid of all the
profiles along the leftmost column and then listed again along the top
row and using this grid system, profiles which cannot coexist on a
users account are marked by a red cell.

I'll attach an example of what I am comparing.

Please help!!

MJ


+-------------------------------------------------------------------+
|Filename: Example.ZIP |
|Download: http://www.excelforum.com/attachment.php?postid=4693 |
+-------------------------------------------------------------------+

--
mwilso0823
------------------------------------------------------------------------
mwilso0823's Profile: http://www.excelforum.com/member.php...o&userid=33828
View this thread: http://www.excelforum.com/showthread...hreadid=536026