+ Reply to Thread
Results 1 to 2 of 2

userform insert data on next empty row in specific column regardless of formulas

  1. #1
    Registered User
    Join Date
    01-28-2013
    Location
    Hawaii
    MS-Off Ver
    Excel 2013
    Posts
    9

    userform insert data on next empty row in specific column regardless of formulas

    here i am, still trying to understand crap, with a version of my tracker improved upon by a coworker(edwin deserves most of the credit for this) and FDibbins had more than a little bit to do with it as well. im trying to create userforms for this same tracker. here i am stuck. it wont insert data in rows that have formulas. say i have formulas in 100 rows to take input data and output other esential data, my forms input in row 101+. im pissed and lack the intelligence to take what i gain from internet searches to create VBA code that will exclude these data-containing columns when inserting data of my own. I will upload a basic file. The yellow columns contain formulas that are critical to the other functions of this workbook which i dont want to effect at this time. ignore body fat and beyond. ill cros that bridge when i come to it.pt tracker with forms(0.1).xlsmpt tracker with forms(0.1).xlsm

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,136

    Re: userform insert data on next empty row in specific column regardless of formulas

    Ok, so I changed the ways things work a little. Instead of having 100 blank rows, I deleted all except the current record.

    When you copy a row, it inherits all the properties of the cells. So, when I copy the last line and paste it underneath, all of the formatting and formulas (as well as the values) come with it. Then it's just a matter of clearing all the userform values (just as a precaution) before adding the userform vales from the running userform. This makes the form perpetual.
    Attached Files Attached Files
    David
    (*) Reputation points appreciated.

+ 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