Hi Guys,
I want to write a macro on row addition/deletion. please refer to attached file:
I have a raw data which will be updated in "Incidents" sheet of the file. my requirement is:
1. based on this raw data create table as shown in "IncidentMetrics" sheet.
2. whenever user adds/removes row from this sheet tables created in step 1 should be updated.
3. based on these tables line chart should be created
I am looking to automate report generation based on the data modification.
guys, any direction in this context is highly appreciated.
Thanks in advance.
Bookmarks