Hi there,

I'm not very experienced with Excel and am stuck with a bit of a problem I cant solve.

I'm working in Excel 2003, and have multiple sheets. I'm copying data from one spreadsheet to an other, and displaying and only showing the data if there is any data.

The working formula is as follows:
=IF(COUNTBLANK('MASTER LINELIST'!D12),"", 'MASTER LINELIST'!D12)

So far so good, but the problem is that when rows get inserted in the "master linelist sheet", al the formulas get updated.

I thought I was quite clever buy coming up with a possible solution, and have been stuck ever since.

I'm trying to combine the first formula with this working one:
="D"&ROW()

The idea is that the row number in the final sheet will always be the same as the row number in the master linelist, so if I can change the formula to something like this I would be very happy:
=IF(COUNTBLANK('MASTER LINELIST'!("D"&ROW()),"", 'MASTER LINELIST'!("D"&ROW()))

However I can't work out how to get this to work. Can you guys give me some pointers?