Hi!

Are you trying to copy this exact same function to all the worksheets in
your workbook? To do that, highlight all the sheets you want to copy it down
to, and copy and paste it back into the original cell on the top sheet.
Excel will put it in all the subsequent sheets.

Be wary of where you use relative and absolute addressing here. :-)

"copying formula of multiple worksheets" wrote:

Heres my formula =IF(B2=0,0,'1'!$P$31) 1 is worksheet 1, I have 310
worksheets and a total sheet, How can I copy this formula down to show
worksheet 2 then 3? thanks alot