I need a very simple excel program done by today. Please bid only if you have excel programming/macro experience. This will not take more than couple of hours for an experienced excel programmer, so please bid accordingly.
ID-Short
-The Number column indicates the sequence of item and also a permanent number ID assigned to it See in the excel sheet provided, battery part number431436-001 appears twice but maintains number 1 as the code (blue cells)Any new part number
must take the second number in series. E.g look at 431489-001 battery that has taken number 2 and it goes on and on like that to 3. Therefore column D should have a formula that will
be able to assign numbers as indicated.
I have a number of tasks that require some excel programming to be written for my business. We use a lot of spreadsheets and there are about 4-5 things we would like to be automated.
I have a preference for people in our timezone (London) as there will most likely be a need for communication to ensure the projects are done properly.
I need an excel formula or macro that will highlight pre-defined keywords or cells in a workbook. These are already sorted out I just need to make sure I can see where the boarders are.
Thanks
sh some very simple C programming. Some basic string tokenizer functions, simple sort and recursive functions for C program are required. It is a urgent project, need to be finished within 36 hours.
I have uploaded some sample for reference. The actual project consists few more questions. The maximum paid for this project is $ 55, much appreciate if you could finish the project earlier, and we are looking for the long term project relationship.
quot; in the attached file.. simple work and you will understand it when you go through the attached file.. I need it asap and i want the macro to fill all the data from 1990 January to 2011 December.. Please bid if you are highly capable of this and new freelancers are well come. Many more projects to be followed.. If you have done any previous work please provide reference in PM so i can make the best decision.
I've also attached the data inXML format just in case you would rather work with XML format as long as it can be converted to Excel with the same format as the Excel data file.
I'm open to suggestions if there is any other ways to do it besides using Excel macro / vba but like I said above that the final result has to be in Excel format.
Please contact me if you need further explanation.
t). What I'm looking for is a function for the cells in a column (Column A) that, for each row, will compare the value in Column B for that row with all the values in the same column for the rows above as well as all the rows in that column (Column B) in two other worksheets.
If a match is found, the corresponding value in Column A of that row will then be returned. If no match is found, the text 'NO MATCH' will be returned.