Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can I move down 12 rows in excel for every new entry
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can I move down 12 rows in excel for every new entry
right click sheet tabview codecopy\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 -- Don Guillett SalesAid Software "Mickey" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a shortcut key to move between sheets in Excel? | Excel Discussion (Misc queries) | |||
enable automatic refresh | Excel Worksheet Functions | |||
Excel should have more than 65536 rows, it should go 150000 | Excel Discussion (Misc queries) | |||
How do I find duplicate rows in a list in Excel, and not delete it | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |