Brian, it works great. It is so obvious and I never though of doing it that way. I have been doing a lot of putting the equal sign (=) plus a cell into a cell. I have been using the dollar sign ($), or not having a $ in the cell address, so I am very experience with cell address. This may be because what I wrote Jonny in regards unconscious thinking habits (Think outside the box)
Walter Denver Colorado On Sat, Sep 26, 2009 at 3:15 PM, Brian Barker <[email protected]>wrote: > 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] > >
