Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Analysis between 2 worksheets
-------------------------------------------------------------------------------- Hi, I am very knew to using macros and VB in excel. Basically I a attempting to perform a defect analysis for user profile access, to system, between two worksheets in excel. I need to identify in one worksheet, all the profiles a specific use has access too. Then I need to take this information and compare it t another worksheet and determine, which profiles cannot coexist on users account. Basically, the second worksheet is a grid of all th profiles along the leftmost column and then listed again along the to row and using this grid system, profiles which cannot coexist on users account are marked by a red cell. I'll attach an example of what I am comparing. Please help!! M +------------------------------------------------------------------- |Filename: Example.ZIP |Download: http://www.excelforum.com/attachment.php?postid=4693 +------------------------------------------------------------------- -- mwilso082 ----------------------------------------------------------------------- mwilso0823's Profile: http://www.excelforum.com/member.php...fo&userid=3382 View this thread: http://www.excelforum.com/showthread.php?threadid=53602 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Analysis between 2 worksheets
Hi, Attached contains macro do check on profiles. Hope this helps i.e did I understand requirement.:) +-------------------------------------------------------------------+ |Filename: Copy of Example.zip | |Download: http://www.excelforum.com/attachment.php?postid=4694 | +-------------------------------------------------------------------+ -- Toppers ------------------------------------------------------------------------ Toppers's Profile: http://www.excelforum.com/member.php...o&userid=30076 View this thread: http://www.excelforum.com/showthread...hreadid=536026 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Analysis between 2 worksheets
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Analysis between 2 worksheets
This is very helpful! Thank you!!! MJ -- mwilso0823 ------------------------------------------------------------------------ mwilso0823's Profile: http://www.excelforum.com/member.php...o&userid=33828 View this thread: http://www.excelforum.com/showthread...hreadid=536026 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Analysis ToolPak Regression Analysis Help Requested | Excel Worksheet Functions | |||
Analysis Toolpak-Confidence Level and data analysis questions | Excel Worksheet Functions | |||
editing and analysis of cells in multiple worksheets AND workbooks | Excel Discussion (Misc queries) | |||
Why " data analysis plus " override " data analysis " once instal. | Excel Worksheet Functions | |||
Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) |