I found your previous posting. This line:

Destination:=.Cells(X - 9 + DataRow + Z, MoveToColumn)

Tells VBA to put everything in column D. MoveToColumn = 4 which = D.
To move it to the right of column D, you will either need to change the
value of MoveToColumn or add another value to it in the statement above.


"J" wrote:

Hi.. well i'm back again.. this glitch is more than I can figure out... The
macro seems to be putting the information in only "one" column...

the information that needs to be inserted is going down to the 5th row in
Column D and putting "all" of the information there, instead of placing each
row to the right of Column D. Does that make sense?

Thanks, J