Dear All, Hi
I have a two worksheets of workbook named LC worksheet and second one Account work sheet. Data from LC worksheet likned into the Account worksheet at Column K and Column V.
I want to highlight cells in LC worksheet which have no dependents or have duplicate dependents at Column K and Column V into the Account worksheet. Built in trace dependents is time consuming and useless.
File attached for your further understanding
Please help me by coding macro or other feasible programming.
The key here is that you ask if there is a dependancy between sheets. Therefore you can look into the .FORMULA and see if there is the string:Account! (with exclamation mark !)
Please Login or Register to view this content.
Last edited by rwgrietveld; 07-13-2009 at 02:53 AM.
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
Actually I said I want those cells marked as green colours which are in the LC worksheet link not going on Account worksheet. Hopefully you understand my point.
For example:
column A column A
12 89
45 66
66 12
89
78
LC Worksheet Account Worksheet
Tell me those macros which colour the amount of 45 at A2 and 78 at A5 of LC worksheet.
Actually I said I want those cells marked as green colours which are in the LC worksheet link not going on Account worksheet. Hopefully you understand my point.
For example:
column A column A
12 89
45 66
66 12
89
78
LC Worksheet Account Worksheet
Tell me those macros which colour the amount of 45 at A2 and 78 at A5 of LC worksheet. [(PLEASE SEE ATTACHED FILE)
Dear All
I have two sheets like sheet1 and sheet2. In sheet1 data is linked to sheet2 in D and F column. In other words data is going to sheet2 in D and F column from sheet1.
I want macro colour cells in sheet1 which is not going to sheet2 in D and F column.
For example:
Sheet1 Sheet2
A A B C D F
12 12
89 89
56
78 78
99 99
33
sheet1 sheet2
Macro colour cell A3 and A6 because figure 56 and 33 not going to sheet2
Please explain how this is helping us help you.For example:
Sheet1 Sheet2
A A B C D F
12 12
89 89
56
78 78
99 99
33
sheet1 sheet2
If you could put together a sample workbook that'd be great and we'll help you out.
mew!
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Where can I find all these numbers. Is it possible to send me a "short" version of your sheet. A2 for example gives me this: =C2-K2
and your WB is asking for external data.
Ali-imran 2 points:
1 - do not create multiple threads on the same subject - I have merged your two separate threads
2 - do not cross post in other forums without providing links
Please ensure you take the time to read the Forum Rules before posting further.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
I have two sheets like sheet1 and sheet2. In sheet1 data is linked to sheet2 in C and D column. In other words data is going to sheet2 in C and D column from sheet1.
I want macro colour cells in sheet1 which is not going to sheet2 in C and D column.
For example:
Sheet1
A
12
89
56
78
99
33
Sheet2
A B C D
0 0 0 12
0 0 89 0
0 0 0 78
0 0 33 0
Macro colour cell A3 and A6 because figure 56 and 99 not going to sheet2 in C and D column
No body like to help me
It would seem not.Originally Posted by Ali-imran
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks