Hi All,

I am new to VBA and I would like to say thanks in advance for any help I can get.

I would like to use a command button to copy a row of data from one workbook to a column in another workbook. The row of data will have different values on a daily basis but will always be "B2" through "BE2". I would like the copied row of data pasted in the next available column to the left in the other workbook .