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?
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?
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
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?
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.
what do you mean by a "master table"?
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.
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".
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks