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.
 
Hi

Try
=INDIRECT("Sheet1!A"&(ROW()-4)*27+3)

Regards

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
 
You must log in or register to reply here.

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

Similar Threads

Very strange behaviour of VLOOKUP in Excel 2010 4
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
copying formula with worksheet name-need new formula to have anotherworksheet name 1
Relative and Absolute Reference to Cells in a Formula 2
Auto Input Today's Date 3
Basic Fill Handle 3
Skip Reference Sequences during copy 3
Copy a worksheet to a new workbook 6

Back
Top