| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to code this
I have line number 130 stored in cell A1. In A2, I want it to load the
contents of C130. If I change A1 to say 140, the contents of C140 should appear in A2. Not sure how to code this. TIA |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to code this
On Sat, 13 Jun 2009 06:49:09 -0700 (PDT), Fan924
wrote: I have line number 130 stored in cell A1. In A2, I want it to load the contents of C130. If I change A1 to say 140, the contents of C140 should appear in A2. Not sure how to code this. TIA Try this formula in cell A2: =OFFSET(C1,A1-1,0) Hope this helps / Lars-Åke |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to code this
On Sat, 13 Jun 2009 06:49:09 -0700 (PDT), Fan924
wrote: I have line number 130 stored in cell A1. In A2, I want it to load the contents of C130. If I change A1 to say 140, the contents of C140 should appear in A2. Not sure how to code this. TIA Here is another one you can try in cell A2: =INDIRECT("C"&A1) Hope this helps / Lars-Åke |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to code this
Thanks Lars,
Similar to what I have used in macros. I just drew a blank. I was able to change it to pull data from another sheet. =INDIRECT("SHEET1!C" & A1) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
| Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
| Convert a Number Code to a Text Code | Excel Discussion (Misc queries) | |||
| Unprotect Code Module in Code | Excel Discussion (Misc queries) | |||
| copying vba code to a standard code module | Excel Discussion (Misc queries) | |||
Linear Mode
