Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing Data from the Web
I am working to make a process to automatically update an excel spreadsheet.
The data comes from about 88 different web pages on our intranet. I have already been able to import the data and have it refresh upon opening. My problem comes with the updated data. Each month a new column is added. I only need the most recent 12 months in my file. How do I change the coding so my spreadsheet only extracts the most recent 12 months and replaces the old 12 month's worth of data with the new data? Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Missing Cloumn data when importing external data | Excel Discussion (Misc queries) | |||
Importing:Data Connection Wizard Doesn't see Source Data - No Impo | Excel Discussion (Misc queries) | |||
Removing Data Tables formed from importing data from Access | Excel Discussion (Misc queries) | |||
Importing Data: OLE DB and data link properties dialog | Excel Discussion (Misc queries) | |||
Importing data, then adding data to the new spreadsheet.. a conund | Excel Discussion (Misc queries) |