VBA Macro - Filter data , copy and paste filter data in a new sheet

[daniel95]

Hi guys,

Could someone help me in this regard.

These are the steps i'm trying to automate

1) Filter each unique value in column C
2) copy and paste the whole filtered data in an unique new sheet.
3) Continue till all the unique values in Column c are completed.
4) Perform arithmetical function in each new sheet at the last row.

 

[My Aswer Is This]

What is the unique value and what is the unique sheet?
Your quote:

"Filter each unique value in column C"

 

[daniel95]

What is the unique value and what is the unique sheet?
Your quote:

"Filter each unique value in column C"

Thanks for your prompt reply.

Attaching a file which contains what i actually am trying to achieve.

https://drive.google.com/open?id=0BzyaCHizI4U6dkxmbmgzNGhUWDg

 

[My Aswer Is This]

I never click on links.

Not sure why you cannot answer my two questions.

 

[daniel95]

Unique value - This would be each value in that column.
Unique sheet - I meant by a new sheet for each filtered data in which the data would be pasted.

I just represented what i wanted in an excel sheet. As i couldn't attach an excel i had uploaded it in a google drive.