VBA for Fixed Asset -- 2
Budget: ₹600 – ₹1,500 INR
Calendar file - has the list of states.
Accounts File - filter this file with the list of states in a loop, for each state identify the active facility codes
FA Report - filter the identified facility codes in JE Tab.
Vlookups from Addtions/retirements/transfer tabs to identify which asset was addtion and which was a transfer
We need the separate excel file for each Company (Suppose Company 123, with facility codes as the tabs)
for each tab, separate totals for Additons/transfer/retirement
and do a quick check at the end.
Accounts File - filter this file with the list of states in a loop, for each state identify the active facility codes
FA Report - filter the identified facility codes in JE Tab.
Vlookups from Addtions/retirements/transfer tabs to identify which asset was addtion and which was a transfer
We need the separate excel file for each Company (Suppose Company 123, with facility codes as the tabs)
for each tab, separate totals for Additons/transfer/retirement
and do a quick check at the end.