Completed

Excel Spreadsheet Amendments

Hi There

We are looking for someone to help with our work in progress excel spreadsheet and have the below features added.

1. The sheet has data validation for pull down lists however when an item is selected from the list we would like it to change the whole row a particulat colour.

2. Date to be added when we start a new line/job

2. We would also like to be able to have graph reports setup on a seperate sheet within the workbook. for example the sheet details all of our open jobs and has a data validates list for customer so we would like to be able to see a graph detailing how many customers have open jobs and also view the amount of jobs by status.

3. Not sure if this is possible however we would also like to be able to mark jobs as complete and have them remove from this list and go to another page as an archive.

I understand that this may be somthing better suited to access or file maker so if that will be easier then i would be happy to talk about that!

The excel file has been attached...

Thanks

Jonny

Skills: Excel, FileMaker, Microsoft Access

See more: work on line jobs, when to change jobs, open an microsoft access file on line, microsoft jobs, microsoft excel spreadsheet, microsoft excel job, microsoft access jobs, mark may, lists jobs, list graph, jobs spreadsheet, job spreadsheet, jobs microsoft excel, jobs microsoft access, jobs in microsoft access, excel sheet for customer details, line graph excel, jobs reports, how to microsoft excel, excel mark, workbook amendments, spreadsheet microsoft excel, spreadsheet 2, row spreadsheet, reports in excel

About the Employer:
( 39 reviews ) St Ives, United Kingdom

Project ID: #1241866

Awarded to:

Pichart

I am an excel developer. I am expert in Excel both excel standard and Vba coding. I work with coding more than 10 years. I have view your attachment and know that excel is proper for you. I attach sample of you new wor More

£30 GBP in 3 days
(38 Reviews)
5.3

28 freelancers are bidding on average £106 for this job

koolsidz

Excel Whiz here ;) Please see PMB for more details.

£45 GBP in 0 days
(151 Reviews)
6.5
svet63

Excel developer since 1997. Can do. Regards, Svet.

£150 GBP in 5 days
(59 Reviews)
6.5
binaryromel

##### Excel expert here! Please check PM. #####

£40 GBP in 1 day
(89 Reviews)
6.0
vserv

Well suited to be done using Excel. Please see your messages. Thanks

£60 GBP in 2 days
(57 Reviews)
5.8
douglasallen

This bid is for converting your spreadsheet to a Filemaker database. What you have now can probably be done in Excel easily enough, and more cheaply. But if you have other goals for this file, you'll need more db hor More

£150 GBP in 3 days
(10 Reviews)
5.4
MDavidCrompton

Good Morning, EXCEL will do fine. Please check your file in PM, done except for the charts. the archive works fine. Also check my feedback if you would. Hope to work on this with you Regards David

£75 GBP in 1 day
(39 Reviews)
5.6
nagybatonyi

I've recently completed a very similar project. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macr More

£60 GBP in 4 days
(62 Reviews)
5.7
KellogITSolution

Hello Me an Ms-Excel Expert working on MS-Excel & VBA for the past 10 years. I am ready to do your work and could start right now. I have already done a no. of successful Excel Projects and can provide u sample copi More

£50 GBP in 4 days
(31 Reviews)
4.7
psprongs

Hi, I have lots of experience in data processing using excel. I can provide with easy to use solution and can start immediately. Please check PMB pspronsg

£50 GBP in 1 day
(11 Reviews)
4.5
braghunath

I have been developing applications in MS Access since the year 2003. I can take up this project immediately. Thanks [login to view URL]

£90 GBP in 7 days
(3 Reviews)
4.1
shacoim

***Plz Check PM***

£40 GBP in 1 day
(12 Reviews)
3.9
facilitator

please see Bid details in PMB

£50 GBP in 7 days
(1 Review)
2.3
timlit

Good day, johnnywood. You do need to consider a full-fledged database, such as FileMaker. My specialty. A pro developer here. Thanks.

£200 GBP in 3 days
(2 Reviews)
1.6
jahangirnism

Hi, I am VBA programmer,and I am only here to do this kinda job. And your concept can be implement. I am keen to take this project ASAP Regards MD JAHANGIR

£45 GBP in 1 day
(1 Review)
1.4
humakh

I am ready to start. I will ensure quality work on strict deadlines.

£200 GBP in 6 days
(0 Reviews)
0.0
MrDDDAlkilanny

Preffisional Data entry

£391 GBP in 2 days
(0 Reviews)
0.0
OMstat

I'm an Excel Consultant and MS Excel certified Expert. I've done similar projects. Please see PM.

£50 GBP in 1 day
(0 Reviews)
0.0
thedoc2or

Your requirement is pretty straightforward. Please refer detailed separate email sent.

£200 GBP in 1 day
(0 Reviews)
0.0
yhangelco

very much ready to start send me more details thanks.

£20 GBP in 0 days
(0 Reviews)
0.0
agustingt8

Now review the sample file and if I can do the job, I have more than 10 years trabanjado to excel, give me the opportunity to demostrate that if I can do the job. thanks for the opportunity.

£60 GBP in 3 days
(0 Reviews)
0.0