98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Internet Downloaded real time info
Internet Downloaded real time info
Resolved · Low Priority · Version 2003
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
Wed 25 Feb 2009: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Create your own custom list on Excel 2010!If you know how to use the auto-fill option on Excel then why not create your own customs lists? |