Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba - Imports

	98.1 % recommend us
	More live stats...

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

Training information:

excel vba - Imports

Resolved · Low Priority · Version Standard

Reply Fri 10 Aug 2007, 16:11Delegate Philippe said...

Philippe has attended:
Excel Advanced course

Imports

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

For upcoming training course dates see: Pricing & availability

Reply Mon 13 Aug 2007, 11:52Trainer Richard said...

RE: Imports

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

Reply Wed 15 Aug 2007, 16:35Delegate Philippe said...

RE: Imports

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

Reply Wed 29 Aug 2007, 16:23Trainer Richard said...

RE: Imports

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

Excel articles

· Sorting Birthdates Into Their Respective Months In Excel
· Microsoft Excel Courses Teach Advanced Macro Techniques
· Microsoft Office and the Small Business: Part 1 Excel
· Understanding XML Within Excel
· Replacing Cell Formats In An Entire Excel Workbook

Excel tip:

Quickly copy a formula across sheets

Suppose you have a formula in cell Sheet1!B2, say =A1*5%, that you wish to copy to cell B2 on Sheet2, Sheet3 and Sheet4. Instead of using copy and paste, try this: (1) Select Sheet1!B2. (2) Group Sheet1 with the worksheets Sheet2, Sheet3 and Sheet4 by holding down Ctrl and clicking on the tabs of the sheets to group them. (3) Press the F2 key, then immediately press Enter to copy the formula in Sheet1!B2 across the grouped sheets.

Remember to ungroup the sheets afterwards! Right-click on any tab and choose Ungroup Sheets to do that.

View all Excel hints and tips