internet downloaded real time

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Internet Downloaded real time info

Internet Downloaded real time info

resolvedResolved · 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.


 

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?

The auto fill feature saves you time by allowing you to enter one of the list entries into a cell and then use your mouse to automatically drag the rest of the list into the cells below, above or to either side of the initial cell. When using your mouse to perform this task you will see a thin black cross appear at the bottom right hand side of the cell. Click, hold and drag to make the list appear.

Default lists include weekdays and months. To create your own list in Excel 2010 do the following;

>File
>Options
>Advanced
>Scroll right to the bottom of the page and you will see a buttom "edit custom lists", click this button
>enter your list in the list entries
>click add

Now try it out. Good luck.
>

View all Excel hints and tips


Server loaded in 0.1 secs.