dynamically link column to row in different sheet

  • Thread starter Thread starter FSRleader
  • Start date Start date
F

FSRleader

Hi all,

I have two worksheets.
In sheet1 I have a row at the bottom that totals up everything in th
individual columns. This row extends from C21 to Q21.

In sheet2 I am trying to take the data from C21 to Q21 in the origina
sheet and transpose it vertically into C55 to C69, all the while makin
sure it is dynamically linked to the data in sheet1.

I know its only 15 cols/rows, but for future reference I want to kno
how to do this effectively. Any help would be appreciated
 
Hi
enter the following formula in C55
=OFFSET('sheet1'!$C$21,0,ROW(1:1)-1)
and copy this formula down to cell C69
 
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

alter code to apply to range (links cells w/ row insertions) 1
Matching column in different sheet 1
Transpose between sheets 4
How to transpose data (Row to column) without losing the cell link 3
dynamic rows: cell value concatenation 1
MACRO PASTE CELL to COLUMN, SKIP ROWS 1
MACRO COLUMNS, SKIP ROWS 6
paste data in different sheet but skip rows. 2

Back
Top