VBA - Collating data from other workbooks | Excel forum

Resolved · Low Priority · Version 2007

Tue 17 Jan 2012, 11:35 Delegate Delphine said...

Delphine has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course

VBA - Collating data from other workbooks

Hi all,

I am new to the forum, and I attended recently the intro to VBA course.

I am wondering whether it is possible to have a code that would look accross a set of workbooks at a designated address, to aggregate some data to populate/update a table.

Many thanks in advance.

Best

Delphine

Tue 17 Jan 2012, 16:44 Delegate Delphine said...

RE: VBA - Collating data from other workbooks

I am not sure why my initial question was marked as resolved. Any advice welcome.

Thu 19 Jan 2012, 10:50 Trainer Jacob said...

RE: VBA - Collating data from other workbooks

Hi Delphine

Thanks for your post. The main aim off this forum is too assist with questions that can be answered relatively quickly.

We may be able to assist with your request but as we will need to see your working files it does take things beyond the scope of this forum.

If you would like, please respond to my email with some examples of what you are trying to do and we will have a look. If we find a quick solution we will update you on it, however if more trainer time is required to reach a working solution there may be associated costs, but we will always inform you at every stage.

Kind regards

Jacob

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Validating text entries

1. Select the range of cells.
2. From the Data menu, select Validation.
3. Select the Settings tab.
4. From the Allow dropdown list, select Custom.
5. In the Formula box, enter the following formula: