And to save time in doing this you can group Sheets 2 to 32 together
so that you only have to enter the linking formula in one of the
sheets and it will appear in all the other sheets. Something like:

=Sheet1!B5

Remember to ungroup the sheets afterwards. Then you just enter the
number into Sheet1 cell B5.

Hope this helps.

Pete

On Dec 14, 1:15 am, TRYING wrote:
While I'm waiting for your reply to David's latest post (don't know if one is
forthcoming), I'm pursuing my original idea. If you just need to copy that
one formula from one worksheet (I'll call this Sheet 1) to 32 other
worksheets (I'll call them Sheets 2 to 33), simply linking the relevant cell
within Sheets 2 to 33 to the cell in Sheet 1 could do the trick. This means
taking the time up front to establish the links in Sheets 2 to 33, but after
you do that, you then just manually input into Sheet 1 and, voila, Sheets 2
to 33 would be updated automatically. The basic idea is if one cell needs to
have the same content as another, one good approach is to input into the
first and link the second to it.

Hope I'm not confusing you. This helps me personally to think of the process.



"jeannie v" wrote:
Thank you for your thoughts...my problem is that once I can ge this thing to
auto-change the number, I can create the macro to copy that formula to 32
additional worksheets automatically. Maybe I'm looking at this as less easy
than it should be..do you think?

Thanks for any thoughts,
--
jeannie v

"TRYING" wrote:

I'm just reading this thread with interest. Realizing that I know nothing
except what you have written, I would reiterate one part of CLR's post but
state it in the form of a question: would you be better off with manual entry?

If you have to open the worksheet each day that applies, what could be
simpler than typing, say in cell B33 or another cell that is convenient, that
variable number that you want--5 or 6 or 10 or 16--since you would presumably
already have the formula =B34*B33 in some cell.

I also recognize the saying "different folks, different strokes" might
apply. It might be worth your while to explore ways to automate this. For
some people, the challenge and the process are important. Sometimes though,
the benefit might not be worth the effort.

"jeannie v" wrote:

Thank you CLR.......... for the info....If i want to build the macro for a
firm date, could you tell me how I can do that?

Thank you,
--
jeannie v

"CLR" wrote:

Understand that the "TODAY" formula is volitile. True if you use it,
tomorrow when you open the file it will be 1 more, but next week if you go
back and open the old file it will be 7 more (ie: it will be for THAT
day)............if you are saving the files each day, you would be better off
with manual entry or a macro to set a firm date.

Vaya con Dios,
Chuck, CABGx3

"jeannie v" wrote:

Greeting Experts:

I have a formula that changes by 1 each day...Example: = B34*5.....on the
next day it would be =B34*6 and so on....How can I do this without manual
entry?

Thank you for your help,
--
jeannie v- Hide quoted text -

- Show quoted text -