Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linked Cells
Is it possible to drag the cell with a formula in it so that it can be repeated with a pattern changing? Might sound confusing, what I mean is can i put 'worksheet name'!A2 and then 'worksheet name'!A3 to the right of it and then select both and drag to the right so that the number goes up while the letter stays the same. I've tried using $ to make it absolute but excel just keeps repeating the same two squares without changing the number. -- tpsstudent ------------------------------------------------------------------------ tpsstudent's Profile: http://www.excelforum.com/member.php...o&userid=36256 View this thread: http://www.excelforum.com/showthread...hreadid=560501 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linked cells and text boxes | Excel Discussion (Misc queries) | |||
0 in linked cells when watched | Excel Worksheet Functions | |||
Locking linked cells | Excel Worksheet Functions | |||
Show cells have been read - linked | Excel Discussion (Misc queries) | |||
How to keep linked cells blank until information is entered? | Excel Worksheet Functions |