Jamesrwilliams
New Member
- Joined
- Oct 20, 2005
- Messages
- 21
Hi all,
I have the following formula in A5
=IF(Discussion!$A5<>"",Discussion!A5,0)
Now, problem comes when I copy this down to the next row on my sheet which is A15 the formula changes to (as it shoud)
=IF(Discussion!$A15<>"",Discussion!A15,0)
But it actually needs to be refering to 'Discussion!$A6' not A15 and so on.
Any suggestions on how I can rectify this? I'm sure there's an easy way and I'm just missing it.
Many thanks in advance
James
I have the following formula in A5
=IF(Discussion!$A5<>"",Discussion!A5,0)
Now, problem comes when I copy this down to the next row on my sheet which is A15 the formula changes to (as it shoud)
=IF(Discussion!$A15<>"",Discussion!A15,0)
But it actually needs to be refering to 'Discussion!$A6' not A15 and so on.
Any suggestions on how I can rectify this? I'm sure there's an easy way and I'm just missing it.
Many thanks in advance
James