Wade, I get what you are saying. I will be download once every week into Cells A1 through A5 and reversing the order in B1 through B5.
The first week the data will be in Cells B1 though B5. I will download new data the second week. That data will end up in Cells B1 through B5 AND the B1 through B5 cells will be directly below the B1 through B5 cells from the 1st week. I will do this for two weeks to learn how to do it on the spreadsheet. Explaining how to do it using A cells and B cells is good for understanding. It is another thing for me to do it on a spreadsheet at various locations On Sat, Sep 26, 2009 at 3:02 PM, Wade Smart <w...@wadesmart.com> wrote: > Walter Hildebrandt wrote: > >> I am using WindowsXP. >> Wade, I do not understand. What do you mean by Site 1, Site 2 etc >> >> Walter >> >> On Sat, Sep 26, 2009 at 2:37 PM, Wade Smart <w...@wadesmart.com> wrote: >> >> 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 >>>> 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? >>>> >>>> >>>> So each time you down load numbers the cells would copy again? >>> Site 1 = A1 - A5. >>> >>> Site 2 = A1 - A5 >>> Site 1 - B1 - B5 >>> >>> Site 3 = A1-A5 >>> Site 2 = B1-B5 >>> Site 1 = C1-C5 >>> >>> and so on. >>> Right? >>> >>> wade >>> >> > Ok. You are getting 5 values from a site. > Those go in A1-A5. > And you want to copy that to B1-B5. > > So Im assuming that you are going to be adding more data from the site as > you go. > > The first time you do it values are in A and then B. > The second time you do it the values move from B to C, and A to B. > > Get it? > > > wade > > -- > Registered Linux User: #480675 > Registered Linux Machine: #408606 > Linux since June 2005 > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.org > For additional commands, e-mail: users-h...@openoffice.org > >
