excel vba - Imports

The UK's most regular instructor-led training courses.
Training information: excel vba · Advanced.excel · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Imports

Philippe has attended:
Excel Advanced course

by - delegate Philippe [2 posts] (2007 Aug 10 Fri, 16:11) Reply

How do you arrange data that you import from bloomberg or reuters?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	4	book now	£207	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Imports

by - trainer Richard platinum contributer [813 posts] (2007 Aug 13 Mon, 11:52) Reply

Hi Phillippe

I guess that would depend on what you wanted to use the data for, or how you wanted it to be arranged.

You might consider using Sort, AutoFilter or perhaps a function or two.

Regards

Richard

RE: Imports

by - delegate Philippe [2 posts] (2007 Aug 15 Wed, 16:35) Reply

Hi Richard,

Thanks for your answer. I wanted to ask you a quesiton regarding a database that I'm building. The database contains refinery turnaround information. Now I would like to use a pivot table for that database, but the problem is that my column labels are horizontal and my daily dates(going down for a yea and half) are posted vertically. I tried changing the column labes the other way around but was not able to do that since posting the dates horizontally will only give till about september? Now on this database i have columns with the refinery names, country, duration of the shutdown etc... I would like to be able to use a pivot table on this information.
Thanks and looking forward to hear from you.
Best regards,

Philippe

RE: Imports

by - trainer Richard platinum contributer [813 posts] (2007 Aug 29 Wed, 16:23) Reply

This may be a limitation on Excel Pivot charts. What version of Access are you using? There are Pivot tables in Access from version 2002/xp onwards.

Regards

Richard

· Prepare for your MOS Certification with MS Excel Courses
· Tips to Facilitate Printing of Excel worksheets
· Microsoft Excel Training - Discover A Hidden Power At Your Fingertips
· How to check for and reduce errors in Microsoft Excel
· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks

Excel tip:

Random Numbers

Type =RAND()*200 to generate a number between 1 and 200.
Use the fill handle to drag down and populate as many cells as you'd like with random numbers.

View all Excel hints and tips