+ Reply to Thread
Results 1 to 11 of 11

Global formulas for several sheets?

  1. #1
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    Excel 2010 14.04.4760.1000
    Posts
    468

    Global formulas for several sheets?

    So I have this spreadsheet I've been using forever now so it's very long and I want to start splitting it across several sheets but don't want to have to made edits across several sheets. So how do I keep a global set of formulas for several sheets?

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Global formulas for several sheets?

    Not sure what you mean. Maybe right click on the sheetname, move/copy create a copy???
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    Excel 2010 14.04.4760.1000
    Posts
    468
    Quote Originally Posted by Glenn Kennedy View Post
    Not sure what you mean. Maybe right click on the sheetname, move/copy create a copy???
    Suppose you want to add columns, change formulas, whatever. And you have 6 sheets that all are based off the one table? I want them separate tables so I can just look at and sort certain data, like "sold" items vs "for sale".
    I want a separate sheet so I can at least narrow my view/workspace down to one category. I do a lot of lot of sorting for certain views and don't want to be dealing with ALL items in my inventory.

    Idk. Is there like a master table you can make?

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Global formulas for several sheets?

    Still not clear.


    A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

    Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.

  5. #5
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    Excel 2010 14.04.4760.1000
    Posts
    468
    Quote Originally Posted by Glenn Kennedy View Post
    Not sure what you mean. Maybe right click on the sheetname, move/copy create a copy???
    Maybe I'm being greedy here. Should I instead have different sheets with their own unique characteristics? This might be a better idea.

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Global formulas for several sheets?

    Quote Originally Posted by juntjoo View Post
    Maybe I'm being greedy here. Should I instead have different sheets with their own unique characteristics? This might be a better idea.
    You can create them from a master table. IMHO, needessly spliting one big block of data is a bad idea.

  7. #7
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    Excel 2010 14.04.4760.1000
    Posts
    468
    Quote Originally Posted by Glenn Kennedy View Post
    You can create them from a master table. IMHO, needessly spliting one big block of data is a bad idea.
    Thanks. I'll look into that. Hopefully it works on mobile. I use it both on pc and android
    Excel 1.0.1 (16.0.14326.20140) (Android)
    Excel 2010 14.04.4760.1000

  8. #8
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    Excel 2010 14.04.4760.1000
    Posts
    468

    Re: Global formulas for several sheets?

    what do you mean by a "master table"?

  9. #9
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Global formulas for several sheets?

    It's really hard to keep amnswering you when I have no idea what you are working with.

    Hi there.

    A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

    Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation of exactly what your problem is.

  10. #10
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: Global formulas for several sheets?

    Hopfully Link up all related sheets cells.
    Its good practice to attach the file with desired outcomes. [highlighted those cells] type manually.
    how to attach file, see the yellow banner on top of page.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  11. #11
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    Excel 2010 14.04.4760.1000
    Posts
    468

    Re: Global formulas for several sheets?

    well just take any table, one of yours you operate in one sheet. How would you get it to work in another sheet where you keep old data? I just want my main sheet to have limited data, the newest, then the rest gets collected in another sheet.

    maybe you'll ask me if I need to have those formulas. maybe not. I just thought it would be easier if I had to ever work with old data, like old transactions that contain data that might be useful for a duplicate listing(I sell off ebay). So maybe I don't know how excel works and what would be best for me.

    already I'm considering just storing old data/sales in other sheets and keeping columns with formulas together and ones with just data together to make it easy to just move listings around without touching the formulas of my main table. I'm guessing this is the best solution ya think?

+ 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. Can formulas be Global
    By peterbata in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-19-2018, 07:41 PM
  2. Run Time error 1004 method sheets of object global failed
    By bevc in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-27-2016, 04:09 PM
  3. [SOLVED] Global Change to Formulas in Conditional Formatting
    By katkth7533 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-14-2015, 10:58 AM
  4. Exclude Formulas from a Global Replace?
    By jhcoleman53 in forum Excel General
    Replies: 1
    Last Post: 12-23-2014, 12:56 PM
  5. Create sheets based on cells and modify formulas within sheets
    By geoffbern in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-21-2011, 10:12 AM
  6. [SOLVED] how do I do a global replace in all sheets in a workbook?
    By knutknut in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-26-2006, 12:00 PM
  7. [SOLVED] Global criteria update for formulas?
    By Annabelle in forum Excel General
    Replies: 3
    Last Post: 02-03-2006, 07:40 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