+ Reply to Thread
Results 1 to 4 of 4

Fill a column with a formula up to an empty adjacent cell

  1. 06-25-2021, 02:09 PM #1
    dburge07
    dburge07 is offline
    Registered User
    Join Date
    05-25-2021
    Location
    Michigan, US
    MS-Off Ver
    MS 365
    Posts
    37

    Fill a column with a formula up to an empty adjacent cell

    So i'm trying to apply =Left(B2,4) to a static range that changes daily. How can I apply the formula up to the first empty row of Column B?

    Sample workbook attached.

    Thanks!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-25-2021, 02:16 PM #2
    cubangt
    cubangt is offline
    Valued Forum Contributor
    Join Date
    05-15-2017
    Location
    US
    MS-Off Ver
    365
    Posts
    901

    Re: Fill a column with a formula up to an empty adjacent cell

    You can do something like i do in my report

    Please Login or Register  to view this content.
    If you find the suggestion or solution helpful, please consider adding reputation to the post.
    Reply With QuoteRegister To Reply
  3. 06-25-2021, 02:18 PM #3
    Artik
    Artik is offline
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,526

    Re: Fill a column with a formula up to an empty adjacent cell

    Try this 
    Please Login or Register  to view this content.
    Artik
    Reply With QuoteRegister To Reply
  4. 06-25-2021, 02:31 PM #4
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,523

    Re: Fill a column with a formula up to an empty adjacent cell

    Short and sweet!

    Please Login or Register  to view this content.
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    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] Find first empty cell and fill in formula too the last row of data in another column
    By fireguy7 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2018, 05:51 PM
  2. Count column value then adjacent column cell fill color
    By MIGARDEIN in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-09-2015, 01:13 AM
  3. How to fill the values in the adjacent columns if the column is not empty
    By krkarthik in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2015, 07:01 AM
  4. How to Populate an Empty Cell with Values from Adjacent Same Record But Different Column
    By lyndy256 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-01-2013, 10:27 PM
  5. [SOLVED] Macro to find the empty cell in a column and copy a adjacent row to another column.
    By naga in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-18-2013, 07:44 AM
  6. [SOLVED] Fill Formula up to last empty adjacent Column
    By Floydlevedale in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 04-10-2013, 09:57 AM
  7. Fill empty cells per adjacent column
    By ElmerS in forum Excel General
    Replies: 11
    Last Post: 10-20-2010, 05:56 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