| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change of cells address
"JLatham" wrote: Since OFFSET failed so miserably (my apology for sending you down that dead end), you may be just as easy off setting up the new formulas manually. You could simply copy one that's set up properly and paste it where you need and change the column and row number references. But if your need for F17, G17, H17 and I17 are all on the same row, you could enter the first formula as C:\me2\wa\sourcefile\[st_T_0.xls]!F$17 and copy across the row, the F would change to G, H and I automatically. Same for the other workbooks. I'll continue to think about it and maybe someone else will fall in here with a better solution. "Darius" wrote: 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 |
| 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) | |||
Hybrid Mode
