At 14:32 26/09/2009 -0600, Walter Hildebrandt wrote:
Is it possible to do the following?
1. Cells A1, A2, A3, A4, and A5 get numbers that are downloaded from
a website.
2. The number in Cell A1 is automatically moved to (copied to) cell B5
In B5, put =A1.
3. The number in Cell A2 is automatically moved to (copied to) cell B4
In B4, put =A2.
4. The number in Cell A3 is automatically moved to (copied to) cell B3
In B3, put =A3.
5. The number in Cell A4 is automatically moved to (copied to) cell B2
In B2, put =A4.
6. The number in Cell A5 is automatically moved to (copied to) cell B1
In B1, put =A5.
You could have made the problem simpler by asking how to put in B1:B5
the values in A1:A5 but in reverse order. To do this, you could put
=INDIRECT("A"&6-ROW())
into B1 and then copy or fill it into all the cells up to B5.
How does this work? ROW() returns the row number of the current
(destination) cell. 6-ROW() calculates the row number of the
required source cell. This is concatenated (using the & operator)
with the letter A to create the name of the required source
cell. But this is in the form of a text string instead of a cell
reference; all we then need is the INDIRECT() function to do the conversion.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
