pawanhsharma
Board Regular
- Joined
- Feb 12, 2013
- Messages
- 64
Hello everyone,
I have to validate some data tables on regular basis. which I do with the help of index+match+match function and it work pretty well. Now over time I am getting tons of workload and want to introduce VBA in some of those.
My question have two parts.
1) I want to apply conditional formatting with the help of VBA macro to every worksheet starting from second and apply the format to used range except header row and first column which hold primary key
2)The condition what I want to put is the formula which I want to use as below.
=INDEX(Master!$B$2:$H$20,MATCH($A2,Master!$A$2:$A$20,0),MATCH(B1,Master!$B$1:$H$1,0))
basically I want to compare the cell value with value on master worksheet and highlight changes.
The row count and column count can be different based on the data.
I have tried different methods with no or little success.
any alternate solution is also welcome.
I have to validate some data tables on regular basis. which I do with the help of index+match+match function and it work pretty well. Now over time I am getting tons of workload and want to introduce VBA in some of those.
My question have two parts.
1) I want to apply conditional formatting with the help of VBA macro to every worksheet starting from second and apply the format to used range except header row and first column which hold primary key
2)The condition what I want to put is the formula which I want to use as below.
=INDEX(Master!$B$2:$H$20,MATCH($A2,Master!$A$2:$A$20,0),MATCH(B1,Master!$B$1:$H$1,0))
basically I want to compare the cell value with value on master worksheet and highlight changes.
The row count and column count can be different based on the data.
I have tried different methods with no or little success.
any alternate solution is also welcome.
