+ Reply to Thread
Results 1 to 6 of 6

Selecting last blank cell in column, then setting it

  1. #1
    Registered User
    Join Date
    07-12-2016
    Location
    massachusetts
    MS-Off Ver
    excel 2010
    Posts
    44

    Selecting last blank cell in column, then setting it

    Hi,

    Found a bunch of really similar issues, but nothing that's allowed me to do what I need to do... I have three worksheets that are being consolidated into one. They each have similar column headers (these aren't tables), but not every cell in a row is blank. As a result, I can't just paste them into the next available cell.

    I'm trying to find the next blank cell in column A of the International Tracker tab, and paste columns below starting from the first blank cell, and then offsetting that cell from column A to get the position of the other columns to be pasted...

    As a (very rough - I've tried a billion other things but this is probably the most simple to avoid taking up space) example:

    Please Login or Register  to view this content.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Selecting last blank cell in column, then setting it

    This appears to be a situation that is perfect for a Power Query Solution. Power Query allows you to append data automatically. Look at this video for a tutorial. Power Query is a free add on for XL2010.

    https://www.youtube.com/watch?v=HcfKOusOJhA
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    07-12-2016
    Location
    massachusetts
    MS-Off Ver
    excel 2010
    Posts
    44
    Quote Originally Posted by alansidman View Post
    This appears to be a situation that is perfect for a Power Query Solution. Power Query allows you to append data automatically. Look at this video for a tutorial. Power Query is a free add on for XL2010.

    https://www.youtube.com/watch?v=HcfKOusOJhA
    Thank you - I originally went down that route but ultimately we'll be doing more with this tracker that involves vba, and it's updated frequently enough to have caused problems with PQ. Granted maybe I'm screwing something up, but if there's any potential to do this in vba it would be ideal as I have multiple macros for this run off of one hotkey.

    Edit: replied from mobile, fixed spelling

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Selecting last blank cell in column, then setting it

    How about
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    07-12-2016
    Location
    massachusetts
    MS-Off Ver
    excel 2010
    Posts
    44

    Re: Selecting last blank cell in column, then setting it

    Quote Originally Posted by fluff13 View Post
    how about
    Please Login or Register  to view this content.
    yes! Thank you!

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Selecting last blank cell in column, then setting it

    You're welcome & thanks for the feedback.

+ 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. [SOLVED] Hyperion Hierarchy - selecting next non-blank cell up in the column to the left
    By AFOY in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 10-04-2019, 09:50 AM
  2. Selecting blank cells next to a column with data
    By Mr_Phil in forum Excel General
    Replies: 1
    Last Post: 05-06-2017, 06:23 PM
  3. [SOLVED] Selecting Range upto first blank cell in a column
    By biznez in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-01-2016, 04:59 PM
  4. Setting date of column if another not blank
    By cowasaki in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-05-2008, 01:49 PM
  5. Selecting Non Blank Cells in a Column and inserting a row
    By salkovsg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2007, 03:54 PM
  6. [SOLVED] Setting column width for blank columns
    By gmr7 in forum Excel General
    Replies: 0
    Last Post: 01-17-2006, 11:20 AM
  7. Selecting none blank rows in a column
    By Colonel Hogan in forum Excel General
    Replies: 0
    Last Post: 01-10-2005, 10:15 AM

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