Hello everyone!
I was hoping someone had a solution on how to edit multiple tables at once, if all of the tables are created identical (ex. Jan – Dec). With excel, all you have to do is select the group of tabs that you wanted to edit, and just edit the one tab you’re currently on & that would automatically edit all of the other tabs the same way. I tried highlighting all of the tables, but when I try to edit a cell it unselects the other tables?? Thank you for any advice in advance!
– Jason
Subscribe at iTunes to the MacMost video podcast
Check out the free MacMost weekly email newsletter
Become a fan of MacMost on Facebook
Get Updates, News and Tips on Twitter
Get the Free MacMost App for the iPhone and iPod Touch
If you have two tables you can put a formula in a cell of table 2 that uses cells from table 1. So cell A1 in table 1 can be “27″ and cell A1 of table 2 can be “=Table 1 :: B19″. Then when you edit A1 in the first table, it updates the second table automatically. You don’t have to type “=Table 1 :: B19″ either. Just click on A1 in table 2 and type = and then click on A1 in table 1 and it enters the “Table 1 :: B19″ part for you.
Thank you Gary for the response. The issue w/ this solution in this example is that the data in table 2 will not always be the same as table 1. Table 2 will have it’s own data, and in the case that I need to change the same cell (or cells) in all of the tables, this is where I run in to the problem of just changing those specific cells globally in the whole sheet. Thank you again though for the response.
I guess I don’t understand your situation, then. I’m sure there is a solution that will work, though. Perhaps have a spreadsheet expert take a look over your shoulder.
I have 12 sheets (one for each month) each containing a table representing a monthly cashbook with different column widths. Each monthly table layout is the same as the others. Question: if I change the width of a column in a table in the first sheet, can all tables be grouped so that all tables show the same new column width? So far, I have to go through each table and adjust the column widths one at a time. I hope there is a way to change them all at once. Any suggestions? Thanks.
I dont believe there is any way to link the column widths like that.
Thanks Gary. I think you are right. It can be done on Excel (that is, grouping a number of sheets, so that a change in one will cause all of the sheets to show the change). I contacted the Apple “Geniuses” who solve your problems for a fee of $60, on the basis of “If you are not happy, you do not pay”, and after four days and a dozen emails, they could not help. I will have to do the changes to each sheet one at a time.