Problem copying cell contents

Q

QJ

I have a worksheet called Input which has text in cells A3, A30, A57, A84 etc
which I want to copy to cells B4, B5, B6 etc of a worksheet called Creditors.
I can type =input!A3 into cell B4 of the Creditors worksheet and get the
correct answer but if I try to copy this to B5 I get =input!A4. Please can
anyone tell me how to copy this but increment the cell reference by 27.

Hope this makes sense!

Thanks for your help.
 
R

Roger Govier

Thanks for the feedback. Glad you got it working in spite of the fact I
typed Sheet1 as opposed to your sheet name Index

Regards

Roger Govier
 
Top