Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help! Equally spaced cell reference
Can anyone help with the following please: On one work sheet I have data equally spaced vertically, ie cell 1 is A, cell 11 is B, cell 21 is C etc... On another worksheet I want to make a list of A,B,C... ie 1 maps to 1, 2 maps to 11, 3 maps to 21 and so on. Is there a way I can automate/autofill this. This is a simplicfication of the problem but I can't find a way to do it. Any idead? Cheers Geoff -- geoff1234 ------------------------------------------------------------------------ geoff1234's Profile: http://www.excelforum.com/member.php...o&userid=36051 View this thread: http://www.excelforum.com/showthread...hreadid=558410 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
cell reference changes and conditional formatting | Excel Worksheet Functions | |||
How do I anchor a cell reference? | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
how to create a variable column in cell reference | Excel Worksheet Functions |