+ Reply to Thread
Results 1 to 4 of 4

Automatically copy info from a cell to rest of the row

  1. 11-28-2020, 06:56 PM #1
    fozuk1609
    fozuk1609 is offline
    Registered User
    Join Date
    07-20-2016
    Location
    Bromsgrove
    MS-Off Ver
    Office 365
    Posts
    39

    Automatically copy info from a cell to rest of the row

    I have a spreadsheet and in column A some cells have data and come dont. I want an automatic way top copy and paste the data from cell A2 into all empty cells below. When it comes to a cell below thats populated it will then stop and copy and paste the populated cell into all the ones below until it comes to another populated cell. I need to do this in column A and F.

    Ive attached the spreadsheet.

    Is there any way I can do this
    Attached Files Attached Files
    Last edited by fozuk1609; 11-29-2020 at 01:47 PM.
    Reply With QuoteRegister To Reply
  2. 11-28-2020, 09:16 PM #2
    Estevaoba
    Estevaoba is offline
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365
    Posts
    1,249

    Re: Automatically copy info from a cell to rest of the row

    Try in a blank cell, for example, H2 and copy down:
    =IF(A2="",H1,A2)

    Good luck!
    Reply With QuoteRegister To Reply
  3. 11-29-2020, 01:47 PM #3
    fozuk1609
    fozuk1609 is offline
    Registered User
    Join Date
    07-20-2016
    Location
    Bromsgrove
    MS-Off Ver
    Office 365
    Posts
    39

    Re: Automatically copy info from a cell to rest of the row

    Thanks - that worked perfectyl
    Reply With QuoteRegister To Reply
  4. 11-29-2020, 02:56 PM #4
    Estevaoba
    Estevaoba is offline
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365
    Posts
    1,249

    Re: Automatically copy info from a cell to rest of the row

    You’re welcome! Glad to help.
    Thanks for the feedback and for the reputation added.
    Have a blessed day.
    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] I need to remove certain info from a cell while keeping the rest of the info
    By excel is cool in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-03-2016, 01:22 PM
  2. Copy info from one sheet to anothe automatically
    By gw32 in forum Excel General
    Replies: 3
    Last Post: 02-24-2016, 12:40 PM
  3. Help! Need to move data from one cell in one row into several rows - & copy rest of row
    By jeffphplus in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 04-07-2014, 06:02 AM
  4. [SOLVED] Copy info from one sheet to another so it organizes automatically!
    By ropciks113 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-05-2013, 01:58 AM
  5. vlookup help - returning matching ones with rest of column info
    By gamurphy64 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-08-2013, 06:26 PM
  6. Macro : To find word and Select rest after this cell and delete rest
    By Zortabello in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2010, 08:06 AM
  7. [SOLVED] How do I format a chart in Excel, but not the rest of the info?
    By Excel dummy in forum Excel General
    Replies: 1
    Last Post: 10-24-2005, 06:05 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