Thread: change of cells address
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Darius Darius is offline
external usenet poster
  
Posts: 41
Default change of cells address
I have a data sheet value as:
C:\me2\wa\sourcefile\[st_T_0.xls]T30!$F$23
C:\me2\wa\sourcefile\[st_T_10.xls]T30!$F$33
C:\me2\wa\sourcefile\[st_T_20.xls]T30!$F$43

now I want to get data in same sheet (T30) from F17, G17,H17,I17 in other
words each time "F" cell number minues 6 makes the first required cell
address e.g. F23 - 6 = F17 and then G17 etc.

How do I do that in an easy way?

Reply With QuoteReply With Quote