I I am created a table that references the exact values of cells in a different table. I have to drag this formula right 100 cells, so it will be tedious to input these manually.
Example:
New table created in column P & Q, referencing data in a table in columns A through N.
P39: '=D4' Q39: '=I4'
P40: '=D5' Q40: '=I5'
P41: '=D6' Q41: '=I6'
Thanks in advance.
Lots of ways to do this. Here's one...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Thank you so much. It was very helpful with me.
In Column O i used below mentioned formula and it works.
=address(row($d$4),column($d$4)*counta($o$39:o39)+1*4)
Above formula will create range you have to use indirect function to get value.
Regards,
Suhas
On second thoughts... use this, drag across & down as needed
Formula:
=OFFSET($D$4,ROWS($1:1)-1,(COLUMNS($A:A)-1)*5,,)
I assume that the first cell that you want to copy is D4. Is that correct?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks