microK

My projects:

• Create a script or excel formula that searches partial keywords from one excel sheet into another

  $30 USD
  0.0
  

  mannieg [ Incomplete Report ]

  Dec 17, 2012

  “ The project is not completed according to the disputeThe project is not completed according to the dispute ”
  Project Description: This should be pretty simple i need a script or formula that can pull longitude and latitude values from another spreadsheet by matching either by exact or partial by city, town or county. I already have all the data for longitude and latitude so i just need the script set-up...
  [more]

• Excel workbook that calculates from external workbooks

  $50 USD
  5.0
  

  MOAKES

  Oct 28, 2012

  “ MicroK was fantastic! Definitely a VBA whiz! He took my description and built EXACTLY what I wanted. He communicated regularly and clearly. Great to work with and will hire again for other VBA work.MicroK was fantastic! Definitely a VBA whiz! He took my description and built EXACTLY what I wanted. He communicated regularly and clearly. Great to work with and will hire again for other VBA work. ”
  Project Description: I want one Excel sheet in a workbook that calculates values from several (7) other external workbooks. I would prefer that is be done as formula calculations but macro programming is acceptable as well...
  [more]

• parse text field

  $30 USD
  5.0
  

  postuma

  Oct 25, 2012

  “ High quality work.High quality work. ”
  Project Description: See spreadsheet attached. I need the last column ("textcontent") split into separate fields: 1. date (e.g. 10/23/2012; appears near the top of the text, formatting may vary slightly) 2. full author info (e.g...
  [more]

• Version 2 of CRT Signings Report

  £50 GBP
  5.0
  

  Fundraiserman

  Sep 30, 2012

  “ Once again MicroK has met and surpassed my expectations with his knowledge, VBa expertise and professionalism to deliver an outstanding solution to a tricky problem. In addition, having hired MicroK on a number of occasions now, I have found his commitment to cheerful on-going support and 'after-sales-service' to be unswerving.Once again MicroK has met and surpassed my expectations with his knowledge, VBa expertise and professionalism to deliver an outstanding solution to a tricky problem. In addition, having hired MicroK on a number of occasions now, I have found his commitment to cheerful on-going support and 'after-sales-service' to be unswerving. ”
  Project Description: Upgrade of a prior project to include two extra columns of data to be imported from an amended file layout.
  [more]

• VBA code to copy html table from webpage into Excel as text

  $50 AUD
  4.0
  

  zoomonkey

  Jul 13, 2012

  “ Very capable, and great structure to the project to ensure clear understanding of what was required. Will invite for future work.Very capable, and great structure to the project to ensure clear understanding of what was required. Will invite for future work. ”
  Project Description: [This is a Private Project. You must be logged in to view the Project Description]
  [more]

• excel positive filter for kamal

  $37 USD
  5.0
  

  TulsaOkDesigner

  Jun 30, 2012

  “ great job again,, thank yougreat job again,, thank you ”
  Project Description: excel positive filter for it will filter the good results from a excel file. this job is for kamal as he does really great work
  [more]

• Excel Filtering Script for Kamal

  $39 USD
  5.0
  

  TulsaOkDesigner

  Jun 26, 2012

  “ Kamal, is great to work with, very smart, spent extra time working on my project, made a exceptional product.will use againKamal, is great to work with, very smart, spent extra time working on my project, made a exceptional product.will use again ”
  Project Description: Excel Filtering Script need to be able to filter 3 fields to leave a cleaned excel file, need to be able to rub script daily
  [more]

• excel extraction

  $40 USD
  5.0
  

  TulsaOkDesigner

  Jun 21, 2012

  “ 2nd Job, again great to work with, on time, great results2nd Job, again great to work with, on time, great results ”
  Project Description: extract all phone numbers, fax number and email address from content of files, remove duplicates, save as a text file
  [more]

• excel filter

  $68 USD
  5.0
  

  TulsaOkDesigner

  Jun 17, 2012

  “ Great work, really good communicator, will use againGreat work, really good communicator, will use again ”
  Project Description: i have a excel file, see example, ( the actual file may have about 2 k of words) i want to be able to remove any record if it has any of the keywords found in a raw text file( the actual file may have...
  [more]

• Write macro to run in Microsoft Word

  $60 USD
  5.0
  

  secaada

  May 26, 2012

  “ MicroK understood and executed the project on time and on budget. He was able to make several modifications to the project outside the original specifications, had an excellent command of English and a high level of programming skill. I would work with him again.MicroK understood and executed the project on time and on budget. He was able to make several modifications to the project outside the original specifications, had an excellent command of English and a high level of programming skill. I would work with him again. ”
  Project Description: Write a Macro that can be saved in Microsoft Word and when rub will read through a document, find all instances of text enclosed by single quote marks, and replace the first letter of each word within...
  [more]

microK has not completed any projects.

microK does not have any work in progress.

• Extract Emails from Excel

  $250 USD Yesterday

  We need someone who is familiar with Microsoft excel and can extract the data from one excel sheet and compile another excel sheet with just first name last name and email address for all email addresses.We need someone who is familiar with Microsoft excel and can extract the data from one excel sheet and compile another excel sheet with just first name last name and email address for all email addresses.

  [more]

• excel macro version upgrade

  $750 USD Yesterday

  I have a excel macro that developed in office2000.But it's version is very old.So I must upgrade to 2010.If you don't know japanese, please do not bid.I can talk about my project on SKYPE in japanese.I have a excel macro that developed in office2000.But it's version is very old.So I must upgrade to 2010.If you don't know japanese, please do not bid.I can talk about my project on SKYPE in japanese.

• Excel Sheet Repair Errors #REF and Mismatch error 13)

  $30 USD Today

  We have a user interface that allows input of 3 quantitative data. It was done with password and date expiry. The Excel macro allows for simple Get Pivot Data from accompanying data sheet.Upon input of data we should get a model number for a cooing tower.Cooling tower model number is one of:100, 125, 150, 175, 200, 225, 250, 275, 300, and in multiple cells above models multiplied by 2, 3, 4, 5, 6, 7, 8, 9, 10.all data being entered there is an error#REF,#REF andMismatch (Error 13)Correction of the above is needed.After use, upon closing file: Saving File will cause corruption, THIS IS TO BE CORRECTED.We have a user interface that allows input of 3 quantitative data. It was done with password and date expiry. The Excel macro allows for simple Get Pivot Data from accompanying data sheet.Upon input of data we should get a model number for a cooing tower.Cooling tower model number is one of:100, 125, 150, 175, 200, 225, 250, 275, 300, and in multiple cells above models multiplied by 2, 3, 4, 5, 6, 7, 8, 9, 10.all data being entered there is an error#REF,#REF andMismatch (Error 13)Correction of the above is needed.After use, upon closing file: Saving File will cause corruption, THIS IS TO BE CORRECTED.

  [more]

• Excel Expert Project - Creation of Macro/VBA

  $100 USD Yesterday

  Excel Expert to create Excel Macro/VBA file which can be used to update products in stock for uploading to our website.Currently our in store stock count system does not update our website stock counts - as a result we need a solution which can manage this.The Macro/VBA file will need to pull data from the txt file (RSARepGen) attached and match this up with the website upload file (Products) attached to then create an updated version of the website upload file.Will require matching up products based on 'Number' in the RSARepGen and 'ID [Alias]' in Products file. To update stock will require taking data from 'SOH' column in the RSARepGen - which has figures such as 5/20. Any information to the left of the '/' needs to be multiplied by the figure in the 'Case quantity' column e.g. 5 x 24 = 120 + 20 = total stock quantity of 140 units. This then needs to be updated in the 'Stock level' column in the Products file.There are also a number of rules that will need to be applied to the stock counts to ensure the website always lists a lower level of stock than what is carried in store.This project requires someone with advanced Excel skills and strong understanding of English.Excel Expert to create Excel Macro/VBA file which can be used to update products in stock for uploading to our website.Currently our in store stock count system does not update our website stock counts - as a result we need a solution which can manage this.The Macro/VBA file will need to pull data from the txt file (RSARepGen) attached and match this up with the website upload file (Products) attached to then create an updated version of the website upload file.Will require matching up products based on 'Number' in the RSARepGen and 'ID [Alias]' in Products file. To update stock will require taking data from 'SOH' column in the RSARepGen - which has figures such as 5/20. Any information to the left of the '/' needs to be multiplied by the figure in the 'Case quantity' column e.g. 5 x 24 = 120 + 20 = total stock quantity of 140 units. This then needs to be updated in the 'Stock level' column in the Products file.There are also a number of rules that will need to be applied to the stock counts to ensure the website always lists a lower level of stock than what is carried in store.This project requires someone with advanced Excel skills and strong understanding of English.

  [more]

• Microsoft Word Automation

  $30 USD Today

  Hi guysPretty basic stuff. I need some actions automated. I have a Microsoft Access form executing some commands. It exports a report in RTF format into a specified location. I then need Microsoft Word to automatically open the file, save it as a text file, and add '.html' to the end of the file name. That's it!Hi guysPretty basic stuff. I need some actions automated. I have a Microsoft Access form executing some commands. It exports a report in RTF format into a specified location. I then need Microsoft Word to automatically open the file, save it as a text file, and add '.html' to the end of the file name. That's it!

  [more]

• Excel macro template ...

  $50 AUD 6 days ago

  I want to open the template.Insert parts and laborSave as 'New Name'Then work on new customer by opening orginal template (invoices # increases by one)Insert parts and laborSave as 'New Name1'Then work on another customer by opening orginal template and the template invoice number increase by 1.This scenerio would give me three customers invoices with three different invoice numbers and the template ready to be opened with a the fourth number in sequence.More specification :- 1.on template of an invoice (in excel) , I need it to automaticallygenerate a different invoice number every time I open it. Such as 001 the1st time, 002 the 2nd time etc.and when saved the generated invoice then the invoice number is updated.or example i open the template and says invoice number 3 - i make my invoice wants to save it when i save it it should ask me do you want to upgrade the invoice number and i say yes so the next time i open the template then the invoice number should be 4. but remember i don't want the number to change when i am opening the invoices saved , once they are saved that's it done have nothing to do with the template.2.today date each time i open the invoice template.3.customer date base so i can just select and the detail and contact number and reference and FAO to come up and fill the requirement.4. the calculation of VAT and the rest as it shows.5.i want another sheet to have invoice summary so when the invoice created automatically saved in there. i need to filter them according to quarter of the year basis , means Jan 13 to march 13 as one ,,,, April-13 to Jun 13 as 2. ......i have attached something for your assistant but i don't want anything as complicated as that.I want to open the template.Insert parts and laborSave as 'New Name'Then work on new customer by opening orginal template (invoices # increases by one)Insert parts and laborSave as 'New Name1'Then work on another customer by opening orginal template and the template invoice number increase by 1.This scenerio would give me three customers invoices with three different invoice numbers and the template ready to be opened with a the fourth number in sequence.More specification :- 1.on template of an invoice (in excel) , I need it to automaticallygenerate a different invoice number every time I open it. Such as 001 the1st time, 002 the 2nd time etc.and when saved the generated invoice then the invoice number is updated.or example i open the template and says invoice number 3 - i make my invoice wants to save it when i save it it should ask me do you want to upgrade the invoice number and i say yes so the next time i open the template then the invoice number should be 4. but remember i don't want the number to change when i am opening the invoices saved , once they are saved that's it done have nothing to do with the template.2.today date each time i open the invoice template.3.customer date base so i can just select and the detail and contact number and reference and FAO to come up and fill the requirement.4. the calculation of VAT and the rest as it shows.5.i want another sheet to have invoice summary so when the invoice created automatically saved in there. i need to filter them according to quarter of the year basis , means Jan 13 to march 13 as one ,,,, April-13 to Jun 13 as 2. ......i have attached something for your assistant but i don't want anything as complicated as that.

  [more]

• Business Documents - Macro Development

  $100 AUD 14 days ago

  I need someone to take some corporate document templates we have created and generat entry marcos around them. ie : User opens template, dialog box prompts for information, then the macro enters it in, not allowing the user to mess with the fields.There are 5 document templates:FaxLetterMemoMintuesReportI need someone to take some corporate document templates we have created and generat entry marcos around them. ie : User opens template, dialog box prompts for information, then the macro enters it in, not allowing the user to mess with the fields.There are 5 document templates:FaxLetterMemoMintuesReport

  [more]

• Excel Macro Required

  $50 USD 15 days ago

  I need an excel macro written that can group rows in a spreadsheet where certain text shows up in a cell. I can provide a spreadsheet that will show how all the data looks before formatting and what it should look like after running the macro. I am currently formatting the spreadsheet manually.The data I'm working with can have up to 180 rows in a worksheet, with the following sub headings included:---------------------------------------------------------------TOTAL INCOMEEXPENDITURETotal Service PurchaseTotal Client ServicesTotal Corporate ServicesTOTAL EXPENDITURENET INCOME / (DEFICIT)---------------------------------------------------The headings shown above represent the way I need the worksheet to look after running the macro however the original format includes a number of various income and expense items under each sub heading. These all need to be condensed and grouped together.I need an excel macro written that can group rows in a spreadsheet where certain text shows up in a cell. I can provide a spreadsheet that will show how all the data looks before formatting and what it should look like after running the macro. I am currently formatting the spreadsheet manually.The data I'm working with can have up to 180 rows in a worksheet, with the following sub headings included:---------------------------------------------------------------TOTAL INCOMEEXPENDITURETotal Service PurchaseTotal Client ServicesTotal Corporate ServicesTOTAL EXPENDITURENET INCOME / (DEFICIT)---------------------------------------------------The headings shown above represent the way I need the worksheet to look after running the macro however the original format includes a number of various income and expense items under each sub heading. These all need to be condensed and grouped together.

  [more]

• Excel Macro specialists

  ₱7700 PHP Apr 19, 2013

  Make a computation table and data analysis using excel macro.Further discussions will be needed w/ a freelancer.Make a computation table and data analysis using excel macro.Further discussions will be needed w/ a freelancer.

• excel macro show sheets on password input

  $40 USD Nov 7, 2012

  Hi,I want an excel workbook with macros to show sheets depending on password input.The idea is that when someone opens the workbook it would ask for a password. 15 different people are goint to be working with this workbook, but I want them to be able to see and modify only the sheet associated with their password.I have a very basic knowled of macros, but i want to be able to modify it in case i have to add a sheet later on. I also want to be able to modify the passwords.Hi,I want an excel workbook with macros to show sheets depending on password input.The idea is that when someone opens the workbook it would ask for a password. 15 different people are goint to be working with this workbook, but I want them to be able to see and modify only the sheet associated with their password.I have a very basic knowled of macros, but i want to be able to modify it in case i have to add a sheet later on. I also want to be able to modify the passwords.

  [more]

• Excel marco work(simple)

  $30 USD Nov 3, 2012

  I need help in excel. I will provide more details in PMB.I need help in excel. I will provide more details in PMB.ThanksI need help in excel. I will provide more details in PMB.I need help in excel. I will provide more details in PMB.Thanks

• Microsoft Excel Formula Writing

  ₹12500 INR Oct 13, 2012

  To compute simple payroll using Microsoft Excel.Require expert in Microsoft Excel to write and test simple formula.As i am using Microsoft 2003, please ensure that your Excel work on mine.To compute simple payroll using Microsoft Excel.Require expert in Microsoft Excel to write and test simple formula.As i am using Microsoft 2003, please ensure that your Excel work on mine.

• Custom Project Sep 21 2012 21:09:56

  $150 USD Sep 21, 2012

  I would like to convert a macro attached to a Word 2003 template into a macro that will run on a Word 2010 template. The macro is quite large - over 80 pages of text. Some of the code is easily translated or imported, some will require a bit of translation.The macro is essentially a Chinese vocab quiz program that makes use of text files as the input data and runs a quiz accordingly. It takes control of Word and writes the questions for the user to respond to in a Word doc, then displays a control box for the user to use to select or input a response.You can see what the program does if you load the .dot file I uploaded and run the Vocab Review macro attached. The macro assumes text files with the data for the quizzes will be loaded in folders as follows:D:\ApData\ChVoc\ CfLsn ChVoc Docs ChVoc Templates CiLsn FJLsn ZiLsnTo see what the program does, place H101-02Z.067.txt in ZiLsnplace conf004x.005.txt & conf006x.004.txt in CfLsnplace H101-02C.083.txt in CiLsnplace H101A-fj.070.txt in FJLsnplace ChVocRev.doc in ChVoc DocsTo view the output you need a system with Chinese fonts. The code works fine in Word 2003. It has been debugged. Can you give me a reasonable price to make functional for Word 2010?I would like to convert a macro attached to a Word 2003 template into a macro that will run on a Word 2010 template. The macro is quite large - over 80 pages of text. Some of the code is easily translated or imported, some will require a bit of translation.The macro is essentially a Chinese vocab quiz program that makes use of text files as the input data and runs a quiz accordingly. It takes control of Word and writes the questions for the user to respond to in a Word doc, then displays a control box for the user to use to select or input a response.You can see what the program does if you load the .dot file I uploaded and run the Vocab Review macro attached. The macro assumes text files with the data for the quizzes will be loaded in folders as follows:D:\ApData\ChVoc\ CfLsn ChVoc Docs ChVoc Templates CiLsn FJLsn ZiLsnTo see what the program does, place H101-02Z.067.txt in ZiLsnplace conf004x.005.txt & conf006x.004.txt in CfLsnplace H101-02C.083.txt in CiLsnplace H101A-fj.070.txt in FJLsnplace ChVocRev.doc in ChVoc DocsTo view the output you need a system with Chinese fonts. The code works fine in Word 2003. It has been debugged. Can you give me a reasonable price to make functional for Word 2010?

  [more]

• Custom Project Mar 6 2012 22:56:17

  $30 USD Mar 6, 2012

  I wanted to set this up on the Excel, with the tables etc I wanted to set this up on the Excel, with the tables etc

• Excel Spreadsheet and Word Merge document

  $250 AUD Jan 28, 2012

  I have a completed spreadsheet and merge document but the data just wont merge properly in one field. A fairly simple job for anyone with a bit more than basic Excel abilityI have a completed spreadsheet and merge document but the data just wont merge properly in one field. A fairly simple job for anyone with a bit more than basic Excel ability

• Data entry in English

  $40 USD Oct 14, 2011

  Need help inputting excel worksheets into word documents. Thank youNeed help inputting excel worksheets into word documents. Thank you

• Making a high quality graph from excel spreadsheet

  $30 USD Sep 7, 2011

  I want a high quality graph in pdf form, from a professional software such as SAS, STATA, SPSS. The graph made from excel in of poor quality and not worthy of publication. It is a very simple graph that should not take much time to make; but I want to approve the colors/dimensions before payment.I want a high quality graph in pdf form, from a professional software such as SAS, STATA, SPSS. The graph made from excel in of poor quality and not worthy of publication. It is a very simple graph that should not take much time to make; but I want to approve the colors/dimensions before payment.

  [more]

• Data pulled from email, Twitter invite

  $100 USD Jul 6, 2011

  We are in need of switching Twitter accounts. We need somebody to 1) pull twitter follower addresses from about 3000 individual confirmation emails which we will forward, and then 2) using our new twitter account invite them to follow the new accountWe are in need of switching Twitter accounts. We need somebody to 1) pull twitter follower addresses from about 3000 individual confirmation emails which we will forward, and then 2) using our new twitter account invite them to follow the new account

  [more]

• Data entry in MS excel

  $30 USD Mar 3, 2011

  I need individual who is skilled in MS excel(100sheets)...For data entry..more details will be sent to PM...Bid me with the app time will be taken for completion..I need individual who is skilled in MS excel(100sheets)...For data entry..more details will be sent to PM...Bid me with the app time will be taken for completion..

• Create an index in excel from a folder

  $30 USD Feb 21, 2011

  Hi,I need an excel sheet that will read all the files from a given folder (and sub-folders too).The developed workbook should be able to create a list with the contents of the selected folder (an index).Thank you!Hi,I need an excel sheet that will read all the files from a given folder (and sub-folders too).The developed workbook should be able to create a list with the contents of the selected folder (an index).Thank you!

  [more]

microK does not have any open projects.

microK does not have any work in progress.

Portfolio

Description

Related Work

microk Portfolio