+ Reply to Thread
Results 1 to 8 of 8

Add formula to existing formulas in a large set of data

  1. #1
    Registered User
    Join Date
    04-21-2011
    Location
    Boston
    MS-Off Ver
    Excel 2010
    Posts
    61

    Add formula to existing formulas in a large set of data

    I have a large set of data with different formulas that I would like to add the following formula to:

    *Sheet1!B2

    Is there a quick way to do this without changing all the formulas one by one?

    Thanks

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Add formula to existing formulas in a large set of data

    without more information you could copy your formula into find, then in replace add the section you are talking about and do replace all (after trying on one) for example.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    04-21-2011
    Location
    Boston
    MS-Off Ver
    Excel 2010
    Posts
    61

    Re: Add formula to existing formulas in a large set of data

    That's what I would normally do but I can't do here because there's a bunch of different formulas in those cells.

  4. #4
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,807

    Re: Add formula to existing formulas in a large set of data

    can you just reference that in a different column? Say you have your formulas in column A. Starting in Cell B1, you could enter, =A1*Sheet1!$b$2, and then fill it down to all formulas in col A. (Not sure if you wanted absolute reference to B2 or not).

  5. #5
    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,917

    Re: Add formula to existing formulas in a large set of data

    A bit wasteful regards columns, but you could always create a few helper columns that would reference your existing cells/formulas, and then just tack the *Sheet1!B2 on that?

    eg =C2*Sheet1!B2
    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

  6. #6
    Registered User
    Join Date
    04-21-2011
    Location
    Boston
    MS-Off Ver
    Excel 2010
    Posts
    61

    Re: Add formula to existing formulas in a large set of data

    Thanks for your help guys. The solution of adding new columns with the new formulas seems to be the easiest options.

  7. #7
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Add formula to existing formulas in a large set of data

    Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
    Thanks.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

  8. #8
    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,917

    Re: Add formula to existing formulas in a large set of data

    Happy to help

+ 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. importing large data into existing spreadsheet.
    By franklithor in forum Excel General
    Replies: 7
    Last Post: 01-11-2018, 04:41 PM
  2. Moving Large Selection of Data to Another Sheet with Formulas??
    By Dee1008 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-06-2017, 05:10 PM
  3. [SOLVED] Transposing large data set with formulas (or pivot if possible)
    By Timmy Seals in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-09-2016, 06:29 AM
  4. Replies: 5
    Last Post: 07-19-2015, 11:05 AM
  5. [SOLVED] Nesting IF and AND formulas within and existing formula
    By ExcelDummy77 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-15-2014, 04:48 PM
  6. retroactively applying formulas to existing data
    By jacquelineb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-06-2013, 10:01 AM
  7. [SOLVED] Adding formulas to modify the existing data by vba
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-20-2013, 08:00 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1