Problem copying cell contents

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top