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

's Computer Specifications

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.

's Computer Specifications

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

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Mickey" <(E-Mail Removed)> wrote in message
news:B3CDEBF3-4837-440F-8FD9-(E-Mail Removed)...
>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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do you move rows onto the next page in excel	=?Utf-8?B?Q2FuZGljZQ==?=	Microsoft Excel Worksheet Functions	1	4th Oct 2007 05:56 AM
RE: how do you move rows onto the next page in excel	=?Utf-8?B?dGltIG0=?=	Microsoft Excel Worksheet Functions	0	3rd Oct 2007 08:41 PM
Excel: How copy all rows that have a given column entry?	=?Utf-8?B?TW90b3duIE1pY2s=?=	Microsoft Excel Misc	20	12th Jun 2007 06:56 PM
Move data from rows to columns in Excel	Pich	Microsoft Excel Programming	3	23rd Nov 2005 06:17 AM
Excel: How can I move data from a form into subsequent rows in a.	=?Utf-8?B?Tk5JR3V5?=	Microsoft Excel Worksheet Functions	2	6th Sep 2004 05:47 PM