Page wise drag down formula

Hello

I need page wise drag down formula. I have a workbook in sheet1 first page has Invoice No: O3, Date: O4, Name: A13, Assessable Value: I28, Cenvat: L28, ECess: M21, HE Cess: M22, VAT: O28, Total: P28
Whenever create new page all page above details automatically transfer to sheet2 as column wise.

Hoping for a prompt reply...

Bump no response

Hi kishn697

On the summary sheet all you have to do is to enter the name of any new sheet and ensure that the formula is copied from the row above.

Let me know if it works for you.

Regards
Alastair

Hi aydeegee

Thanks for helping me but this was not I want
sheet1 (O4 , O57, O111............) rows transfer to sheet2 whenever I drag it (B3, B4, B5.......)

Hi kishn697

Nice to hear from you.

You need to help me here, as I do not understand what you are asking.

Please explain (and my 3 year old relative thinks I am a little slow on the uptake, so you cannot insult me by explaining too much! ) why you want to " drag it (B3, B4, B5.......) " , and to where you would want to drag it.

As I understand it, you have data on sheet 1. I have shown how it can be put on sheet 2. Now you want to drag it somewhere, and end up with what exactly?

As you can see, my 3 year old is probably right - I am a little slow here!

Regards
Alastair