+ Reply to Thread
Results 1 to 4 of 4

Pasting text to first blank cell of column and filling down depending on option button

  1. #1
    Registered User
    Join Date
    01-07-2013
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    64

    Pasting text to first blank cell of column and filling down depending on option button

    Hi,

    I have a spreadsheet where after I click a button, I paste text to first blank cell of a column based on the option button selected. Depending on the option button selected, different cell text from Sheet 2 gets pasted to the first blank cell of Column K in Sheet 1 and filled down to as many used rows in Col L. Unfortunately, my IF statements work in such a way that when I copy and paste the first time, it works perfectly. As soon as I go to select another option button, the data that was already in the previously first blank cell of Col K gets overwritten by the new text. For example, the first blank cell in Col K is K6. When I select Option Button 19, the cell text in Sheet 2 Cell A3 gets copied to K6 for as many used rows as in Col L. Now when I select Option Button 20, the cell text in Sheet 2 Cell A4 gets copied to K6, instead of the first blank cell. Below is my code. Any help is truly appreciated!

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572

    Re: Pasting text to first blank cell of column and filling down depending on option button

    Please post a workbook (with some data). The code you posted has many errors...
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    01-07-2013
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    64

    Re: Pasting text to first blank cell of column and filling down depending on option button

    I have attached a sample file. I have changed the cell designations in the sample file (i.e. Col L is Col C in the sample file). I also have a listbox in the excel file, which was put there for a user to be able to select multiple languages and have the selected listbox items pasted. But I haven't gotten that to work. Thanks!
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    01-07-2013
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    64

    Re: Pasting text to first blank cell of column and filling down depending on option button

    Hi, I was just wondering...any luck with issue? Thanks!

+ 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