<div>
You might want to look at PowerPivot, which can consolidate the data for you.<br />
<br />
HTH,
</div>


You might want to look at PowerPivot, which can consolidate the data for you.

HTH,

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
<br />
I have a situation where six different sets of data are being dumped into spreadsheets<br />
from SAP. These are then being pulled into one final spreadsheet using VLookups.<br />
I am looking for a few good examples Excel VBA code being used to automate this sort of process
</div>
</div>


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

Excel VBA - Good VLookup examples to merge data

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.