+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Mickey
    Guest

    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. #2
    Don Guillett
    Guest

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

    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
    dguillett1@austin.rr.com
    "Mickey" <Mickey@discussions.microsoft.com> wrote in message
    news:B3CDEBF3-4837-440F-8FD9-314AE2D818D0@microsoft.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 Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1