I have a data In sheet “Magicbricks-Internal-Details”
I am running the below code and data gets formatted in sheet Format data. After the format data I need additional code after the below code to perform following 4 task.
1) In Sheet “Format data”, in column C, the data is of Property type like, 1BHK, 2BHK, 3BHK, etc. In Column C there are few blank cells. I want to fill that blank cell with the values in next column.
For Example in attachment in Sheet “Format data” cell “C4” is blank and hence it has to be filled with Value in Cell “D4”.
So the result should be as follows.
Cell C4=Commercial Office Space
Cell C7=Commercial Office Space
Cell C8=Commercial Office Space
Cell C11=Commercial Land
2) In Sheet “Format data”, there is a data in column F and G. Some cell values in Column F is Matching with values in Column G.
For Example Value in F5 = G5 (Juhu, Mumbai), F6=G6 (Kalyan, Mumbai), F7=G7 (Anand Nagar, Mumbai), F8=G8 (Lower Parel, Mumbai), F9=G9 (Virar, Mumbai), etc.
Now I want to remove values in Column F which has similar values in Column G.
So the result should be as follows.
F | G
5 (Blank) Juhu, Mumbai
6 (Blank) Kalyan, Mumbai
7 (Blank) Anand Nagar, Mumbai
8 (Blank) Lower Parel, Mumbai
9 (Blank) Virar, Mumbai
10 in navyug nagar Tardeo, Mumbai
3) This case is also Same as point 2
In Sheet “Format data”, there is a data in column J and K. Some cell values in Column J is Matching with values in Column K.
For Example Value in J3 = K3 (50 per sqft), J6=K6 (3000 per sqft), J9=K9 (12 per sqft), J12=K12 (11 per sqft), J14=K14 (4000 per sqft), etc.
Now I want to remove values in Column J which has similar values in Column K.
So the result should be as follows.
J | K
6 (Blank) 3000 per sqft
9 (Blank) 12 per sqft
12 (Blank) 11 per sqft
14 (Blank) 4000 per sqft
17 (Blank) 59 per sqft
4) In Sheet “Format data”, there is a data in column H which are the amount in short words. (TH for Thousands, Cr for Crore and Lac for Lakhs)
I want to convert the short word into actual figure in next column (Column I).
So the result should be as follows.
H | I
2 40 TH 40000
3 55.2 TH 55200
4 5.5 Cr 55000000
5 4000 4000
6 15.5 Lac 1550000
7 2.8 Cr 28000000
8 2.5 Lac 250000
9 8000 8000
Please not we will be adding more record time to time and also might add any column in between. So request you to give cell and column reference details note in code.
Please Login or Register to view this content.
Bookmarks