Hello!

I'm new here, but I'd immediately like to take advantage of you
superior knowledge of all things Excel ;-) I'm currently doing researc
for school, which has culminated in a model. This model is a workbook
containing some 10 worksheets. Now I have entered varios scenarios i
the model, and saved all the iterations.

This means that I have some 120 workbooks with the same structure.

Every workbook has a certain value (an efficiency) denoted in a cel
(for each workbook, this value is identical, as well as in the 'same
cell). This value is 70%. Now it occurs to me that this should b
60%.

Ofcourse I could simply open the all the workbooks (the 120 version o
the model...) and change the value of cell C5 on worksheet X from 70 t
60 one hundred and twenty times over, but I was wondering if there i
an easier way to go about this, with macros for example (especiall
since I probably need to overwrite some other values as well, late
on).

In short: is there an easy way to have Excel overwrite a constant in
given cell with a new, constant value for, say, every workbook in
folder (thus changing cell C5, which now has 70% in it, to, say, 60
for every workbook in that folder)?


Thanks for your time! Forums like these are what make the interne
great.

Bram Verhees

P.S. I apologise if not all the terminology is correct. Being Dutch
I'm using a Dutch version of Excel, so I had to wing it here and there

--
BR4
-----------------------------------------------------------------------
BR4M's Profile: http://www.excelforum.com/member.php...fo&userid=1682
View this thread: http://www.excelforum.com/showthread.php?threadid=32016