I need your help!
I've been visualizing this but I don't know what to do.
I have a Sales Monitoring excel sheet for manual inputs. I have also a Summary sheet to show the total Revenue and Cost based on the dropdown selection.
The Sales Monitoring Sheet has four categories namely facebook likes, twitter followers, youtube views, website traffic. Each has specific amount in of Revenue, cost and profit to be entered manually in Sales monitoring sheet.
Now, what I want to do is the Sales Summary sheet - should calculate the total Revenue, Paypal fee, cost and profit for each category. There should be a dropdown list of the category (facebook likes, twitter followers, youtube views, website traffic) and in the other columns should have the total cost/profit for all of the sales in that category.
So, when I select "Facebook likes" category (dropdown lists) in the Sales Summary, it will classify all the entries from the Sales Monitoring sheets, sum it up and display automatically to the total Revenue, Paypal fee, cost and profit columns of the Sales Summary sheet.
I have attached the sample worksheet.
Thank you so much for your help.