Incidents age-wise category

[rvr ramana]

Hello All,

Trust all doing well and safe.

looking again for experts help, find the attached and help me in getting the details (security purpose changed the details). What am looking for as follows :

Raw data contains all the incident details ( reference, summary, open Date and Last/closed date and total number of Days etc.) Aging column i have inserted if not required you guys can remove. So i need to send report to customer who wants the calls which are logged (or) last updated/closed according to the age (in short age wise call). so i need to fill other tabs manually . Like how many calls falls under ( <=15 days, calls pending between >15 days to <=1month and so on) you can see the tabs according to age-wise.

please let me know if that help.

Regards.
Raj

[nankw83]

Hi Raj,

Try below code ... Aging column is not required for the code but you need to have the same exact header in each sheet

Please Login or Register  to view this content.

[rvr ramana]

Hi Nank83,

Thanks for your quick help and response.

Am afraid am Layman to coding (any of the coding), i can only manage with small formulas. if you could able to keep the code in the template that would really help.
could you do that for me please if possible?

[nankw83]

You can try the attached file ... In order to put the code in the excel file, you can follow the below steps

1. Press Alt+F11 to open the Visual Basic window
2. Press Alt+I+M to insert a new module
3. Paste the code
4. Press F5 to run the code

[rvr ramana]

Hi ,

Thanks a lot code perfectly executed and got the result what am lookin in for. Really appreciate for your quick help.
but only one query, when i run the query am getting the following error upon selecting Ok the code working perfectly. Is that anything i need to worry about that error?

[rvr ramana]

Ohh is that it saying that one i mentioned below the Coloumn E under the table content will not be copied?

[nankw83]

My bad I posted the wrong file in post #4 ... Try attached file

[rvr ramana]

Awesome got what exactly am looking in for.. Thanks again..

[nankw83]

You are welcome ... If that takes care of your question, please take a moment & mark this thread as [SOLVED] from the Thread Tools above your first post