That's a great trick!

Great tip - I shall try this tomorrow.

ETA: I just tested and it works!

That said, if you're going to group every cell each time you want to update it would probably be about as fast to just copy and paste into each cell.

Though I'd completely forgotten about grouping.

I disagree. Since there are 27 tabs, grouping the tabs is much quicker.

Yes, but if you want to highlight each cell you still have to click on it (and make sure you correctly ctrl-click with each so you don't clear the selections you've already made and then find that you had halfway through and your group only applied to the last six you selected).

If you're going to leave the cells grouped permanently then I agree it is a great solution.

If I first click on the last tab, then shift-click on the second tab (the first I would need to modify), make the change in the cell(s) on that tab, it makes the global change pretty quickly.

Global changes are fairly minimal (simply to accommodate the every-changing whims of the boss), so I believe this should be a good solution.

My turn. I'm sure this one is blindingly stupid, but I can't for the life of me come up with the solution.

Cell A1 has a formula that results in a column letter.
Cell A2 has a formula that results in a row number.

I want cell A3 to be the value of the cell that would be referenced by the values of A1 and A2.

So if the formula in A1 results in "C", and the formula in A2 results in "6", I want A3 to be the value of cell C6.

=INDIRECT(A1&A2)

I knew there had to be away to do it in one line. Thanks Moonie.

Okay, I know I am going to smack my forehead when the answer gets posted because I know the answer is painfully simple and I am just clueless on this one.

I want the text in cell A1 to not print if the value in cell A2 is blank. I thought the easiest way to accomplish this was to conditionally format cell A1 with a white font if A2 is = 0. However, what is the stinking formula I would need to enter into the "Formula Is" cell in Condition 1 to accomplish this? I know how to set the formatting once I have a True result.



ETA: I found my own answer. The syntax was what was confusing me. In the cell, I had to enter =(A2=0)