Repeat same formula on new page

[knapp]

Hi all

I wish someone can help me about this

For example, if cell A1 has formula =1+2
How can I repeat the same formula automatically on the most upper left in 2nd page, 3rd page and so on?

Thanks in advance

[royUK]

Group the sheets by using Ctrl & clicking the tabs. Then type the formula into the cell, it will be in evry sheet selected

[knapp]

Thanks for the super fast reply royUK

Sorry I should explain more
My 2nd page is on the same sheet

[Miraun]

You can set header rows in the Page Setup menu. However, if the equation is dynamic based upon the the contents of the given sheet, then I believe it will need to be manual

[knapp]

Thanks

and yes it is dynamic to the content of the sheet
Back to manual i guess
hehe

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[knapp]

Thanks roy
I will use that on my next post

I think I found the solution
Since every end page will have TOTAL VALUE
I will put formula if row above contain TOTAL VALUE, the most upper left will have the equation I want

Thanks a lot guys