Vba|cprogrammingvisualbasiclavori
pure vba / selenium code cheap copy paste people, don't apply
My experience has been search for solutions and then "reverse engineer" the code to fit my needs. I stumble when it comes to For/Next looping and Lookup Table manipulation. My Workbook has two main worksheets - Master and NameLU. A person's first name can be variable. I want to have VBA which will do the lookup for a match between the Master and Lookup tables, duplicate the Master table record up to 5 times depending on a count in the Lookup table, and then replace the first name with a variation. E.g.: RICHARD could also be known as Rich, Dick, Ricky, or Rick. I would like the additional 4 name variations, and the result appended to the Master table. The Master table may have 300-1000 records to loop through. I am attaching a more visual explanation.
I have more than 40 excel files and there are many duplicates. What I need is just remove the duplicates from all files and create one excel with unique data. Note: In some excel file duplicate phone... (Budget: $250 - $750 USD, Jobs: Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps)
I want excel cam for loan process with criteria as per norms required as soon as possible
Several VBA codes required for Excel which mail merges into Word. Part of this project is to code so that the mail merge is possible from a shared onedrive. Specific VBA coding required to enable to operation.
develop vba/ selenium code to swap cookies in chrome
>Registrati o accedi per visualizzare i dettagli.
I am hoping you can help. We can discuss any details over chat.
I require a an excel template which will act as an inventory management system. Each item will be assigned an SKU and a Batch number which is in line with our FIFO (first in first out). I have prepared the skeleton of the excel but require someone with excel expertise to advice on the right formula or vba code to use.
We would like our project to be written in Visual Basic that can be run as a macro in Excel as opposed to a separate Executable program that needs to be run outside of Excel. We have an excel workbook with two worksheets. Sheet 1 is Call List and sheet 2 is our database. We need to populate the Call List sheet (sheet1) with the data from our database (sheet2).If the PostedByName column and Company column in both sheets have matching data, then import columns A, B, C, D from Database (Sheet2) into Call List (Sheet1). CALL LIST (Sheet1)formatting instructions for worksheet1 (Call List): 1) Insert a blank column for A, B, C, D, and E 2) title the new columns "Direct", "HQ", "Mob...
Hi Roberto C., I noticed your profile and would like to offer you my project. We can discuss any details over chat. It an excel file, that make a calculation about vehicle routing, but is made with Microsoft Bing Maps, and I´d like change it to Google Maps. Basically, it must get latitude and long, coordinates, make distance calculation, and when problem is resolved and VBA Code make route, plot and image with route in excel.. Can you make it? Thanks
I need help with a quick excel VBA/Macro/conditional formatting on a worksheet. Whatever method works is fine by me. I typically prefer VBA but not opposed to other methods. I will attach the excel document here. It is a checklist. If you click on the drop-down button, it highlights the weekends in Row 3. This is working fine. However, in the task portion of the sheet the blue cells are not lining up with Row 3. Can someone help us with this?
...en Amazon y necesito automatizar toda la información que proporciona Amazon para mis productos y los de la competencia. También hay mucha información que se obtiene directamente de hacer scrapping de la pagina de resultados para una búsqueda u otras paginas o reportes online de Amazon. Es necesario que la gestión de los datos se realice con Excel y VBA. Buena parte del trabajo está parcialmente desarrollado y hay que completarlo con Excel y VBA e integrarlo. - Gestión del catálogo y composición - Gestion de inventario y almacén de los productos y componentes, y alertas de rehabastecimiento. - Gestión y Análisis de costes de mis productos, tarifas de FBA y almacén. Incorporació...
>Registrati o accedi per visualizzare i dettagli.
Build DST to evaluate the current adoption of certain technologies and AI applications in construction projects.
I have an excel file with VBA code that needs to be converted to Google Apps Script and debugged to run in Goggle Sheets
Background: I manage e-commerce stores that are connected via stripe and each month i download the data from stripe and filter the payments according to the relevant store. Then i use that information to deduct my fees and pay the remainder sum to the store partner. Goal: Macro dashboard where i can do these tasks efficently each month and have the apporiate documents created and shared. Regards
Hi I have a growing consultancy that needs a hands-on I.T. PM to join the team and take the workload away from my day. We typically execute asp.net projects, some PHP projects and also excel VBA work. I have external workers in India for asp.net and PHP and I do the VBA work myself but I also need a VBA worker to take that way from me. we typically use Trello for our task flow. You will be taking tasks off me (that I receive from clients) that I create in Trello. You will then manage that card and/or evolve it into a coder-facing spec (as I may pass to you in a business-facing spec). You will then track the task execution and signoff either by evaluating/testing yourself or will add a tester to the team. This role will be +- 10-20 hours per week to start but will grow....
Need a VBA based macro which can remove invalid extensions or symbols from strings from whole column
This task must be submitted before the 18th of November. About "A Product Mix Application". There is a description of how to do it and there are answers on the Internet. But you need to change the data. For the place of furniture, change to PC components and change the prices for them. I just don't understand VBA and I can't figure out what I'm doing right or not.
i need to extract data from note pads, i have about 2000 files with names, phone, and some counts and i need to extract this to excel file, and each line will be in separate coloum I need it now, if you are an expert and know vba codes very well, then please post your id
The initial situation of the project is the following: Currently there is 39 sheets in the...Excel file Each sheet is using some of the data from the previous sheets to make analysis, but not all of the data is used, some is unnecessary. I know that after the 16th sheets all the data is correct. So the first 16 sheets are the one to modified; you only need to removed the cases that are in the first 16 sheets and not used in the following 23. So you need to Create an R markdown script (or VBA script using Excel macro) that will scan and simplify the Excel document so that the unnecessary and unused data are removed from the Excel file. The Output is an R database with a markdown script and an Excel file. Please contact me directly if you can do it as I receive a lot of unwanted b...
I need a VBA parser to extract information from a website that requires a login (but I have access to the website)
I want a excel micro to perform some basic mathematical operations on a table
Hi Team, I am looking for some one who can help me to automate simple pivot / monthly reports in excel. Also who can help me with the data science projects.
Hi, we are a small law firm representing condominium and homeowners' associations and we primarily handle collections for delinquent accounts. This involves sending "30-day notices" to property owners, a subsequent "10-day final notice" letter...Currently, we have to manually input a calendar reminder into Outlook for both the 10-day notice and the subsequent complaint. We want to automate this process so that when one of us creates a calendar event for the 10-day reminder it automatically creates the "complaint" reminder 10 days later and sends notifications to the rest of our firm (3-4 people). From my research, this seems possible via VBA macros either in Outlook or Excel but I don't have a firm enough understanding of VB nor the time to te...
Microsoft Access Expert Required with selenium scraping experience
I am writing a QMS system for a 1 man start up engineering business in MS Access. I need support and guidance on macros, vba and event procedures
Transform the raw data (csv) to excel specific format
Excel expert in finalizing the budget excel file automizing and creating superb dashboard using power query VBA , macros and providing the documentative illustration
looking guys who expert in Excel VBA i have small task for you
looking guys who expert in Excel VBA i have small task for you
Project requirements 1) create front-end interface for data entry based upon our specifications 2) drag and drop to add files (and ability to view files within the program) 3) ability to create new folder on desktop, auto rename and save the added files to newly created folder 4) format entered data for user to copy/paste into another excel sheet 5) Generate 3 excel files based upon entered data (data must be appended to template files) 6) Open up outlook, attach the generated 3 excel files in a draft email
I need the excel vba coder for multiple jobs. Details will be discussed
I am looking for someone to help automate a worksheet template that I am using. The attached sheet is an example fo the template I am using. My template uses a simple formula to identify keywords or phrases chosen from a string, and then assign that keyword to the row in which it's found under a column. I then use (replace all) to remove the identified string from a copy of the original string, this is represented in column C or the attached sheet. This string needs to have the identified keywords or phrases removed in the order that they are removed This has to be removed in order since phrases like "for DWV" are not the same as "DWV" and must be identified separately. need the sheet to work as a template where I can paste in new SKU's and descriptions a...
Teach advanced excel skills: Statistical Modeling Forecasting and Prediction Pivot Tables VBA and Macros Vlook up And formulas: Sumif; iferror; conditional formatting;count if ; etc All excel tabs and other functionalities
Hello Barry, Here is the quotation for the Excel Tools in VBA as we discussed. Thanks. Rashed
MS Access project Migration 2010 to MS Access 365/2019 including back end upgrading MS SQL 2014 to 2019 Must be highly skilled in MS Access / VBA / Migrations
Please check the attached file for explaination and better understanding
create macros to work with a huge amount of data and for Excel reports & automate repetitive tasks responsible for creating these macros and ensuring they work as intended developing new features or improving existing ones Maintains current and newly developed m...work with a huge amount of data and for Excel reports & automate repetitive tasks responsible for creating these macros and ensuring they work as intended developing new features or improving existing ones Maintains current and newly developed macro programs per user requirements. Develop VBA Programs to perform task Optimization of processes using Excel Establishment of cross program work flows Reviewing code to ensure best practices are in place TECHNICAL KNOWLEDGE: Strong working knowledge of: o Macro (VBA...
I am looking for someone to work on my Excel spreadsheet, also as attached. It involves doing the tasks as set out in the instructions document attached. I suspect work will be ongoing due to the nature of the job this spreadsheet will be assisting with.
Hi Mamuka B., I noticed your profile and would like to offer you my project. I need help with excel VBA in template
I already have a Quotation Tool developed by me in Excel + VBA creating Quotations and sending PDF quotations to selected e-mail addresses. It is working based on Databases which are updated manually, as from the corporate rules I'm not allowed to Read/Write directly from/to the ERP system. The tool is then constatly updated within users' laptops and the Company Server thanks to .bat file for syncronization. The tool is properly working, and it have been working for more than 5 years. I need an implementation to add some features to the existing system (i.e. main one is that I need to be able to act on multiple customers at the same time). I'm looking for a VBA Excel developer to put hands on the existing system, develop the required features and identify f...
Need VBA developer for small projects, should be from Pune , Maharashtra only
I need a price list creating in excel from the attached PDF price list. There are quite a lot of different parameters so VBA will probably be required. I would like an "input" page where the options are selected that show the retail price. I would like a read/write password protected page where I can input/update the prices in the future.
I need a macro coded so that I can update 20 powerpoint text fields with data I input into excel and so that it saves a new version of the file and a separate new pdf version. Should be a quick file for someone that knows VBA.
I am new here BUT, If you require any of the following for your SPREADSHEET: databases, pivot tables, charts and graphs, dashboards, complicated formulas, interdependent drop-down menus, straightforward VBA & Macros, or any other professional custom spreadsheets, Then look no further...
