Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preventing overwrite when importing data from external sources (we
I'm trying to create a database of stock and currency prices which i can go
on to analyse. The problem is that when Excel updates the information (which it sources from a table on a website) it overwrites the old information with the new information. How can I configure Excel to insert the new information after the old information, so that it builds up a historical account of prices, rather than continuously writing the new information over the old? I dont want to be stuck with a "historic" account of prices that cant go back any further than 6 days! Thanks in advance for your help. Josh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing External data from various sources | Excel Discussion (Misc queries) | |||
help on pivot tables using external data sources | Excel Discussion (Misc queries) | |||
Why can't I edit my external data sources? | Links and Linking in Excel | |||
Why can't I edit my external data sources? | Links and Linking in Excel | |||
Why can't I edit my external data sources? | Excel Discussion (Misc queries) |