Hi,
Need yor help.
I have two sheets
1. Tracker
2. Data
I have to update my GL Balance(CAD) "H Col0umn" in Tracker Sheet, for that I will take my total sum from Sum Transaction Amt from "F Coloumn" sheet2 "DATA".
My condition is
If Bus Unit,Account,Department,Affiliate,Product in Tracker Sheet are matching with my Data sheet then I will copy the Total Sum from "Sum Transaction Amt"(F Coloumn) and
Paste it to GL Balance(CAD) "H Col0umn" in Tracker Sheet.
I have to update Tracker sheet from serial 1 to 44 on a daily basis.
I would appreciate if you could help me for the same. Please find the step and the attachment for reference.
Thanks & Regards
Santosh