+ Reply to Thread
Results 1 to 2 of 2

GoogleSheets - Paste values from range to the first empty cell in a diffrent column

  1. #1
    Registered User
    Join Date
    03-07-2022
    Location
    Moscow, Russia
    MS-Off Ver
    2013
    Posts
    2

    GoogleSheets - Paste values from range to the first empty cell in a diffrent column

    Hello!

    I am trying to write a macro that would copy the data from H23:I32 to adjacent columns J23:K60. Assuming there are values in J23:K60, I wish to paste the data below the last cell with data.

    The sheet I am working with is 'Loot'.

    Unfortunately, my code doesn't search for the last cell with value and always pastes the data to J23. Thefore my list gets overwritten instead of values being added to it.

    Please Login or Register  to view this content.
    How would I go about fixing my code so that I have a growing list in J23:K from H23:I values?

    Many thanks in advance!

  2. #2
    Valued Forum Contributor
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    797

    Re: GoogleSheets - Paste values from range to the first empty cell in a diffrent column

    this scripting will:

    * create a Custom Menu at the top of your Google Sheets front end
    * give Custom Menu option to Copy H23:I32 to end of J:K

    Requirements:
    cell J22 must have a value or content of some kind

    Please Login or Register  to view this content.
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

+ 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. GoogleSheets Query: Write date to cell when range changes, delete when range is empty
    By kingofcamden in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 03-24-2021, 12:36 PM
  2. [SOLVED] how to insert empty rows based on column B cell values and paste above values with macro?
    By genetist in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-11-2018, 11:47 AM
  3. copy multiple ranges, find next empty cell in first column and paste values as text
    By Zlatko.Pan in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-18-2018, 06:13 PM
  4. 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
  5. [SOLVED] Paste formula to the last empty cell based on a non-empty cell on another column
    By bhenlee in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-02-2015, 04:07 PM
  6. [SOLVED] Copy and paste values in column range into first empty column to the left
    By gbatz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-15-2014, 06:59 PM
  7. 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

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