Is there a formula for...

  • Thread starter Thread starter darno
  • Start date Start date
D

darno

All i need to know is that is there a formula to copy the contents o
current row to a specific row. For example if my cursor is placed o
row 10 and as soon as i fill a row based on 5 or more columns it shoul
copy the full row and paste it on row 1. or if it can be done by 1 cel
at a time?


Regards,

Darn
 
Here is a selection event that moves the cursor to the start of the next
row.
Use right arrow key to move cursor

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Target.Row > 5 And Target.Column = 6 Then ActiveCell.Offset(1, -6).Select
End Sub

so this should do what you want. Right click on sheet tab>view
code>copy/paste this.

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Target.Row > 5 And Target.Column = 6 Then _
ActiveCell.EntireRow.Copy Cells(1, 1)
End Sub
 
Back
Top