Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Internet Downloaded real time info

Resolved · Low Priority · Version 2003

Reply Wed 19 Nov 2008, 16:52Delegate Jose said...

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?

For upcoming training course dates see: Pricing & availability

Reply Mon 24 Nov 2008, 11:18Trainer Simon said...

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

Reply Mon 24 Nov 2008, 21:03Delegate Jose said...

RE: Internet Downloaded real time info

hey thats great keep me posted its appreciated

Thanks

Jose

Reply Tue 25 Nov 2008, 11:07Trainer Simon said...

RE: Internet Downloaded real time info

Hi Jose,

No problem I will hope fully be in touch soon.

Regards

Simon

Reply Wed 18 Feb 2009, 13:36Trainer Simon said...

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 articles

· From the Classroom to the Corporate World
· Employing Cell References in Excel
· Prepare for your MOS Certification with MS Excel Courses
· How To Create A Simple Currency Convertor In Excel 2010
· Basic Excel Training

Please browse our web site to find out more about
course excel training vba london and other Microsoft training courses.

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips