excel training uk - arrays creating virtual tables

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training uk - Array's or creating virtual tables and populating | Excel forum

excel training uk - Array's or creating virtual tables and populating | Excel forum

resolvedResolved · Low Priority · Version Standard

Sunil has attended:
Excel VBA Intro Intermediate course

Array's or creating virtual tables and populating

I want to know how I can create table within my VBA code to do manipulation on the original data and then populate my array with the results.

RE: Array's or creating virtual tables and populating

Hi Sunil,

Thankyou for your question

Could you please just confirm that you want to do the following, in the following order

Create a new worksheet
Populate this with data from another worksheet
Manipulate the data in the new worksheet
and then copy the results to an array

Regards

Stephen

RE: Array's or creating virtual tables and populating

Hi Stephen,

Just to give you some background on my current role...I work as a Business Intelligence Developer, using Business Objects (BO). Sometimes when some of the core functionality falls short of the user's requirement we may need to use VBA to output the desired results, apply filters etc. The way the (BO) works is that we form a connection via ODBC to our source database and using SQL we return a data set. Sometime as explained already we need to use VBA. The course tutor advised me that the best way would be to use arrays. I don't know if this is the best way? But what I was looking to achieve was a way in which one would create a virtual table, populate it with data from you source data. Do some manipulation, comparisons etc. Assign the values to a display vars and display these on the final report. Your colleague also mentioned that a course in VBA for Access would possibly be a more appropriate course for what I need in as far as VBA goes.

In answer to your questions...I suppose in the context of Excel and conceptually your right, therefore I would be grateful for your help and would love to see how you would all the above in any case.

Many Thanks,
Sunil.


 

Excel tip:

Closing Multiple Open Worksheets At Once

When multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option.

Close All menu option is only displayed when Shift key is down

View all Excel hints and tips


Server loaded in 0.09 secs.