Automatically Append Excel Data to another Dataset

Vasweetheart05

New Member
Joined
Nov 5, 2016
Messages
27
I'm trying to automatically append any new data from one excel tab (ReportExport) to another tab (MappingTool) if the vlookup on the MappingTool tab is equal to N/A.

Example: A new ReportExport is run everyday. The Report Export is linked to the Mapping Tool tab using a VLooup to confirm the Expense Description is listed on the Mapping Tool tab. If the Expense Descr. is missing, then an error (N/A) value is returned. For all descriptions with an error message, I'd like the Expense Account # and Expense description to be appended to the bottom of the MappingTool tab (row 5 using the example below). I want this to continue to occur for any new expenses added to the ReportExport and continuously append to the last (blank) rows on the Mapping Tool tab.

Tab: ReportExport
Expense Account #
Column A, Row1
Expense Descrip.
Column B, Row1
Vlookup to Mapping Tool
Column C, Row1
50060Accrued Accounts PayableAccrued Media Payable
50065Accrued Media PayableAccrued Media Payable
70071Cash In TransitCash In Transit
80011Cash in BankN/A

<tbody>
</tbody>


Tab: MappingTool
Expense Account #
Column A, Row1
Expense Descrip.
Column B, Row 1
Category
Column C, Row1
50060Accrued Accounts PayableAccounts Payable
50065Accrued Media PayableAccounts Payable
70071Cash in TransitCash

<tbody>
</tbody>


Note: Category will be a manual update.
 
Last edited:

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Forum statistics

Threads
1,213,550
Messages
6,114,265
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top