+ Reply to Thread
Results 1 to 7 of 7

Copy Textbox values to last blank row for specific columns

  1. #1
    Registered User
    Join Date
    03-09-2010
    Location
    Cerritos, CA
    MS-Off Ver
    Excel 2010
    Posts
    31

    Copy Textbox values to last blank row for specific columns

    Happy New Year:

    Need a resolution to copy textbox values (5 textboxes in total) from a userform to a specific column for each Textbox on a spreadsheet. Textbox values should not overwrite what previously entered:

    Sample Table:
    Table Sample.PNG

    Current code contained in userform is as follows. Step 2 is where the issue is:
    Please Login or Register  to view this content.
    Any assistance would be helpful!

    Thank you.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Copy Textbox values to last blank row for specific columns

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Copy Textbox values to last blank row for specific columns

    Maybe something like
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    03-09-2010
    Location
    Cerritos, CA
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Copy Textbox values to last blank row for specific columns

    Fluff13...

    Works perfectly! Thank you and best wishes for 2019.

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Copy Textbox values to last blank row for specific columns

    You're welcome & thanks for the feedback

    This would probably be a neater way of dong it
    Please Login or Register  to view this content.
    Last edited by Fluff13; 12-28-2018 at 03:59 PM.

  6. #6
    Registered User
    Join Date
    03-09-2010
    Location
    Cerritos, CA
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Copy Textbox values to last blank row for specific columns

    I can make that change.

    I did notice that the textbox values are overwriting previous entries. Meaning that it's restarting from the first row on each field and overwriting it. In the screen shot I placed a black line to indicate a new entry from the previous starting at the batch ID field. In short everything above the black line should remain static and everything below the black line starting at the batch ID field would be considered a new form entry, etc.

    In this case from the screenshot, row 5 (excluding the header name) and column 5 should begin a new batch number, new PCI status entry, etc.

    I changed the row reference to start at row 2 rather than row 1 so it doesn't overwrite the field name for each column:
    Please Login or Register  to view this content.
    Is there a way to correct the overwrite issue?

    Many thanks again.

  7. #7
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Copy Textbox values to last blank row for specific columns

    The code shouldn't be overwriting anything.
    It looks for the last value in col E and then adds data to the row below.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy specific columns from closed workbook, paste as values
    By marcosis in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-26-2018, 07:30 AM
  2. [SOLVED] Formula: copy rows in a range, based on non-blank values in one of the columns
    By Glenn Kennedy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-16-2013, 09:08 AM
  3. Macro to copy values from specific columns from different workbooks to one sheet
    By sksajid7 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-11-2013, 09:50 AM
  4. Replies: 3
    Last Post: 02-20-2013, 08:54 PM
  5. [SOLVED] Copy Specific Columns if they match values from another sheet
    By Costasg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-04-2012, 09:09 AM
  6. Replies: 2
    Last Post: 02-06-2012, 05:16 PM
  7. Filter, copy specific columns, and paste to another sheet as VALUES ONLY
    By elobelix in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-04-2010, 11:59 AM

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