Filter Raw Data from Excel Export - Need Proper Filtering
$30-250 USD
Paid on delivery
I export an excel data everyday that I need sorted properly. I need you to create an excel summary page based on values i need to see from the raw data. I have uploaded the sheet with the raw data and the summary page format I need to be able to read.
Key Features:
Site: Need to be able to filter by a single Site or multiple selected Sites
Dealer: Need to be able to filter by a single dealer or multiple dealers and/or sites or no sites
Username: Need to be able to filter by a single username or multiple users name and/or dealers and/or Sites
Billing Period: Need to be able to filter the above by a specific month and Year.
*I need to know all NEW camera adds for that billing period and the cameras that were added in past months (Renewal Cameras).
* Excel raw data export only displays a new entry when there is a modification to a specific dealer.
* The Excel Sheet which I have updated only works if I want to select a specific Dealer to search camera adds.
Uploaded Files:
1. The Plan-History Month is the export of raw data format.
2. The Dealer Billing is the billing sheet example I made of the information I need to be able to see. I'm missing the above filter options that need to be added.
Project ID: #15674207
About the project
11 freelancers are bidding on average $136 for this job
Sir, Will it be done using some excel macro or using php? Relevant Skills and Experience php and vba dev Proposed Milestones $157 USD - on end
Hello, I have over 5 years experience in this kind of projects and I would like to help you. Please contact me via chat to discuss details. Greetings, Natalie Relevant Skills and Experience Hello, I have over 5 years More
Hi,I have read your requirements and I’m pretty confident that I will be able to get your work done within the given time your requirements conclude. I am very keen to discuss further. Relevant Skills and Experience I More
Hi, I can develop a single page website to export an excel data every day Relevant Skills and Experience Data Entry, Data Processing, Excel, PHP, Web Scraping Proposed Milestones $155 USD - for excel
Hello, A user friendly form will be created in order to have some easy to use options for the single and multi select. I understand your idea about what you need and would love to get in touch for this project. Rega More
hello sir, I have read your details of project and ready to work with you in this project. i have much experience in such work i have done this kind of work before You can talk to me once and i hope you will get idea More
this seems like a lot of fun to sort things via excel. I have done a lot of times. Relevant Skills and Experience this seems like a lot of fun to sort things via excel. I have done a lot of times. Proposed Milestones More