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

M

Mickey

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.
 
D

Don Guillett

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Trying to add column headings to array formula 1
INSERT to excel file 4
After I reset my Games they get scambled. Conditional Formatting orMacro messed up somewhere 1
Sum variable range of column entries in offset cell 2
Auto copy data rows between sheets depending on date entry 3
Macro for removing columns/rows, freezing panes etc? 1
How to insert a row into Excel Sheet? 1

Top