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
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]Expense Account #
Column A, Row1[/TD]
[TD]Expense Descrip.
Column B, Row1[/TD]
[TD]Vlookup to Mapping Tool
Column C, Row1[/TD]
[/TR]
[TR]
[TD]50060[/TD]
[TD]Accrued Accounts Payable[/TD]
[TD]Accrued Media Payable[/TD]
[/TR]
[TR]
[TD]50065[/TD]
[TD]Accrued Media Payable[/TD]
[TD]Accrued Media Payable[/TD]
[/TR]
[TR]
[TD]70071[/TD]
[TD]Cash In Transit[/TD]
[TD]Cash In Transit[/TD]
[/TR]
[TR]
[TD]80011[/TD]
[TD]Cash in Bank[/TD]
[TD]N/A[/TD]
[/TR]
</tbody>[/TABLE]
Tab: MappingTool
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]Expense Account #
Column A, Row1[/TD]
[TD]Expense Descrip.
Column B, Row 1[/TD]
[TD]Category
Column C, Row1[/TD]
[/TR]
[TR]
[TD]50060[/TD]
[TD]Accrued Accounts Payable[/TD]
[TD]Accounts Payable[/TD]
[/TR]
[TR]
[TD]50065[/TD]
[TD]Accrued Media Payable[/TD]
[TD]Accounts Payable[/TD]
[/TR]
[TR]
[TD]70071[/TD]
[TD]Cash in Transit[/TD]
[TD]Cash[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Note: Category will be a manual update.
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
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]Expense Account #
Column A, Row1[/TD]
[TD]Expense Descrip.
Column B, Row1[/TD]
[TD]Vlookup to Mapping Tool
Column C, Row1[/TD]
[/TR]
[TR]
[TD]50060[/TD]
[TD]Accrued Accounts Payable[/TD]
[TD]Accrued Media Payable[/TD]
[/TR]
[TR]
[TD]50065[/TD]
[TD]Accrued Media Payable[/TD]
[TD]Accrued Media Payable[/TD]
[/TR]
[TR]
[TD]70071[/TD]
[TD]Cash In Transit[/TD]
[TD]Cash In Transit[/TD]
[/TR]
[TR]
[TD]80011[/TD]
[TD]Cash in Bank[/TD]
[TD]N/A[/TD]
[/TR]
</tbody>[/TABLE]
Tab: MappingTool
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]Expense Account #
Column A, Row1[/TD]
[TD]Expense Descrip.
Column B, Row 1[/TD]
[TD]Category
Column C, Row1[/TD]
[/TR]
[TR]
[TD]50060[/TD]
[TD]Accrued Accounts Payable[/TD]
[TD]Accounts Payable[/TD]
[/TR]
[TR]
[TD]50065[/TD]
[TD]Accrued Media Payable[/TD]
[TD]Accounts Payable[/TD]
[/TR]
[TR]
[TD]70071[/TD]
[TD]Cash in Transit[/TD]
[TD]Cash[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Note: Category will be a manual update.
Last edited:
