I would like to improve on the Excel spreadsheet attached and turn it into an excel vba database, have a dashboard summary and be able to generate reports. Want to completely rebuild it to some sort of project management system
looking for a vba expert for a small project
...who is well versed with Excel VBA and is willing to work on a hourly basis. To clarify, Freelancer must to be comfortable to be working on hourly basis. This requirement is primarily due to the fact that the edit/updates needs to be done constantly on the existing codes. Awarding Fixed Projects to different freelancers is time consuming and not worthwhile. Someone who knows the code and its functionality will have a much easier time making changes. The work is divided into 2 parts. 1. We have existing macro’s that needs updating monthly. We will be giving them the data based on which the macro will need to be updated. 2. New macros that need to be made. The work will be around 8-16 hours a month. If interested, please share some of your prior work on VBA, and yo...
I need a vba function to be added as a module in excel. The function has to delete all tags in a text in a cell i.e: it will delete angle brakets and everything in between.
Hi I am looking for Excel VBA programming expert. Needed data management, reconciliation from excel sheets. Thank you
Just remove all the VBA password of this sheet - I wan to be able to acess the Macros coding and make some modifications to it
More details will be given to the right candidate. IMPORTANT NOTE Project needs to done in EXCEL VBA only - NO PYTHON or any other tools. Only qualified VBA excel queries need to apply. Qualified will be shown the manual process that I used daily to extract the average odds (1x2) via team viewer. Please do not persuade me to use any other tools as I rather stay manual (1min of my time per match) To update everyone there I had paid someone here for a PYTHON script and it is not working as promise. DO NOT ATTEMPT TO TRY TO CHANGE MY MIND, I will share my excel spreadsheet with the right candidate.
hi we have an xls with product data that we need to feed into our MySQL db using adodb. you need to be used to working with adodb recordsets and inserts and good with vba will be +- 10-15 hours work but we have ongoing tasks like this and other excel vba stuff.
Our vendors are sending us data feeds with missing information like title, description and images, only thing we have that is present is part number and EAN/barcodes. I have a lot of product data missing. We need a tool that can import the file, check the file and find the missing data such as titles, descriptions and also images and to add the images to shopify image storage and add the ...missing. We need a tool that can import the file, check the file and find the missing data such as titles, descriptions and also images and to add the images to shopify image storage and add the image links to the missing fields I also need google merchant errors fixing and this tool should be able to fix them too. THIS IS NOT A DATA ENTRY TASK! SKILLS - Python, PHP, Scripting, shell, excel, VBA...
you are required to create Excel VBA Macros that have forward compatibility starting from Excel 2016. ------------------------------------------------------------------------------------------------------------------------------------ -you must have knowledge on advanced algorithms to know how to deal with Very Big number of rows of data efficiently (search and sort algorithms) -you must be able to import csv, tsv, xlsx files from local device to the main excel workbook -you must be able to export excel files into csv, tsv, xlsx files and move them on local device -you must be able to manipulate excel data in an efficient way using a mix of both macros and functions -You are required to write clean code and provide comments to illustrate what does your code do, a video illustrating ...
We are a manpower company. We would like to use VBA excel to generate Account Statement for our Client and part-time worker. Based on our part-time worker's services hour.
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
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", &q...
I have a VPC in North Virginia. I would like to deploy an AWS EC2 windows instance in london and use the VPC from North Virginia. I need an AWS cloud expert.
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ó...
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 attached 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...
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...
