navrichard
New Member
- Joined
- Sep 6, 2009
- Messages
- 8
Hi All,
I am looking for a VB Script where the column A and column B have data
if column b is has data (in a cell) then the subsequent cell in cell A shoul be deleted, if the cell in column b is "NULL" then the value in cell a should remain,
eg:
1(remove) = 1
2 (remain)= "NULL"
3 (remain)= "NULL"
4 (remove) = xyz
Step 2,
in cell C i have lots of duplicate entries say
1
1
1
2
2
2
3
3
3
here the duplicate values should be replaced by "DUPLI"
some thing like this
1= 1
1="DUPLI"
1="DUPLI"
2=2
2="DUPLI"
2="DUPLI"
i am no VB expert - but since i have to do this on a daily basis on a hudge sheet link it takes almost 3hrs to replace the duplicates and removing the data on the macro one,![Frown :( :(](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
PLEASe PLEASe can someone help me on this ....
I am looking for a VB Script where the column A and column B have data
if column b is has data (in a cell) then the subsequent cell in cell A shoul be deleted, if the cell in column b is "NULL" then the value in cell a should remain,
eg:
1(remove) = 1
2 (remain)= "NULL"
3 (remain)= "NULL"
4 (remove) = xyz
Step 2,
in cell C i have lots of duplicate entries say
1
1
1
2
2
2
3
3
3
here the duplicate values should be replaced by "DUPLI"
some thing like this
1= 1
1="DUPLI"
1="DUPLI"
2=2
2="DUPLI"
2="DUPLI"
i am no VB expert - but since i have to do this on a daily basis on a hudge sheet link it takes almost 3hrs to replace the duplicates and removing the data on the macro one,
PLEASe PLEASe can someone help me on this ....
Last edited: