+ Reply to Thread
Results 1 to 3 of 3

Formula/Function/VB to copy none blank cells

  1. 06-17-2016, 05:45 AM #1
    liamfrancis2013
    liamfrancis2013 is offline
    Forum Contributor
    Join Date
    01-04-2016
    Location
    Newcastle
    MS-Off Ver
    2016
    Posts
    107

    Unhappy Formula/Function/VB to copy none blank cells

    Hi,

    I have a spreadsheet in which I only want it to copy the cells WHICH contain data (are not blank) and paste it in the purple cells, here is an example sheet:

    https://www.dropbox.com/s/ab24z55qxn...mple.xlsx?dl=0


    My real sheet contains a lot more data so i need a way to to do this both quickly and efficiently.

    Thanks,
    Liam
    Last edited by liamfrancis2013; 06-17-2016 at 05:50 AM.
    Reply With QuoteRegister To Reply
  2. 06-17-2016, 06:18 AM #2
    JohnTopley
    JohnTopley is online now
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,237

    Re: Formula/Function/VB to copy none blank cells

    Please show expected results as your explanation is open to interpretation.

    Please post on forum as many people do not wish to go to hosting sites.
    Reply With QuoteRegister To Reply
  3. 06-17-2016, 06:26 AM #3
    liamfrancis2013
    liamfrancis2013 is offline
    Forum Contributor
    Join Date
    01-04-2016
    Location
    Newcastle
    MS-Off Ver
    2016
    Posts
    107

    Re: Formula/Function/VB to copy none blank cells

    Ok here's my expected result, i cant use attachments for files on the forum for some reason, so here's an image:

    ex.png
    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] Copy down formula until blank cells
    By terry3218 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-03-2015, 10:43 PM
  2. Function cell copy that will support blank cells
    By MBCMDR in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-19-2015, 10:09 AM
  3. copy formula to the blank cells in a range
    By krazyhype19 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-09-2014, 06:29 AM
  4. [SOLVED] Want to copy formula from G7 to blank cells
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-18-2014, 02:37 AM
  5. Copy Formula from set cells, paste in blank rows below as value
    By cappie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2013, 02:45 PM
  6. [SOLVED] Copy a formula down in blank cells
    By Kevin P in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-13-2012, 06:47 AM
  7. I want to copy a formula n Excel but skip any blank cells
    By Ann in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-12-2005, 03:00 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1