View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sigmanut Sigmanut is offline
external usenet poster
 
Posts: 2
Default dynamic range question

'
' Given a spreadsheet like this:
' A B C
'15 U 10 10
'16 U 7 12
'17 U 4 14
'
'In a new sheet or at least above row 12, insert the contents of column C
into the cell addressed by cells A & B.
'So the contents of U:10 is 10, U:7 is 12 and U:4 is 14.
'-----------------------------------------------------
I cannot remember how to do this and I cannot remember what this kind of
process is called when the range values come from the data.
Thanks..........