Copy a formula across for row references

G

Guest

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??
 
P

PC

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top