Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell References
Hi everyone, I'm curious to know if there's a way to add strictly to the number portion of a cell reference. For example, Sheet 1 cell A1 is linked to Sheet 2 cell H1. A2 is linked to H4, A3 to H5, etc. So, essentially, I want to know if it's possible to fill in sheet 1 col A with a formula like H(i + 2) instead of manually linking cells. Thanks. -- Isaac Maycotte -- I Maycotte ------------------------------------------------------------------------ I Maycotte's Profile: http://www.excelforum.com/member.php...o&userid=35604 View this thread: http://www.excelforum.com/showthread...hreadid=562585 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Furmula Dependent Cell References | Excel Discussion (Misc queries) | |||
Automatically Changing Cell Reference's when Pasting in Excel | Excel Discussion (Misc queries) | |||
Cell references change when entering new data | New Users to Excel | |||
Absolute cell references and subsequent problems. | Excel Discussion (Misc queries) |