• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 435
  • Last Modified:

Excel VBA - Good VLookup examples to merge data

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
Murray Brown
Asked:
Murray Brown
1 Solution
 
SmittyProCommented:
You might want to look at PowerPivot, which can consolidate the data for you.

HTH,
0
 
FaustulusCommented:
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
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now