Hi All

In my excell sheetSOURCE.png

i want to create below out. right now im doing manually using filter the record and copy into next sheet. i want to automate this process .im new to the vba programming. is there any sample code or guide required to do this task

TARGET.png

Im looking simlar kind of output for group by resource name and create graph for each resources. i want to do with single button click. can you guide me or give some sample code. this need to be automated.

regards

ganesh