Referencing Problem

G

Guest

I have two worksheets. In sheet 1 I want to reference the cells in the
following way:

Sheet1!A7=Sheet2!A1

Sheet1!A14=Sheet2!A2

Sheet1!A21=Sheet2!A3

Sheet1!A28=Sheet2!A4

etc.

How can you do this in excel. I tried to copy the pattern down but it will
not do it right. Any help would be appreciated!

Chris
 
D

Debra Dalgleish

In Sheet1 cell A7, enter the formula:

=IF(MOD(ROW(),7)=0,INDIRECT("Sheet2!A"&ROW()/7),"")

and copy down as far as required.
 

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

SUMIF function and cell /sheet reference 3
Sorting and COUNTIF 6
COUNTIF, Sorting, on Two Sheets 1
Transfer entire row to another sheet 4
copy data from sheet2 to sheet1 when sheet2 has variable # of rows 6
Why does "cut and paste" cause #REF! errors? 4
Grouping & Formula 3
paste data in different sheet but skip rows. 2

Top