Test

[Molly Brennholz]

Some notes to help me in solving this Thread:
http://www.excelfox.com/forum/showth...te-conditional

_____ Workbook: 1.xlsx ( Using Excel 2007 32 bit )

Row\Col	A	B	C	D	E	F	G	H	I	J	K	L
1	NSE	25	6	>	50000	A					GTT
2	NSE	22	6	>	10000	A					GTT
3	NSE	15083	6	>	70000	A					GTT
4	NSE	17388	6	>	20000	A					GTT
5	NSE	100	6	>	170000	A					GTT
6

Worksheet: Sheet1 (4)

If column B of 2.xlsm match with column B of 1.xls then paste the data from column C of 2.xls as 1,2,3,4,5 and so on....
&
If column B of 2.xlsm doesn't match with column B of 1.xls then delete all the data from column C of that row

_____ Workbook: 2.xlsm ( Using Excel 2007 32 bit )

Row\Col	A	B	C	D	E	F	G	H
1	Symbol
2	ACC	22	1	2
3	ADANIENT	25	1
4	ADANIPORTS	15083	1	2	3
5	ADANIPOWER	17388	1	2	3	4	5
6	AMARAJABAT	100	1	2	3	4
7	ASIANPAINT	236	1	2
8
9
10
11
12			cells highlighted in red colour doesn’t match with 1.xls show the data from column C will be cleared so 1,2 will be erased
13			cells highlighted in green colour matches with 1.xls show we will paste the data from column C but if column C has data then we will paste to column D and if column D also has data then column E and so on….
14			highlighted colour is only for understanding purpose in actual file there will not be any highlighted colour data
15

Worksheet: Sheet1