Dear Team,
I having the weekly analysis report. which contains two sheet one is dashboard and another is Data sheet
Weekly i update the data so that the dashboard get changed.
I am attaching the sample data sheet. Also i provide the formula conditions and input data conditions.
I have give two colour one is yellow that is input automatically pull from data sheet to dashboard sheet and Red colour in that the formula should not change.
Kindly provide the macro if upload n number of data the dashboard get changed according to the conditions.
I having the weekly analysis report. which contains two sheet one is dashboard and another is Data sheet
Weekly i update the data so that the dashboard get changed.
I am attaching the sample data sheet. Also i provide the formula conditions and input data conditions.
I have give two colour one is yellow that is input automatically pull from data sheet to dashboard sheet and Red colour in that the formula should not change.
Kindly provide the macro if upload n number of data the dashboard get changed according to the conditions.