Can I move down 12 rows in excel for every new entry

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mickey - 05 May 2006 15:56 GMT

I am entering records of numbers which have formulas for calculation. I want
to place these records every 12 rows and be able to automate the worksheet
for our office personnel. How? HELP!! There can be anywhere from 50 to 150
records depending on how many batches are produced in manufacturing plant.

Reply to this Message

Don Guillett - 05 May 2006 16:03 GMT

right click sheet tab>view code>copy\paste this. If not column A (1) then
change.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 1 Then Exit Sub
Target.Offset(12).Select
End Sub

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>I am entering records of numbers which have formulas for calculation. I
>want
> to place these records every 12 rows and be able to automate the worksheet
> for our office personnel. How? HELP!! There can be anywhere from 50 to
> 150
> records depending on how many batches are produced in manufacturing plant.

Reply to this Message