Excel formula

[YS2003]

Can someone tell me the quickest way to set up a formula for the following?

I have an Excel file which containers 2 sheets. One sheet is the net cost and the other is selling rate. I would like to come up with the selling rate on the sheet A by adding certain amount on the net cost on the sheet B. There are so many cells and I cannot really do manually one by one linking a cell in A with a cell B with additional amount.

 

[thegoldenmackid]

Assume we use cells a1 and b1, as opposed to sheets.
in a1 type "=b1 (net cost) + x (additional fee)" (obviously without the parentheses)

then just edit, fill down

 

[YS2003]

V stands for any number.

Sheet A (selling price)
A B C D E F G H ......
1
2
3
4
5
6
.
.
.


Sheet B (net cost)
Sheet B (selling price)
A B C D E F G H ......
1 V V V .......
2 V V V ......
3 V
4 V
5 ...
6 ...
.
.
.

Somewhere on Sheet A or B, I am going to enter a number for the mark up to come up with the selling price for Sheet A.

So far, I am typing (or clicking the cell) this for each cell on Sheet A:
='File Name (SheetB)'!A1+'File Name (SheetB)'!Z100

Z100 is the cell in which I enter the number to come up with the selling price. I am going to add Z100 on the values on Sheet B (net pricing) to come up with the selling price on Sheet A.

This typing and clicking is so tedius as there are so many cells. Is there a way to copy all the relevant cells on Sheet B and copy them over to Sheet A while adding a number (as a mark up accross the board)?