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
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 worksheet in PM. I am really interested in your project. I can guarantee you the on time and reliability of job. I can start [login to view URL] in PM.
£30 GBP en 3 días
4,9 (38 comentarios)
5,3
5,3
28 freelancers están ofertando un promedio de £106 GBP por este trabajo
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 macros, fixing of bugs and minor changes are included in the bid without any additional fees.
Regards!
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 horsepower and more flexibility than Excel offers. I'll convert the existing file and add a couple of reports, which will set you up for more advanced tracking and reporting down the line.
I have worked with Filemaker since it came out in 1984. See the private message for more info on my qualifications.
Thanks,
Doug Allen
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 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
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 copies if you so desire. U can expect quality work in time.
Thanks
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
I have over 28 years' as a technical writer, developer, and CIO. I have created complex, menu-driven MS Access apps for large clients like AT&T, Cox Communications, and others. I would like to be of assistance. Let's get started.