Closed Thread
Results 1 to 2 of 2

Problem transfering data from user form to correct blank row in column

  1. #1
    Registered User
    Join Date
    11-08-2013
    Location
    Augusta, Georgia
    MS-Off Ver
    Excel 2010
    Posts
    13

    Problem transfering data from user form to correct blank row in column

    I have a workbook with a user form I made to enter daily production into. The person is not computer literate so I had to make this as simple as possible. After this data is entered into the userform it needs to go into the appropriate column in the last black row. All of the data is currently going into the correct column, but it is overwriting data in another row. Row 35 to be exact. Not sure what I am doing wrong. I am really new to VBA.

    Don't know if any of this will help but I basically got this workbook from someone that is paying me to turn raw data into a functional workbook. I have placed several pivot tables and charts in this workbook. Also several charts. The data page has formulas already set up through the end of the fiscal year.
    Please take a look and help!!!! The data needs to go into sheet1
    Attached Files Attached Files

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Problem transfering data from user form to correct blank row in column

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.



    Please stop and read the forum rules, link in the Menu Bar above. Thanks.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Problem transfering data from userform to last blank cell in column
    By hstarr2021 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2013, 08:59 PM
  2. Correct vba code for text boxes in user form
    By newqueen in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-27-2013, 09:38 PM
  3. Transfering Data from user form to cells
    By reelpix in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-14-2008, 05:04 AM
  4. displaying the correct multipage tab in user form
    By alann2 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-31-2006, 08:32 PM
  5. user form update data problem
    By static69 in forum Excel General
    Replies: 1
    Last Post: 02-14-2005, 03:12 PM

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