+ Reply to Thread
Results 1 to 1 of 1

VBA to Insert row to another sheet, line BEFORE the last row and keep formats and formulas

  1. #1
    Forum Contributor
    Join Date
    07-03-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    139

    VBA to Insert row to another sheet, line BEFORE the last row and keep formats and formulas

    I have attached my workbook to this as reference. What I am looking for is code that will fire when a user clicks the Submit Times button that will insert a row below the last time entry row BUT Prior to the Totals for Projects row on the Data Logs sheet. On insert all formulas and formats should be the same as the row above the newly inserted row.

    I know how to insert to last row, but insert and copy formulas and formats to a row in between rows I am not familiar with.

    Thoughts?

    Thanks.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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