Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell locations
Hi All....
I would like to enter a cell's location (say A1) and then based on that data creat a way to pull info from a cell 1, 2, 3... etc. cells to the right. Example target cell is A1 and I want value from A2 without just entering =A2. Reason for this is I need the value from 150 different cell but only 30 at a time. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell locations
What info would be in A1 and how would that relate to cells A1, A2, ... (i.e.
what in cell A1 indicates columns 1 or 2 or 3 or ...? "DL9998" wrote: Hi All.... I would like to enter a cell's location (say A1) and then based on that data creat a way to pull info from a cell 1, 2, 3... etc. cells to the right. Example target cell is A1 and I want value from A2 without just entering =A2. Reason for this is I need the value from 150 different cell but only 30 at a time. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell locations
In that cell I would like to place another cell location, for example in A1 I
would type "D4". Then from there I could ask excel to look 2 column left and 3 rows down or any location on the spreadsheet. "Flick Olmsford" wrote: What info would be in A1 and how would that relate to cells A1, A2, ... (i.e. what in cell A1 indicates columns 1 or 2 or 3 or ...? "DL9998" wrote: Hi All.... I would like to enter a cell's location (say A1) and then based on that data creat a way to pull info from a cell 1, 2, 3... etc. cells to the right. Example target cell is A1 and I want value from A2 without just entering =A2. Reason for this is I need the value from 150 different cell but only 30 at a time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manipulating a column array into different cell locations | Excel Discussion (Misc queries) | |||
AutoFill pattern based on cell locations | Excel Discussion (Misc queries) | |||
Changing cell locations with formula? | Excel Discussion (Misc queries) | |||
Can CELL Return Multiple Data Locations? | Excel Worksheet Functions | |||
InputBox to select cell locations | Excel Worksheet Functions |