Vba Jobs

262 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}})
Fixed-Price - Intermediate ($$) - Est. Budget: $500 - Posted
Looking for experienced developer to build a script to transform Excel outputs to Powerpoint presentations using VBA. Project also includes VBA to transform Excel so it is able to be exported to Powerpoint.
Skills: VBA Microsoft Office
Fixed-Price - Intermediate ($$) - Est. Budget: $100 - Posted
Background: We previously hired someone on Upwork to fix our database. The person we previously hired was unable to continue working for us, so we have a half completed project. We have a large e-commerce product database that we are working on building new SKUs for. Previously, identical styles were named with varying names. For example, the shoe named “New Balance 777” might be named 1. New Balance 777 2. 777 NB 3. 777 New Balance This was our biggest problem in joining these different style names into one SKU. I have done the work of making a excel file with each of these names next to what it SHOULD be, (“New Balance 777”), which is how it is in Product/Style Information sheet. One column consists of the old style names, and the column next to it has the new style names (all represented in the Product Data sheet). 1. Raw Data Sheet 2. Product/Style Information 3. Style Numbers and Color Numbers 4. Old Style Names/New Style names (This sheet will be eliminated) 1. Raw Data Sheet Contains all of our data on the Linnworks software. This is all of our ecommerce data. 2. Product/Style Information Each style is a unique row with its own data. This sheet will merge into sheet #1. 3. Style Numbers and Color Numbers Each unique style name in sheet #2 & sheet #1 (should be identical) is given a number. 4. Old Style Names/New Style Name This sheet contains all of the names from the original data that we want to replace with our new data. ————————————————————————— The end goal of this project was to restructure our SKUs based on style name. Our expectations are to have these three sheets work in unison, allow for the modification of style data (sheet #2) which will then be placed into the primary data sheet (sheet #1). Much of this work is already done — the formulas, SKUs, and so forth. We need someone to clean up our Excel file, ensure that the style names are registered to unique values, reduce loading time for calculations (if possible), and to finish this project. I would estimate that over 75% of this project is already completed. Upon completion of this work we have a project that directly involves this exact data. The next step of this project is to upload this file to Linnworks, our inventory database system. I look forward to speaking with you and potentially working together.
Skills: Excel VBA Microsoft Excel
Fixed-Price - Expert ($$$) - Est. Budget: $2,000 - Posted
Triple Q Questions is a privately owned business that supplies scholar bowl questions to schools. We provide customized sets of questions in various formats to meet the needs of individual competitions. We wish to update and improve our database so that we can provide better service to our customers and keep our materials up to date. The current database contains over 40,000 questions that are categorized according to both grade level and subject. The questions may be elementary, junior varsity, or varsity level. Each question is categorized according to 5 main subject areas – math, science, social science, literature/language arts, and potpourri. Within each subject area, there are multiple subcategories. For example, a math question may be classified as algebra, general math, geometry, calculus, trigonometry, or statistics. Each subject has multiple subcategories. When an order is received, a list of the schools that will use the questions is input into the database and “selected” to indicate that these schools are the ones you will be working with. The database is supposed to automatically lock out any questions the schools have previously had so that no school will receive the same question for a period of five years. It is also supposed to allow us to indicate that we need 5 various math questions, 3 American history questions, 2 government questions, etc. However, this function of our database has failed. We can “pull” a group of questions, but cannot assign what type of questions we need. Once a packet of questions is generated, it needs to be “labeled” so that it can be retrieved at a later date. Currently, each packet is assigned a packet number. What we need is to develop a new database that will allow us to continue to generate custom question sets in a more timely matter and that will give us the ability to search both the questions and the answers using key words so that we do not end up with duplicate questions in the database. Listed below is some general information concerning this project. Question Levels Elementary – grades 4-6 Junior Varsity – grades 7-9 Varsity – grades 10-12 Question Types Tossup questions – single answer questions Bonus questions – multiple part questions (may be two, three, four, or five parts) Rapid fire questions – 11 part short answer questions Worksheets – 20 short answer questions Subjects and subcategories Math – General math, Algebra, Geometry, Calculus, Statistics, Trigonometry Science – Anatomy, Astronomy, Biology, Botany, Chemistry, Computer Science, Earth Science, Physics Social Science – American History, Ancient History, Current Events, Government, US Geography, World Geography, World History Literature/Language Arts – Drama, Grammar, Languages, Literature, Novels, Poetry, Short Stories, Spelling, Vocabulary Potpourri – Anthropology, Art, Cinema, Dance, Education, General Knowledge, Logic, Music, Mythology, Philosophy, Psychology, Religion/Bible, Sociology, Sports/Games, Television, Theater, Vocational Schools School name with town and city (street address when available) Possible improvements to the database Some schools require bonus questions with a specific number of parts. Currently, there is no way to use 2 parts of a 4-part question and save the other two parts for later use by that school. Need to be able to generate questions by subject. Some schools will order 200 current events questions or 150 math questions. Customization is a large part of our business. If a customer wants 25 tossup questions with 25 bonus questions, and they want each bonus question to follow the tossup question, we currently have to cut and paste. It would be nice if the database could generate this format. Sometimes a school will want 50 single answer questions, but every other one is labeled as a bonus question. It would be nice if this format could be incorporated into the database. When a set of questions is generated, it needs to be in Word format with our heading on it.
Skills: VBA C# C++ FoxPro Administration
Hourly - Intermediate ($$) - Est. Time: Less than 1 month, Less than 10 hrs/week - Posted
Want to qualify chart in Excel. (We will convert it to php) The calculator will be located in the existing site. Which allows surfers to get an estimate for their business. Need help from professionals who did such a thing in the past. Only examples that work - will answer reference
Skills: Excel VBA Business Coaching Business Development Business Management
Hourly - Expert ($$$) - Est. Time: Less than 1 month, Less than 10 hrs/week - Posted
text file to PDF conversion without impact to text file layout/spacing. Currently we have VB exe files that performs this function, we would like to enhance and make some changes to VB codes and need someone who is expert at text file to PDF conversion using VB language. Thanks, Shuja
Skills: Excel VBA PDF Conversion VBA VBScript
Hourly - Intermediate ($$) - Est. Time: More than 6 months, 10-30 hrs/week - Posted
We're looking to bring on a very capable "Excel Pro" that can very easily groom, improve, build out, and create tools for us to manage our growing business. These projects will be a mix of financial tools and operational tools that deals with customer demand, customer analytics, and inventory and cash flow. You should also be able to help out on relatively short notice on urgent presentation materials for investors and stakeholders. This means knowing the visual capabilities of excel as well as it's functional capabilities.
Skills: Excel VBA Microsoft Excel
Hourly - Entry Level ($) - Est. Time: More than 6 months, 10-30 hrs/week - Posted
As a Data Operations Specialist, you will be responsible for data transcription and data migration. Working with both our San Franciscan and Slovenian teams, you will take the lead on data extraction, transformation and migration. You will become the expert of our product from the point of view of our customers, allowing you to develop a deep understanding of customer use cases and pain points to share with the team. This position is based in the United States or in Slovenia. You will: -Manage data migration efforts from customer legacy systems to our import templates and collaborate with GRC (Governance, Risk and Compliance) experts when new use cases arise -Work alongside Customer Success Managers to ensure timely delivery of customer requests -Create and document processes/scripts to optimize data migrationPerform quality assurance self-reviews of migrated data to ensure accuracy and integrity -Maintain knowledge of new ZenGRC feature releases to optimize data migration -Perform a diverse range of ad hoc projects to create and maintain content within ZenGRC -Analyze data migration systems to ensure the processes are fully streamlined
Skills: Excel VBA Auditing Data Entry Google Apps
Hourly - Intermediate ($$) - Est. Time: Less than 1 week, Less than 10 hrs/week - Posted
hi there 1 i have been using Access 97 based for last ten years with basic functionality. It worked fine till now when i am forced to upgrade operating system from Xp to Win 8.1 pls look at them and upgrade them to Access 2007 version and add user log in security functionality. 2 i am quite comfortable using access 97 so is it possible to develop some inventory control & order booking pgm based on this Regards Ajay Aggarwal
Skills: VBA