Hi steve
Try this to create the formulas with a macro
http://www.rondebruin.nl/summary.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Steve" wrote in message ...
I have a bunch of worksheets, each formatted identically. Let's say their
names are "A" to "Z". I insert a new sheet and I want to examine the same
cell from all sheets. Suppose there is a value representing annual expenses
in cell D13 of each sheet. My new sheet might look something like this:
Sheet Annual Expense
A $100
B $150
C $200
etc.
Is there a way to do this without having to enter the formula separately
into each cell? It seems to me I saw somewhere a way to "build" a formula by
stringing the components together.