ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   HOW CAN I COMPILE 2 SHEETS? (https://www.excelbanter.com/new-users-excel/245871-how-can-i-compile-2-sheets.html)

Sweeney *

HOW CAN I COMPILE 2 SHEETS?
 
HOW CAN I COMPILE 2 SHEETS? n tell me what is the formula of subtraction in
it?

how can we repeat the same row in all pages of a sheet (in printing)
without copying & pasting... ?


thanx..........................




Don Guillett

HOW CAN I COMPILE 2 SHEETS?
 
Homework?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sweeney *" <Sweeney wrote in message
...
HOW CAN I COMPILE 2 SHEETS? n tell me what is the formula of subtraction
in
it?

how can we repeat the same row in all pages of a sheet (in printing)
without copying & pasting... ?


thanx..........................





Luke M

HOW CAN I COMPILE 2 SHEETS?
 
Not exactly sure what you mean by "compile" as the word is rather ambiguous.
To subtract in excel, type he formula structu
=A2-B2

To repeat rows:
Under Page Setup, Sheet tab, Print Titles section, you can define
rows/columns to repeat on every page.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Sweeney *" wrote:

HOW CAN I COMPILE 2 SHEETS? n tell me what is the formula of subtraction in
it?

how can we repeat the same row in all pages of a sheet (in printing)
without copying & pasting... ?


thanx..........................





All times are GMT +1. The time now is 07:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com