+ Reply to Thread
Results 1 to 4 of 4

Copy result from cell with formula to empty cell

  1. #1
    Registered User
    Join Date
    04-27-2016
    Location
    San Diego, CA
    MS-Off Ver
    14.6.1
    Posts
    6

    Question Copy result from cell with formula to empty cell

    I am trying to do some gerrymandering of a sheet to work with Zapier, which won't pull the results data from a cell, only the formula in that cell. What I am trying to do is to create a formula, for instance, in cell F3 to copy the result of the formula in cell E3 and place it into empty cell G3. This would then fill down for each additional row formed.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Copy result from cell with formula to empty cell

    Hi, welcome to the forum

    Formulas cannot "push" anything anywhere, they only affect the cell they are in.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    06-13-2012
    Location
    Dallas
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Copy result from cell with formula to empty cell

    I would consider either a macro or copying and special pasting "values only" if it isn't a lot of data

  4. #4
    Registered User
    Join Date
    04-27-2016
    Location
    San Diego, CA
    MS-Off Ver
    14.6.1
    Posts
    6

    Re: Copy result from cell with formula to empty cell

    I was actually able to "Push" results from one sheet to another successfully, instead of trying to do it on the same sheet.

+ 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] Can a formula result in an 'empty' cell?
    By Cloth Ears in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 10-01-2014, 11:17 PM
  2. Leaving the result cell empty is no data in the cells relating to the formula
    By chrishill12 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-01-2013, 10:50 AM
  3. Replies: 3
    Last Post: 01-04-2012, 02:19 PM
  4. Replies: 10
    Last Post: 12-09-2011, 11:03 AM
  5. Replies: 6
    Last Post: 09-16-2010, 05:19 AM
  6. Formula Return result from non empty cell
    By innocent_eyes in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-22-2008, 03:23 AM
  7. [SOLVED] Formula result as real empty/blank cell
    By Excelerate-nl in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-20-2006, 01:55 AM

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