Posted on 10/1/09.
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
Mention this post on Twitter!
Submit this post to Digg.
Check out the free MacMost weekly email newsletter.
Become a fan of MacMost on Facebook.
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.