Quick Links ▼

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

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

	98.1 % recommend us
	More live stats...

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

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

VBA - Collating data from other workbooks

· Low Priority · Version 2007

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

Delphine has attended:
Excel VBA Intro Intermediate 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

For upcoming training course dates see: Pricing & availability

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

RE: VBA - Collating data from other workbooks

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

Reply Thu 19 Jan 2012, 10:50Trainer 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

Excel articles

· How To Use Slicers In Excel 2010
· Customized Financial Excel Courses in London
· Using The Excel Forms Toolbar To Spruce Up A Workbook
· The Secret Formula To Creating Correct Calculations In Excel
· Discover The Top Ten Changes In Excel 2010

Please browse our web site to find out more about
basic training excel and other Microsoft training courses.

Excel tip:

Reconciling a list to correspond with another

May have a list that needs to make but on another sheet one list seems to be out, eg. product list one sheet contains all product and inventory data, while the other contains pricing data. Both need to match with all products but there is more products in one list than the other. To find the disparaging product compare data in the two columns that need to match Make sure that order the same way.
Create another column in the sheet that has the most items and type in the first cell

=Exact(text1,text2) text1 being the cell that you want compared with text2 cell reference. Drag to filldown and your first false will give you for first cells that does not match. Correct insert the row with data in other sheet and continue the process until all the data returns true. Delete the column inserted.

View all Excel hints and tips