Vba Jobs

198 were found based on your criteria {{ paging.total|number:0 }} were found based on your criteria

show all
  • Hourly ({{ jobTypeController.getFacetCount("0")|number:0}})
  • Fixed Price ({{ jobTypeController.getFacetCount("1")|number:0}})
Hourly - Intermediate ($$) - Est. Time: 1 to 3 months, 10-30 hrs/week - Posted
We have a Google Doc folder that needs to be consolidated into a more manageable single excel file with more capability. Right now there are several data points manually copied over and over again and it is prone to error. We need something that auto updates and fills in columns and rows as the other sheets gets populated. We also need a dashboard that shows when the inner files have been completed (which are being worked on by other UpWork contractors). The things that we will need the Excel system to do: - Consolidate all Google Doc individual files into one or two large spreadsheets that uses pivot tables and macros - Update and save automatically across multiple computers (via dropbox is okay) with each addition - Update across multiple excel files when the same data point is changed - Have the flexible structure to allow for adding or removing components next year if categories change - Dashboard that summarized the progress of all of the sheets I will distribute the Google Doc files once we you are invited for you to look at how the organization of the excel sheet should be done. We have all the specifications and designs, just not how they should best be made into a single file.
Skills: Excel VBA Google Spreadsheets Microsoft Excel
Fixed-Price - Intermediate ($$) - Est. Budget: $400 - Posted
I am looking for development of a script that outputs permutations of players based on inputs provided (e.g. player, salary, etc) and conditions (total max_salary = 50000, etc). I have a working sample of version 1.0 and need some modifications. I am also open to doing it an entirely different way based on recommendations (e.g. SQL via AWS, etc). The current script is an Excel Spreadsheet using VB macros. I have attached requirements, along with sample version 1.0 (full working example - just run macro), and version 2.0 (added sheets and columns but macro has not yet been modified to support additional variables and columns).
Skills: VBA SQL
Hourly - Intermediate ($$) - Est. Time: More than 6 months, 10-30 hrs/week - Posted
Looking for Data Scientist having extensive experience with statistics, Machine Learning and Predictive Modeling Techniques using tools like SAS/R/MS-EXCEL and willing to train learners during weekends. Job Responsibilities: - Design Course curriculum. - Prepare ppts/pdfs and study material for each class. - Arrange real life data sets for students to practice. - Clear all the Doubt session. Send me the proposal with expected charges.
Skills: Excel VBA Data Analytics Data Modeling Data Science
Fixed-Price - Entry Level ($) - Est. Budget: $50 - Posted
We have images with a company name and membership number on it. To operate in MSaccess 2010, we require a function written e.g. extract_member_details(StrFilename, ret_memberNumber, ret_membername) which can be called from our existing modules. It will extract the member number and member name from the supplied file. We can provide the file in any of the following formats (using WIA):- wiaFormatBMP wiaFormatPNG wiaFormatGIF wiaFormatJPEG wiaFormatTIFF If it is simpler for you, we can crop these images and provide two files just containing (1) the member name and (2) the member number - and run the function twice (or have two functions). If it is easier to only read the number, then provide two prices, one for reading an image file containing just the number as well as doing both. If possible code must be licence free.
Skills: VBA OCR Tesseract
Fixed-Price - Intermediate ($$) - Est. Budget: $1,000 - Posted
Hi there, I am looking for a developer that can convert data / information in WORD EXCEL NOTEPAD into a designated template which is in excel file. That output excel file has pre-defined tables and the input files are going to be either a word, excel or a notepad. The info / data in these files is somewhat in a format which a developer could interpret. We need this to be the input and the out put file should then be generated from it into an excel sheet. one thing to consider is that data retention should exist hence if a db is required; our requirement is of MS SQL Express. Please get in touch with me if you are interested and we can take this discussion further. Yours truly, Zohaib
Skills: VBA Data mining SQL
Fixed-Price - Entry Level ($) - Est. Budget: $15 - Posted
I need in a excel form formula's inserted so those field automatically does the job. I will provide you with form and tell which field type of formula i need. will be between 4-5 formulas Any questions please ask.
Skills: Excel VBA Microsoft Excel
Fixed-Price - Intermediate ($$) - Est. Budget: $5 - Posted
Hi all, i am looking for someone who can replicate a relatively simple CRM system to be seen on a youtube video and add a few features as well. It should contain: - Some spread sheets that capture contact details/leads with current status - a dashboard with some statistics on the number of leads/contacts/how many leads to follow up on the day, sales target with percentage achieved to date etc. with some visualization - a flexible timing function as to when to follow up next - days when a contact was last touched - A form that makes it easier to add contacts - possibly buttons to move leads through the stages Please let me know your availability and how much effort you think this is (ballpark estimate). Looking forward to working with you.
Skills: Excel VBA CRM Microsoft Excel Spreadsheets