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.
5 freelancere byder i gennemsnit ₹1460 timen for dette job
I have 7 yrs experience in VBA automation and web scrapping using VBA and C#.net. I am working as a VBA developer in private org. I will provide you the quality output.