| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| My hyperlink address change? | New Users to Excel | |||
| How do I avoid excel change absolute address to relative address | Excel Discussion (Misc queries) | |||
| multiple Hyperlink address change | Excel Discussion (Misc queries) | |||
| Hyperlink change address | Excel Discussion (Misc queries) | |||
| How can I change a text to a cell's address? | Excel Discussion (Misc queries) | |||
Threaded Mode
