Vba|cprogrammingvisualbasicprojekty
Task automation using macros and VBA Creating dynamic reports with PivotTables Building formulas Cell formatting Managing large datasets with functions: IF, SUM, INDEX, MATCH, VLOOKUP Task automation Manipulate date, time, text, and arrays Building charts and graphs Pivot tables and reporting Data recording VLOOKUP and XLOOKUP INDEX MATCH Advanced conditional formatting Data simulations Data validation Charts and graphs creation
Tengo una base de datos con en donde necesito calcular los tiempos transcurridos para una serie de registros. La base de datos esta compuesta por el ID, ESTADO y FECHA DE ESTADO. Necesito que cree una macro para que lea cada grupo de registros por ID y calcule los días laborales sin sábados, domingos y festivos que transcurrió entre los estados. Hay algunos estados que hacen que el tiempo pare y luego continue para cada grupo de registros. Necesito el trabajo urgente. Se darán mas detalles cuando se concrete para realizar el trabajo y que lo hagamos en linea.
I have a excel vba program to track daily walks, and I have entered data for more than 5 years. I need to have it modified to obtain 1. pdf reports 2. Date entry to be included in user form 3. customize to include name of the person 4. calories lost based weight 5. make it more colourful. Please note: freelancer can work on my desktop using remote control software. I will pay on fixed rate basis. Please provide sample vba excel program through chat so that i can give my program in the chat . please indicate how much you will charge so that time will not be wasted for both parties. File exchange will take place in the chat.
I will pay someone to do this I literally cannot do part 2 and 3. Due tomorrow night. Please help lol! Half the code is already created, we just need to fill in the blanks
I have a excel vba program to track daily walks, and I have entered data for more than 5 years. I need to have it modified to obtain 1. pdf reports 2. Date entry to be included in user form 3. customize to include name of the person 4. calories lost based weight 5. make it more colourful. Please note: freelancer can work on my desktop using remote control software. I will pay on fixed rate basis. Please provide sample vba excel program through chat so that i can give my program in the chat . please indicate how much you will charge so that time will not be wasted for both parties. File exchange will take place in the chat.
from sheet a i want copy a range from B26 to R160 then paste it on b sheet on specified range like D26 to T165 on time 9:15:00 then on 9:20:00 i want to copy B26 to R160 again and paste it on range D166 To T305 then on 9:25:00 i want to copy B26 to R160 again and paste it on range D306 to T445 and so on till 3:30:00
I have a excel vba program to track daily walks, and I have entered data for more than 5 years. I need to have it modified to obtain 1. pdf reports 2. Date entry to be included in user form 3. customize to include name of the person 4. calories lost based weight 5. make it more colourful. Please note: freelancer can work on my desktop using remote control software. I will pay on fixed rate basis. Please provide sample vba excel program through chat so that i can give my program in the chat . please indicate how much you will charge so that time will not be wasted for both parties. File exchange will take place in the chat.
I have a excel vba program to track daily walks, and I have entered data for more than 5 years. I need to have it modified to obtain 1. pdf reports 2. Date entry to be included in user form 3. customize to include name of the person 4. calories lost based weight 5. make it more colourful. Please note: freelancer can work on my desktop using remote control software. I will pay on fixed rate basis. Please provide sample vba excel program through chat so that i can give my program in the chat . please indicate how much you will charge so that time will not be wasted for both parties. File exchange will take place in the chat.
I have a excel vba program to track daily walks, and I have entered data for more than 5 years. I need to have it modified to obtain 1. pdf reports 2. Date entry to be included in user form 3. customize to include name of the person 4. calories lost based weight 5. make it more colourful. Please note: freelancer can work on my desktop using remote control software. I will pay on fixed rate basis. Please provide sample vba excel program through chat so that i can give my program in the chat . please indicate how much you will charge so that time will not be wasted for both parties. File exchange will take place in the chat.
I have a excel vba program to track daily walks, and I have entered data for more than 5 years. I need to have it modified to obtain 1. pdf reports 2. Date entry to be included in user form 3. customize to include name of the person 4. calories lost based weight 5. make it more colourful. Please note: freelancer can work on my desktop using remote control software. I will pay on fixed rate basis. Please provide sample vba excel program through chat so that i can give my program in the chat . please indicate how much you will charge so that time will not be wasted for both parties. File exchange will take place in the chat.
I have a excel vba program to track daily walks, and I have entered data for more than 5 years. I need to have it modified to obtain 1. pdf reports 2. Date entry to be included in user form 3. customize to include name of the person 4. calories lost based weight 5. make it more colourful. Please note: freelancer can work on my desktop using remote control software. I will pay on hourly basis. Please provide sample vba excel program through chat so that i can give my program in the chat . please indicate how much you will charge so that time will not be wasted for both parties. File exchange will take place in the chat.
Looking for a skilled developer to build a system using excel or python or similar language to help our ecommerce store with ordering inventory to reduce out of stock rate. System should provide the following: -System should prompt and provide information regarding how much inventory to order based on how much inventory we have -Using reports that we can im...following: -System should prompt and provide information regarding how much inventory to order based on how much inventory we have -Using reports that we can import into the system to prompt what to order based on 30 day sales volume (reports provide this information) -easy to use for our team to retrieve the needed information The developer must have: -Good communication skills -experience in excel VBA, python or similar...
I have a web scrapping project. scrape into Excel. Have you done scrapping ?it is sample make it Excel VBA and marcos.
I am looking for someone who has experience building macros in excel to help me build a simple model.
Create a VBA that pastes the text with destination formatting in few specific cells, A1, A2, A3, A4, A5, For example what ever is in the clipboard should be pasted text only in cell a1 when button is clicked first, When button is clicked again it should paste the data from clipboard in cell a2 and so forth.
Hello Sir, I have done your work according to your instructions please accept this milestone so I can deliver you the final work. Thanks. UMAIR
I have a data scraping project. Please read the attached Word document. I would like the Output to be an Excel spreadsheet, so VBA programming would be useful.
I am a working professional who is working in IT industry for 5 years. I need someone who can summarize my experiences with effective writing skills. I need my resume to be minimalistic and distinct among other resumes. I have worked as system support, VBA developer, Business anlayst and data analyst now. I am applying another data analyst job, so I need someone who can elaborate effectively about my experiences. I am open to make a zoom call to share my working experiences. I can send out my rouge resume if the deal is made.
I want some one to recreate pages from a VBA database into a spreadsheet, no functionality required on the spreadsheet.
This project requires to create a model in EXCEL VBA using macros and code to develop a user interface that will perform all the tasks as stated in the document attached here. The project is a beta test for this use of Macros in Excel. The main goal is to use simple coding and structures that will allow people that is not familiar or expert with MACROS or EXCEL VBA to learn how to implement this tools. So, the code should be easy to understand and follow, there should not be over complication or if possible use of coding that will require expert or advance knowledge to learn about this. All the details about the project requirements itself are in the attached document and an excel file will be provided to use as a base and guide for testing that it meets all requirements and ...
Hi Paris Pallas, I noticed your profile and would like to offer you my project. We can discuss any details over chat.
I have a VBA project. If anyone is available please let me know. Thank you
Update annual excel spreadsheets for 2023, improve macros and code, and change to power query. Existing spreadsheets need updating, VBA code needs improvement, some changes to the layout and format for 3 files
It's about to duplicate some functions that are already coded on the application, in order to cutomize it according to our need (please see vba interface of the attached files to understand what is needed)
I would like to improve on the Excel spreadsheet attached and turn it into an excel vba database OR sql/microsoft app whatever you advise, have a dashboard summary and be able to generate reports. Want to completely rebuild it to some sort of project management system
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
Proszę, Zarejestruj się lub Zaloguj, żeby zobaczyć szczegóły.
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?
