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:

Forum statistics

Threads
1,082,630
Messages
5,366,656
Members
400,909
Latest member
ola97316

Some videos you may like

This Week's Hot Topics

Top