+ Reply to Thread
Results 1 to 2 of 2

automatically place formulas into any newly inserted rows in the sheet

  1. #1
    Registered User
    Join Date
    07-20-2008
    Location
    USA
    Posts
    1

    automatically place formulas into any newly inserted rows in the sheet

    Hi, I have several columns of data alongside several columns of formulas. I was wondering if there was a way to automatically place those formulas into any newly inserted rows in the sheet? I know that its pretty easy to do manually, but I need to make it as user friendly as I can for my boss.

    Thanks

  2. #2
    Forum Contributor
    Join Date
    04-21-2007
    Location
    Lima, Peru
    MS-Off Ver
    2000, 2007, 2010
    Posts
    674

    Inserting rows with formulas

    Hi

    If you try the following code I think that it should do what you require.


    Please Login or Register  to view this content.
    The code inserts a line below the cursor and copies formulas only to the new line from the line above.

    Regards

    Jeff

+ 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