Checking formulas accross multiple sheets

R

ricw

Can anyone tell me a fast way to check the accuracy of multiple formulas
accross multiple worksheets? I have a workbook with about 50 to 60
worksheets in it and I need to check all the formulas for accuracy.
Thanks in advance! Rick
 
D

David McRitchie

I have no idea how you would check a formula for accuracy.
Can you provide further insight what you mean. What you
are looking for, and how you would do this manually.
 
D

David French

The best I can think of is to copy and paste the formulas.
Also, if the sheets are all set up the same exact way...A1 has the same
information on all Sheets...then group the sheets and then do the copy and
paste...or better use AutoFill.

Dave French
MS Office XP Master Certified
 

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

Similar Threads

Tracked changes by multiple people modified to one 0
Checking accuracy of multiple formulas 4
Checking Multiple Formulas 1
Accidentally clicked 'Don't Save' on a new Powerpoint presentation! Please help! 0
Embed the same Excel multiple times 0
Checking accuracy of multiple formulas 1
Need Help with Macro Security 1
MROUND Help 1

Top