Jose has attended:
Excel Advanced course
Internet Downloaded real time info
How can i manipulate data downloaded from internet into excel to provide pivot tables?
RE: Internet Downloaded real time info
Hi Jose,
Thank you for your question.
Jose this question is going to require a little more investigation.
I have tried to record a macro that resorts the data into labelled columns and then everytime the external data is refreshed, use the macro to rearrange it. Then tried to update the Pivot data but it doesn't seem to work 100%.
Will keep looking and email you with any more suggestions.
Regards
Simon
RE: Internet Downloaded real time info
hey thats great keep me posted its appreciated
Thanks
Jose
RE: Internet Downloaded real time info
Hi Jose,
No problem I will hope fully be in touch soon.
Regards
Simon
RE: Internet Downloaded real time info
Hi Jose,
I could not find a suitable solution to your request without any from of VBA.
Here are a few ideas you could try:
Record a macro that records the following instructions:
1. Import the data from the web.
2. Resort the data so that you have column headings and any blank lines are removed and any other unwanted data.
3. Create the Pivot Table based on the data.
4. Then stop recording.
5. then use your macro button everytime you want to import the same web data, resort it and then pivot it.
6. then run your macro each time you want to update the web data.
I hope this works.
Regards
Simon
