Johnny, You had the correct answer in your Email but I was so involved with the rest of your Email that I missed your correct answer.
Walter Denver Colorado On Sat, Sep 26, 2009 at 2:57 PM, Johnny Rosenberg <gurus.knu...@gmail.com>wrote: > 2009/9/26 Walter Hildebrandt <wh2...@gmail.com>: > > 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 > > 3. The number in Cell A2 is automatically moved to (copied to) cell B4 > > 4. The number in Cell A3 is automatically moved to (copied to) cell B3 > > 5. The number in Cell A4 is automatically moved to (copied to) cell B2 > > 6. The number in Cell A5 is automatically moved to (copied to) cell B1 > > > > If it is not possible to move the numbers automatically, what is the most > > efficient way to move the numbers? > > Exactly HOW do you ”download” those values? > > If you get the values to the spreadsheet by just copying (Ctrl+c) from > the website and then paste (Ctrl+v) to the spreadsheet, I would write > a macro for automatically pasting the values directly to wherever you > want them. No further copying or moving necessary. > > Otherwise, you could type =A5 into B1, =A4 into B2, then select B1 and > B2 and autofill until B5, I suppose. > > Just for curiosity, exactly WHY do you want to do this? Because it > doesn't make any sense at all to me, but then again, that is maybe > just because I don't know what you are trying to obtain. > > J.R. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.org > For additional commands, e-mail: users-h...@openoffice.org > >