+ Reply to Thread
Results 1 to 7 of 7

Copy active cell to first empty cell in specific column in another sheet

  1. 11-25-2017, 01:46 PM #1
    Shanks100
    Shanks100 is offline
    Registered User
    Join Date
    07-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    15

    Copy active cell to first empty cell in specific column in another sheet

    Hi, I'm looking for a way to copy the current active cell to the first empty cell in Colum G of another sheet.

    I am part of the way with the following code but cannot seem to finish it so that works the way I want

    Please Login or Register  to view this content.
    This copies A16 and I need to copy the current active cell instead, and currently pastes to G3 and I need it to paste to the first empy cell in column G

    Any help would be really appreciated, Mike
    Last edited by jeffreybrown; 11-25-2017 at 01:47 PM. Reason: Please use code tags!
    Reply With QuoteRegister To Reply
  2. 11-25-2017, 01:53 PM #2
    Mumps1
    Mumps1 is offline
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,901

    Re: Copy active cell to first empty cell in specific column in another sheet

    Try:
    Please Login or Register  to view this content.
    Last edited by Mumps1; 11-25-2017 at 01:56 PM.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.
    Reply With QuoteRegister To Reply
  3. 11-25-2017, 01:55 PM #3
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Copy active cell to first empty cell in specific column in another sheet

    Did you try:

    Please Login or Register  to view this content.
    ???
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
    Reply With QuoteRegister To Reply
  4. 11-25-2017, 10:09 PM #4
    Shanks100
    Shanks100 is offline
    Registered User
    Join Date
    07-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    15

    Re: Copy active cell to first empty cell in specific column in another sheet

    Thank you Mumps1 and xladept, this has been bothering me for longer than care to admit. Your solution works just as I wanted.
    Thanks for giving your time.
    Reply With QuoteRegister To Reply
  5. 11-25-2017, 10:34 PM #5
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Copy active cell to first empty cell in specific column in another sheet

    You're welcome!
    Reply With QuoteRegister To Reply
  6. 11-26-2017, 10:46 AM #6
    Mumps1
    Mumps1 is offline
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,901

    Re: Copy active cell to first empty cell in specific column in another sheet

    Glad to help.
    Reply With QuoteRegister To Reply
  7. 11-26-2017, 12:21 PM #7
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Copy active cell to first empty cell in specific column in another sheet

    Thanks for the rep!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA to find the nearest empty cell in column F and use that as the active cell.
    By oneblondebrow in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2017, 11:55 AM
  2. Non active cell non active sheet copy row from cell refference.
    By _delete() in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2016, 02:36 AM
  3. Copy paste specific range to last non empty cell in Column A different sheet
    By realrookie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-18-2016, 04:20 PM
  4. [SOLVED] if workbook inactive for 30sec make last empty cell in column b the active cell
    By sspreyer in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-30-2013, 09:01 PM
  5. [SOLVED] if cell x in column D has a specific value then copy cell x from column A to sheet B
    By new@excel in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-28-2013, 07:26 PM
  6. Copy values from cell in active row, paste in first empty cell in spesified column.
    By Test123Test in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-19-2012, 05:20 PM
  7. Macro-Copy&Paste Fixed Data Ranges Into Last Empty Cell of Specific Column
    By hailnorm in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-26-2009, 10:15 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1