Hi all, In my worksheet I want in B8 the value of sheet cell B1 of worksheet \"o

Question

Hi all,

In my worksheet I want in B8 the value of sheet cell B1 of worksheet "overzicht hele jaar" of workbook "boekcon CdP bank 2014.xlsx" (the source worksheet and sourcs workbook).

In my worksheet I want to drag it 14 cells to the right to get subsequently the values of C1, D1 etc. of the source worksheet.

What is in row 2 , 3, 4 etc. of the source worksheet corresponds with row 13, 18, 23 etc. of my worksheet.

I want to select B8 to and with P8 of my worksheet and put that selection 5 rows lower to get the values of B2 to and with P2 of the source worksheet.

Then again 5 rows lower to get the values of row 3 of the source worksheet etc.

What fomula do I have to put in B8 of my worksheet to accomplish this?

Thanks in advance for your help!!!.

Explanation / Answer

Try this formula:

=IFERROR(INDIRECT("Sheet2!"&CHAR(65+COLUMNS($B$8:B8))&((ROWS(Sheet1!$B$8:B8)+4)/5)+1),"")

Change the name of Sheet2 to the one you have.. Hope it helps!

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.