Trace dependent cells with mark in color in another worksheet in sumifs function

[LakTik]

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,

 

[LakTik]

Dear Experts,

Pls. ignore previous post. Pls read trace precedent instead of trace precedent.

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 precedent we use trace precedent 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 precedent 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,