Formulae Ref Different Worksheets

N

Neil Pearce

Dear all,

I have been provided with an Excel spreadsheet by a colleague. The workbook
has several worksheets, one for each risk identified on the project I'm
working on. Additionally there is a summary worksheet that collates all the
information.

I wish to add several new risk worksheets and add additional rows on the
summary tab to collate this extra information. Whilst I can create the new
risk worskheets happily enough my current methodology of creating the
additional summary rows is far from efficient:

Copy row above and change each individual cell's worksheet reference from
"Risk X A1" to "Risk Y A1". As there are several summary columns, 30+ and
many additonal risks I would need to change several hundred cells. There
must be a better way!

Any ideas would be much appreciated.


Thanking-you in advance.

Neil
 
J

Jacob Skaria

Why dont you try Find and Replace

Ctrl+F, Under 'Replace' tab select Look In 'Formulas'

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top