Hi team, please help me to apply data validation and bring Mapping 4 in BS and IS Sheets separately based on List of Data sheet Mapping 1 Data sheet Mapping 1 Mapping 4 BS Accounts Payable BS Accounts Receivable BS Accrued expenses BS accrued stock IS Advertising Expense BS Amount due to related parties BS Bank 1 BS Bank 2 IS Business Support 1 IS Business Support 2 IS Business Support 3 IS Business Support 4 BS Capital BS Cash In hand IS COGS IS Corporate Tax IS Credit Note IS Depreciation expenses IS Discount 1 BS sheet Accounts Payable Accounts Receivable Accrued expenses accrued stock Amount due to related parties Bank 1 Bank 2 Capital Cash In hand IS sheet Advertising Expense Business Support 1 Business Support 2 Business Support 3 Business Support 4 COGS Corporate Tax Credit Note Depreciation expenses Discount 1

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Data Validation based on BS & IS

Hi team, please help me to apply data validation and bring Mapping 4 in BS and IS Sheets separately based on List of Data sheet Mapping 1

Data sheet

Mapping 1	Mapping 4
BS	Accounts Payable
BS	Accounts Receivable
BS	Accrued expenses
BS	accrued stock
IS	Advertising Expense
BS	Amount due to related parties
BS	Bank 1
BS	Bank 2
IS	Business Support 1
IS	Business Support 2
IS	Business Support 3
IS	Business Support 4
BS	Capital
BS	Cash In hand
IS	COGS
IS	Corporate Tax
IS	Credit Note
IS	Depreciation expenses
IS	Discount 1