vba collating data

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

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA - Collating data from other workbooks | Excel forum

VBA - Collating data from other workbooks | Excel forum

resolvedResolved · Low Priority · Version 2007

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

RE: VBA - Collating data from other workbooks

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

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

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

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:

=IsText (A1)

where A1 is the first cell in the range.
6. Click OK.

View all Excel hints and tips


Server loaded in 0.08 secs.