Dear Experts,
This is my first post on this forum with great hope. I'm working on large worksheets with SUMIFS function. In case of normal trace dependent we use trace dependent function which is built in function in excel. However it does not work in case of SUMIFS function if we want to refer actual cells in another worksheet.
I need VBA code to trace dependent cells with mark in color in another worksheet so that I can easily refer those cells in SUMIFS function.
Hope I have addressed my query properly. If you need further clarification, pls let me know.
Regards,
This is my first post on this forum with great hope. I'm working on large worksheets with SUMIFS function. In case of normal trace dependent we use trace dependent function which is built in function in excel. However it does not work in case of SUMIFS function if we want to refer actual cells in another worksheet.
I need VBA code to trace dependent cells with mark in color in another worksheet so that I can easily refer those cells in SUMIFS function.
Hope I have addressed my query properly. If you need further clarification, pls let me know.
Regards,