Here's what should be a simple formula that is giving me grief and costing me
time.
I have a bunch of formulas that reference cells on other worksheets.
What I'm did was I set up this workpaper workbook that will ultimately piece
together an import .dif file for some tax software.
The sheet that will become the .dif file is linked to a bunch of tables
throughout the workbook. Buty the tables on the .dif sheet are transposed
(rows are now columns and so on..) because of the way the import template is
setup.
I would just set up simple links - however if the source cell is null i want
it to return "" nothing instead of "0" so I wrote the following formula:

=IF('B-1'!B11="","",'B-1'!B11)

Herein lyes my dilema. I would like to copy this formula across and only
have the "11" in the B11s to increase. I've tried numerous combinations of F4
with $B$11, $B11 and so on and when I copy across it does not change. If I
don't use F4 on the cell refernce then it increases like C11, D11...

Any advise?? Please??

Replace the reference to 'B-1'!B11 with

OFFSET('B-1'!$B$10,COLUMN(A1),0)

This will copy increment the rows as you copy across.

"TimT" wrote in message
...
Here's what should be a simple formula that is giving me grief and costing
me
time.
I have a bunch of formulas that reference cells on other worksheets.
What I'm did was I set up this workpaper workbook that will ultimately
piece
together an import .dif file for some tax software.
The sheet that will become the .dif file is linked to a bunch of tables
throughout the workbook. Buty the tables on the .dif sheet are transposed
(rows are now columns and so on..) because of the way the import template
is
setup.
I would just set up simple links - however if the source cell is null i
want
it to return "" nothing instead of "0" so I wrote the following formula:

=IF('B-1'!B11="","",'B-1'!B11)

Herein lyes my dilema. I would like to copy this formula across and only
have the "11" in the B11s to increase. I've tried numerous combinations of
F4
with $B$11, $B11 and so on and when I copy across it does not change. If I
don't use F4 on the cell refernce then it increases like C11, D11...

Any advise?? Please??

You da man! ..or woman, I don't know, I can't tell by "PC" but thank you so
much!

"PC" wrote:

Replace the reference to 'B-1'!B11 with

OFFSET('B-1'!$B$10,COLUMN(A1),0)

This will copy increment the rows as you copy across.

"TimT" wrote in message
...
Here's what should be a simple formula that is giving me grief and costing
me
time.
I have a bunch of formulas that reference cells on other worksheets.
What I'm did was I set up this workpaper workbook that will ultimately
piece
together an import .dif file for some tax software.
The sheet that will become the .dif file is linked to a bunch of tables
throughout the workbook. Buty the tables on the .dif sheet are transposed
(rows are now columns and so on..) because of the way the import template
is
setup.
I would just set up simple links - however if the source cell is null i
want
it to return "" nothing instead of "0" so I wrote the following formula:

=IF('B-1'!B11="","",'B-1'!B11)

Herein lyes my dilema. I would like to copy this formula across and only
have the "11" in the B11s to increase. I've tried numerous combinations of
F4
with $B$11, $B11 and so on and when I copy across it does not change. If I
don't use F4 on the cell refernce then it increases like C11, D11...

Any advise?? Please??