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...
28 freelancers are bidding on average £106 for this job
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
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
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.