+ Reply to Thread
Results 1 to 3 of 3

Problem transfering data from userform to last blank cell 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 userform to last blank cell 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 Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: PLEASE HELP!!!!!! Problem transfering data from userform to last blank cell in column

    What is Daily in this line here:
    Please Login or Register  to view this content.
    Its not defined and I don't see a Sheet named daily. This line is not holding the correct number.
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  3. #3
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Problem transfering data from userform to last blank cell in column

    What sheet is this code supposed to be run on?

+ 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. Problem transfering data from user form to correct blank row in column
    By hstarr2021 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-17-2013, 06:34 PM
  2. Replies: 2
    Last Post: 01-25-2013, 10:06 AM
  3. Userform textbox to fill next blank cell in column
    By RaffertyL in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2012, 03:20 AM
  4. transfering multi selected list box in userform to one cell in worksheet
    By isatrist in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-04-2011, 12:35 AM
  5. Transfering Row of Data to Another Sheet while Skipping Blank Cells
    By inwalkedbud in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2007, 01:10 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