Excel Question #46

[Kevy Baby]

First and foremost, thank you to GD and Alex for responding - I know I can always count on you to offer assistance on this.

And thank you to Betty for, well... thinking that way!

Originally Posted by Ghoulish Delight

I assume you want a solution that doesn't involve learning VBA?

Yes

However, I found a fairly painless solution to Question 1. I just made several copies of the last tab and did a replace in each tab from "14" (the row on the main tab that all of the data was in that pertained to that output tab) to "15" (or "16", etc.). Since most all of the info in the tabs is cell referencing and text, it was a safe thing to do.

Took about 15 minutes to create all the copy tabs, rename them all (there were 14 new tabs to create) and fix the cell references using search and replace.

Originally Posted by Alex

I'm not sure I understand the first question. Do you mean you want it, when you create a new worksheet that it will automatically know that cell A1 should have a certain formula in it?

Yes, that was the goal. But as noted above, I found an inelegant, albeit quick and painless solution.

Now, how about the second question? That one has me stumped.