Currently Being ModeratedNov 4, 2013 9:45 AM (in response to hotwheels 22)
The best way is to divide and conquer. Those 18 Sections would be easier to manage if they were 18 Tables. It's easy to pull a table apart into sub-tables.
Currently Being ModeratedNov 5, 2013 8:58 AM (in response to Jerrold Green1)
i will read up on tables. so far the learning curve is preventing me from finishing which is a bit of a hardship.
can you just give me two sentences on how one would do this and/or which pulldowns one does it from?
i am really loath to jump off into the unknown when i am so close to finishing and way past my deadline for this.
that said i would like to find time to read up on it and experiment so my workflow works a lot better than it does now...
Currently Being ModeratedNov 5, 2013 9:05 AM (in response to hotwheels 22)
select the cells in the table drag onto the canvas.
Currently Being ModeratedNov 5, 2013 9:09 AM (in response to Wayne Contello)
so i have just a numbers do opened with two sheets and in one sheet i have 18 sections and everything is all linked and totalled up in a new total section at the bottom.
if i want to start using tables i would run a 'create table' command, cut the total section of the bottom out of the spreadsheet and paste it into the new table is that right?
at that point i would - well i would drag the table onto the new sheet where i want the "equivalent" or linked data is that right?
Currently Being ModeratedNov 5, 2013 9:15 AM (in response to hotwheels 22)
Two sentences on how to split part of a table into a separate table.
1. Select and Copy (Command-C)
2. Click off the table and Paste (Command-V)
Currently Being ModeratedNov 5, 2013 9:18 AM (in response to Jerrold Green1)
i am having a hard time understanding if i have tables and had thought this was a separate operation like inserting a picture into my spreadsheet. if i have not actively inserted a table do i need to do this in order to create the table or are the rows and cells by default a table?
also, will pasting a table into a /new/ sheet indepentent of where it came from let it remained linked and updated when the copied table is changed...?
Currently Being ModeratedNov 5, 2013 9:20 AM (in response to hotwheels 22)
You can Paste a range of cells to a Sheet and a new table will be created. If that range of cells had references outside of the range, you may have to reestablish the references.
Currently Being ModeratedNov 5, 2013 11:16 AM (in response to Jerrold Green1)
hi jerrold. thanks. one more here please.
so if i take a range of cells that is a summary of 800 rows of cells and which TOTALS up these items (so that this range of cells is basically composed of cells with " =CellX " - will the new sheet /retain/ the information or is it going to require me somehow to recreate the 15 hours or work in getting it all /totalled/ on the original sheet...?
regards and thanks
Currently Being ModeratedNov 5, 2013 12:11 PM (in response to hotwheels 22)
Currently Being ModeratedNov 6, 2013 2:12 PM (in response to Jerrold Green1)
still trying to finish this beast over here.
i am finding that this drag operation is actually /moving/ my data and instead i just want to copy it so that it is active. i mean, it is not possible to construct a large spreadsheets so that everything totals out horizontally or vertically and i really need to be able to copy data so that it is LINKED.
is there a way to get your Original Cat 1 value of 10 and your Cat 2 value of 100 "link copied" so that it is pasted into Modified Cat 1 and Cat 2 in a way that lets the modified cells update when the Original data is changed?
i mean, i know i can do this by entering " = " in the destination cells and then clicking in the Original cells but i need to do this with a multiple selection or i will be doing single = equations for a full day trying to move information cell by cell so that it stays linked...
Currently Being ModeratedNov 6, 2013 2:19 PM (in response to hotwheels 22)
We have given you multiple examples. If you do not understand the concept then you should post an example for your situation so we can specifically help you. What you want is possible. The insurmountable task is getting to the specifics for your situation.
Currently Being ModeratedNov 6, 2013 2:18 PM (in response to hotwheels 22)
Please post an example. I just not good enough at this to help you with such a broad problem statement.
Currently Being ModeratedNov 6, 2013 2:22 PM (in response to Wayne Contello)
hi wayne. i will work up an example. thanks.
can i ask that you not ask for a post of mine to be removed without checking with me before removing it? i don't like having posts removed even if you think that it is a redundant post or is repeating a question.
since i am trying to learn the software and since in this case it is not entirely clear that you understand what i am trying to do - deleting a post may have the unhappy consequence of censoring a question that may in fact approach the issue in a slightly different way and which may result in a solution or even an alternative solution.
do you know what i mean? it is uber unpleasant to have a post removed especially when you are trying to find out if there is an alternative solution to a question you are trying hard to get an answer for so you can get something finished for your boss in a way that doesn't result in your losing the job...
Currently Being ModeratedNov 6, 2013 2:27 PM (in response to Jerrold Green1)