In Progress

Filter Raw Data from Excel Export - Need Proper Filtering

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.

Skills: Data Entry, Data Processing, Excel, PHP, Web Scraping

See more: filter as you type excel vba, dynamic search box in excel, excel dynamic filter to new sheet, dynamic filter excel vba, excel filter search box, dynamic advanced filter excel, dynamic excel filter, filter data using combo box excel, business raw data excel, excel export data workbook, excel export range data, excel export xml data, vbscript manipulate excel export data, vba excel export data csv, excel fetch data web site need log, read data sql export excel using aspnet, need programmer importtext file excel data base, aspnet excel export data, processing raw data excel, usb filter driver raw data window

About the Employer:
( 18 reviews ) Dallas, United States

Project ID: #15674207

Awarded to:

ajthorpe

Hi there, This is straightforward enough and I'll be able to have it done for you by the morning. Could you message me so we can discuss further? Regards, Andrew Relevant Skills and Experience I'm an experienced dev More

$30 USD in 1 day
(9 Reviews)
2.9

13 freelancers are bidding on average $126 for this job

WebInfoSolutions

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

$157 USD in 3 days
(169 Reviews)
7.7
$250 USD in 1 day
(131 Reviews)
7.5
$55 USD in 3 days
(146 Reviews)
6.2
osmemon

I have 7 years of experience in Excel and VBA with 100^% client satisfaction history. See my profile for client reviews about me. Relevant Skills and Experience Excel VBA Proposed Milestones $94 USD - only Looking f More

$94 USD in 1 day
(29 Reviews)
5.4
saaz109

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

$155 USD in 3 days
(16 Reviews)
4.5
insidenetsoft

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

$50 USD in 1 day
(19 Reviews)
3.9
natalka503

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

$111 USD in 3 days
(9 Reviews)
3.3
vw8323415vw

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

$100 USD in 5 days
(7 Reviews)
2.9
mustafurzurrhama

Hello Dear, I am an expert in Data Entry, Excel and I am really interested in your project. Relevant Skills and Experience Data Entry, Data Processing, Excel, PHP, Web Scraping Proposed Milestones $111 USD - mileston More

$111 USD in 3 days
(0 Reviews)
0.0
lokmanmarketer

Hi , I am Md. Lokman Hakim. I am very much interested on your project .I feel that I am the exact match for your requirements after thoroughly reviewing the job description and desired skills. Relevant Skills and Exp More

$35 USD in 3 days
(0 Reviews)
0.0
adambostonma

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

$444 USD in 3 days
(0 Reviews)
0.0
DJWORKER11

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

$50 USD in 2 days
(0 Reviews)
0.0