Pls Help me Urgently (About Excel)

[shahleopak]

All Members of It Dunya,
Members mjhe ye janna ha k Excel me me ne worksheet bnaye ha last me Total kia ha me chata ho k jo total ha wo copy kr k 2sri jga Paste kr do bt jb me copy krta ho to formula b copy ho jata ha me chata ho number copy ho bs formula nhi pls any member help me urgntly
we8ng.............

[Saqib Lodhi]

Fisrt copy, Then right click on second sheet and select pasting option....

[shahleopak]

Thnx bro bt me jb copy krta ho or jo method btaya ap ne us se paste krta ho to format paste nhi hota jst value paste hoti ha me yhi chata ho k Format b paste ho Total ka

[Saqib Lodhi]

Thnx bro bt me jb copy krta ho or jo method btaya ap ne us se paste krta ho to format paste nhi hota jst value paste hoti ha me yhi chata ho k Format b paste ho Total ka

I am using Office2010. May be this option is available in previous versions. see attached images.

[shahleopak]

Thnx

[*Abdul-Basit*]

Thnx