VBA code to compare data in two columns and update

[Wafee]

Hi,

Have been trying to write a logic but not able to gte through, can someone help me with this.

I have below data in A & B columns of sheet1.

Book1
	A	B
1	Senior Manager	Manager
2	GERMANOTTA, DOMINIC
3		BONOMO, MICHAEL
4		HALL, TAMARA L
5		PRADHAN, JEETENDRA
6		RANGARAJAN, JAGANNATH K
7		STRATFORD, CHRIS
8		STRATTON, LAURA M
9		((blank)
10	DINGARI, HRUSHIKESH K
11		NAIR, GIRISH
12		SARKAR, ASHIS
13	VENKATRAMAN, SRINIVAS
14		HUGHES, GEORGE L
15	THAKER, DHAVAL V
16	(blank)
17	FAHEEM, WAEL
18		AGARWAL, DINESH
19		CHANDRASEKHARAN, RAJEEV
20		CHANG, SOK WU W
21		ZAVAR, MASTANEH
22		WHITE, CHRIS L
23		(blank)
24	Grand Total
Sheet1

below data is in T & U columns of sheet 2.

Copy of Overall Shankar_Cox_UnapprovedTime Report.xlsm
	T	U
1	Senior Manager	Manager
2	GURUMURTHY, VIVEK	JAIN, ARCHANA
3	ZIAEE, KAMRAN	KUMAR, NANDA
4	GURUMURTHY, VIVEK	BELIHOMJI, ADIL
5	FAHEEM, WAEL	CHANDRASEKHARAN, RAJEEV
6	GURUMURTHY, VIVEK	JAIN, ARCHANA
7	FAHEEM, WAEL	(blank)
8	ZIAEE, KAMRAN	CHAKRAVARTY, SHOMA
9	GURUMURTHY, VIVEK	BELIHOMJI, ADIL
10	FAHEEM, WAEL	CHANDRASEKHARAN, RAJEEV
11	GURUMURTHY, VIVEK	BELIHOMJI, ADIL
12		(blank)
13	ZIAEE, KAMRAN	(blank)
14		(blank)
15	GURUMURTHY, VIVEK	BELIHOMJI, ADIL
16		(blank)
17		(blank)
18	GURUMURTHY, VIVEK	BELIHOMJI, ADIL
19	GURUMURTHY, VIVEK	JAIN, ARCHANA
20	GURUMURTHY, VIVEK	BELIHOMJI, ADIL
21	FAHEEM, WAEL	WHITE, CHRIS L
22	GURUMURTHY, VIVEK	JAIN, ARCHANA
23	GURUMURTHY, VIVEK	BELIHOMJI, ADIL
24	GURUMURTHY, VIVEK	NIRANJANI, HIMANSHU
25	GURUMURTHY, VIVEK	JAIN, ARCHANA
Source Data

Code has to compare data in sheet 2 with sheet 1 and if any new senior manager is found then the name has to be updated in the "A" column of sheet 1 in the last before row that contains data(above "Grand Total").

if new manager is found then that name should be update under respective senior manager in sheet1.(in this case code has to check the combination of senior manager and manager as there might be case where manager moves from one senior manager to other - in that case new line to be added under the senior manager and it also retain old line for that manager ). thank you in advance.

 

[TotallyConfused]

Hello Wafee

Isn't this discussing the same problem as you wrote about in your other posting at:

VBA code to compare two columns in different worksheets

Hi, I have below code where I am trying to compare two columns of data in different worksheets and if anything new is found then it has been added above last row of sheet1 in column "A". the below code is only adding empty row. can someone help me with this. It has to basically compare column A...

www.mrexcel.com

I think I answered your question there.
TotallyConfused

 

[Wafee]

Hello Wafee

Isn't this discussing the same problem as you wrote about in your other posting at:

VBA code to compare two columns in different worksheets

Hi, I have below code where I am trying to compare two columns of data in different worksheets and if anything new is found then it has been added above last row of sheet1 in column "A". the below code is only adding empty row. can someone help me with this. It has to basically compare column A...

www.mrexcel.com

I think I answered your question there.
TotallyConfused

No mate, the scenario is different and might require totally different logic than what I tried previously.

 

[TotallyConfused]

If I remember correctly, you said then that your program worked, except it put the person's name AFTER the last row of data, instead of inserting a new row just above the last row. Now you are talking about columns 'A' and 'B' on the same sheet rather than columns 'A' on two sheets. Maybe I misunderstood your question then.

 

[Wafee]

If I remember correctly, you said then that your program worked, except it put the person's name AFTER the last row of data, instead of inserting a new row just above the last row. Now you are talking about columns 'A' and 'B' on the same sheet rather than columns 'A' on two sheets. Maybe I misunderstood your question then.

Yes That's right my requirement has changed now and I am finding it difficult to come up with a code.