Vba Jobs

225 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: $35 - Posted
i have 2 different databases then i need a script to update some columns (input quantity given by me) in BOOK A taking information from BOOK B, the script have to go to BOOK B and by searching their corresponding value (same value) into rows in a specific column, take some values from that specific ROW to update their corresponding in BOOK A, the script have to have the option to select an option of writing the search results... and if value is not found into BOOK B then write in specific column in BOOK A "NO" and if was found then "SI". i have attached 2 books to make an example as exercise: BOOK A (in this book database information starts from ROW 7) COL G (availibility) COL W (price) COL AK (SKU) COL AM (description) COL AN (brand) BOOK B (in this book database information starts from ROW 11) COL B (SKU) COL D (description) COL F (brand) COL G (price) quantity of columns to be updated: X (for the last situation X=3) write search results?: yes or not. {​if yes column where to write?}​ col_searchresults in book A from which row starts the database?: row_starts_book_A in book B from which row starts the database?: row_starts_book_B in book A what is the column, where values where be taking to search in Book B: col_A in book B whats is the column where the script would be searching? col_B depending of X value then ask for their corresponding columns to be updated, for example for the last situation X=3 then: BOOK A BOOK B col 1 W G (price) col 2 AM D (description) col 3 AN F (brand) after this information given then the scripts starts running a bucle with a searching event starting from book A column: (col_A); row (row_starts_book_A) and searching that cell value into BOOK B column (col_B); for all their rows starting from row (row_starts_book_B) if not found and write search results option is marked as yes then write in their actual bucle position row in BOOK A, column: (col_searchresults): "NO" if found write "SI" and update in BOOK A their corresponding columns values. book A: https://www.dropbox.com/s/9ecnaf1pk92h897/LibroA.xlsx?dl=0 book B: https://www.dropbox.com/s/r2h3sa8qk5evdhv/libro%20B.XLSX?dl=0
Skills: Excel VBA Microsoft Excel VBA
Fixed-Price - Expert ($$$) - Est. Budget: $500 - Posted
I need a great MS WORD DOCUMENT Specialist who can help me create a fillable form as an MS WORD DOCUMENT as a TEMPLATE. This will / may have features of QUICK PARTS, AUTOTEXT and FILLABLE forms to go to PDF as well. I need this to be a CHECKLIST, TABLE OF CONTENTS, and OUTLINE which also has GRAPHICS that the user will check. I also will have something similar to THE FILE IN EXCEL BUT NOTE THIS WILL BE A WORD DOCUMENT. I need this to have the ability to have DROP DOWNS And RADIO buttons. THIS IS A FIXED COST PROJECT. BUT I WILL HAVE SEVERAL UPCOMING . MUST KNOW DOCUMENT LEVEL MS WORD CUSTOMIZATIONS I'm also seeking for this person to be proficient in ENGLISH. ITS MANDATORY.
Skills: Excel VBA Microsoft Word PDF Conversion
Hourly - Intermediate ($$) - Est. Time: 3 to 6 months, 10-30 hrs/week - Posted
Looking for an experienced data analyst with proficiency in Tableau, data analytics and business intelligence to create visualisations based on a set of pre-defined KPIs and a Tableau dashboard from spatial in-store and consumer data. Start date: asap​ Length 2 months​ Advanced data analysis (linear regression) and Tableau skills are necessary. Predictive modelling skills are a big plus.
Skills: VBA Business intelligence Data Analytics R
Fixed-Price - Intermediate ($$) - Est. Budget: $100 - Posted
We use attached sheet for registering tasks. our file contains about 100.000 records, and we would like the data moved to a database. It should be possible to load records to the sheet based on the parameters in the top. Also it should be possible to save changes made to the records. All by using the update button.
Skills: Excel VBA SQL