automatic replace excel cell/range?

  • Thread starter Thread starter simplething
  • Start date Start date
S

simplething

hi.

let say i have below cell in excel work sheet:

.....A......B....C....D
1...Yr01..Yr02
2....20....15
3....12....30
4....16....60


is it possible to create a macro/vb script button or use any function
in excel, which will automatically move/copy range B2---B4 then paste
to A2---A4?

p/s Cell B data are retrieved from another worksheet (includes number
forula)
 
Do you really need a button / macro?
a simple cut and paste will do the trick
anyway I just recorded the move with macro recorder
Sub macro1()
Range("B1:B5").Select
Selection.Cut
Range("A1:A5").Select
ActiveSheet.Paste
End Sub

Try the recorder your self under...... tools.. macro..

Regards
Bill K
 
Back
Top