VBA Jobs

90 were found based on your criteria

  • Hourly – Less than 1 week – 10-30 hrs/week – Posted
    I have a job where I need to combine six spreadsheets using a common reference. After all the worksheets are combined, I delete multiple columns and then I add a couple columns and then run either formula or VBA/macro in the added columns. I use recorded macros for the adding and running formulas/macros, and I currently use Active Data plugin and it works. I need to automate this process (using ActiveData) or something else so I don't ...
  • Hourly – Less than 1 week – 10-30 hrs/week – Posted
    Create PowerPivot data model, calculated columns and associated pivots in alignment with the attached requirements and sample layout docs. I hope to leverage this small project to identify a great resource for near term data aggregation and Excel project work. Please prepare an estimate of hours required, projected start date, desired hourly rate and examples of recent experience. Combination of Excel, DAX and VBA skills desired. Also, looking for someone capable of operating independently with minimal oversight. This generally translates ...
  • Fixed-Price – Est. Budget: $5.00 Posted
    http://i.imgur.com/clPlQrc.png As you can see on picture above we have "how long the article is online" in column A and profits in column B, in column C we need the following: For column C, It should first calculate what is the average $ for that many days online (based on data from all others) and then show how many % above/below average specific line is performing. Formula will be used in google docs not MS excel.
  • Fixed-Price – Est. Budget: $100.00 Posted
    I need an add in which will do the following: It will provide a settings panel where the user will define different regular expression patterns. It doesn't have to be too sophisticated, it should allow for a description to be associated with it. See http://goo.gl/MktIqZ . The UI can be simpler, we could do regex followed by a commenting character and then the description. Running the add-in should go through the document and stop at each match ...
  • Hourly – Less than 1 month – Less than 10 hrs/week – Posted
    Hi I need hourly assistance finishing queries to group and count rule types. I need a professional at substrings, counts, stored procs, group by, distinct counts, 1 and 0 counts on distinct groups report on data with stats and most used rankings Please provide an example of your work and begin your cover letter with @SQL_JOB to prove you are not copy and pasting. The job is hourly, and will be in blocks of 2 hours of work. Thank you ...
  • Hourly – Less than 1 month – Less than 10 hrs/week – Posted
    Hello, We have a few monitoring tools that were written in VB6. These tools are no longer supported in newer Windows platforms and need to be upgraded to .Net. We used PDQ Communication library that might not be supported in .Net. Therefore, comm/modem/serial communication knowledge in Visual studio is required. Regards,
  • Hourly – Less than 1 week – Less than 10 hrs/week – Posted
    Hi there, I have a data spreadsheet with "broken" mobile numbers that I want to fix, some of them are missing the area code, all of them are from the same country. I"m searching for someone that know how to write macros in VB to get the best result and fix most of the mobile numbers from the data file. I want it as a macro, to fix more files on the same structure. Thank you.
  • Fixed-Price – Est. Budget: $10.00 Posted
    I need this quickly I need a excel tool ( grab data from a website automatically ) I need these pages to be uploaded by clicking on a button on excel https://www.gw2spidy.com/ I want the pages on the Items tab section at the top of the website ( armor / back / bag etc the last one being weapon in the last for a total of 14 sheets ) So I want each section to have its on sheet in the excel file ...