Plz give syntax in VB to paste copied text found in Column A,Row 1 to Column B,Rows 1-5. The raw data is shown as Column A, I want to find "$" in ColumnA and PASTE in Column B, for each line item until the next Blank is found. See example below:

Column A Column B
1$SYSTEM $SYSTEM
2 CONFTEXT $SYSTEM
3 CONFTXT1 $SYSTEM
4 CONFTXT2 $SYSTEM
5 CONFTXT3 $SYSTEM
6
7$SYSTEM2 $SYSTEM2
8 MYTEXT $SYSTEM2
9
10
11$SYSTEM3 $SYSTEM3
12 YOURTXT $SYSTEM3
13 YOURTXT2 $SYSTEM3
14
15

How can this best be done? Is it better to use VB or will a formula like VLOOKUP work? There are a total of 2703 occurances of $ in Column A and there is a total of 60960 lines in column A.

paste.cell A1. Also i wana put a condition(Check) if the pasted value in A1 cell is B. Can anyone plz guide.

you can do:

Range("A1").value = Range("A2").value

this is like copying A2 to A1.

then:

if  Range("A1").value = "B" then

' do something

else

' do nothing

endif

Recording a macro can help in this case too..