Jonny, I have a very large speadsheet that is updated once a week by adding additional information from a website.
In using the spreadsheet I found out that the more standardized the spreadsheet the easier it is to use. It is best if the numbers are in the same order at all different parts of the spreadsheet. For example, to explain what I mean, assume the numbers apply to the days of the week which they do not. At all parts of the spreadsheet Monday should be in cell A1, Tuesday in cell A2, Wednesday in cell A3 etc. It is not desirable to have Wednesday in cell A1 and Monday in cell C1 while the rest of the spreadsheet has the reverse order. An additional factor for me is that in the USA we tend to think in habitual patterns. I find that when skimming a large spreadsheet I always subconsciously think from left to right and from top to bottom. I download the numbers as follows On a website select a group of numbers > Right-click > Copy On the speadsheet click in a cell that will be the upper left cell for the group of numbers. That clicked upon cell will have numbers to its right and also numbers in rows below the clicked upon cell. On Sat, Sep 26, 2009 at 2:57 PM, Johnny Rosenberg <[email protected]>wrote: > 2009/9/26 Walter Hildebrandt <[email protected]>: > > 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: [email protected] > For additional commands, e-mail: [email protected] > >
