Solved

Excel VBA - Good VLookup examples to merge data

Posted on 2013-11-19
3
389 Views
Last Modified: 2013-11-20
Hi


I have a situation where six different sets of data are being dumped into spreadsheets
from SAP. These are then being pulled into one final spreadsheet using VLookups.
I am looking for a few good examples Excel VBA code being used to automate this sort of process
0
Comment
Question by:murbro
3 Comments
 
LVL 4

Expert Comment

by:SmittyPro
ID: 39661015
You might want to look at PowerPivot, which can consolidate the data for you.

HTH,
0
 
LVL 14

Accepted Solution

by:
Faustulus earned 500 total points
ID: 39661097
Normally, tasks such as you describe will be executed by custom made code. Post your exact requirements and ask someone to encode it for you.
Speaking more generally, as you do, you may like to look at Excel's own Consolidate function which can combine data from several worksheets into one.
0
 

Author Closing Comment

by:murbro
ID: 39661807
Thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now