Macros vba jobs
I have Greyhound Racing data for many tracks in separate sheets per year, these being 2018 all the way through to 2023. I need this separated into individual sheets per track for UK, Australian and New Zealand venues. I attach an example for UK venue Crayford, a list of the tracks/abbreviat...separate sheets per year, these being 2018 all the way through to 2023. I need this separated into individual sheets per track for UK, Australian and New Zealand venues. I attach an example for UK venue Crayford, a list of the tracks/abbreviation and also a sample of the 2023 data, the other years files are over 25MB so cannot attach. This is a simple copy and paste exercise mainly but someone with VBA skills may be able to automate it quickly. There will be possible 70 sheets required a...
I want a Excel based or standalone program. This requires users to login and fill out the form with approximately 50 set of questions. I have attached the blank form that includes the set of questions. The users will use this form to make entries and want them to use the same to update the data already available on database. The only major point is that the database has to be save either on SharePoint or OneDrive with Realtime linked Excel file to see the entire data, and almost 20 users will use the tool at the same time. Please be advised that this is not a data entry project. This requires programming knowledge.
I am looking for someone to help me get my Excel document in order. The content of the document is complete, however the format is all over the place. No VBA Script please. The document has around 19 pages + 1 Index Page. I must be able to create new pages from the existing pages and yet retain the functionalities as described The Index page is fine except for trying to fit in the company logo onto it. Note: <<MyCompanyName>>, <<ProjectName>>, <<Job Number>>, <<Client>> are used in other pages. Key objective of the formatting on all pages except Index Page are as follows: 1. Have a Standard Header 2. Width to fit on single A4 sheet. You are welcome to propose either portrait/landscape orientation, however this must be consistent th...
I am looking for an experienced freelancer to build an Google Sheet based on Excel and macro. Script must save the google sheet with a new name and export a .csv file. File attach is excel Experience with Excel, macros, and Google Sheets will be essential for this project. The successful freelancer should have skills in Excel, VBA Macros, and working with Google Sheets. They should have experience converting data from an Excel format to a Google Sheets format, and be able to provide a demonstrated history of successful conversion projects.
I am looking for help with correcting an Excel VBA macro that I have already created. Specifically, I need help with the output. I am also looking for assistance in debugging the code. If you have any experience with Excel VBA macros, please feel free to respond to this project.
I need a Vba code for cylinder heating. I am looking for an experienced programmer with expertise in Visual Basic for Applications (VBA) to create a system for cylinder heating. Thanks I NEED IT URGENTLY CAN YOU DO IT PLEASE LET ME KNOW.
I am looking for an experienced and knowledgeable freelancer to create a macro using VBA language, which will be used in Word. The macro should be able to make all bolded text into the table of contents. The macro must be highly efficient and work reliably; I am looking for someone who has a proven track record with these types of projects and can get it done quickly. If you think you have the skills and experience necessary to complete this project, please get in touch. I look forward to receiving your proposals! I'm only will to pay $40 so if that is not in your budget, please don't apply.
I am looking for an experienced programmer with expertise in Visual Basic for Applications (VBA) to create a system for cylinder heating. This code must be able to receive and process user input, as well as present data visually. The deliverable must showcase your proficiency with VBA and should be of the highest quality. If you feel that you are up to the task and possess the necessary qualifications, I welcome you to submit a bid.
I am looking for an experienced Excel professional to help with data entry, data validation, VBA & macro development. The data entry will be a mixed format, requiring manual and automated input. The data will also need to be validated according to an established date range. Additionally, I would need assistance in designing macros to help automate job tasks. If you have experience in these areas and are interested in this project, please don’t hesitate to reach out!
I am looking to hire a freelancer to help me with a VBA Project. The main purpose of this project is automation, so I will be providing the parameters. Specifically, the data to be automated will be coded data. I am looking for an experienced professional with a solid background in VBA programming. It is important to me that the data is accurately and efficiently automated in accordance with my specifications. The freelancer should also possess excellent problem-solving and communication skills. I expect to provide detailed feedback when necessary during the course of the project. I look forward to working with an expert VBA programmer who can help me achieve my goals. If you have the necessary skills and experience, please get in touch with me.
Edit data csv file data by removeing some rows and shifting previouse data to cover where the deleted rows exsisted then update the files csv with this new data whenever a condition is met example when rows exceed a certain amount
I need to automate an excel using macros and vba
The attached Excel VBA code works great on rows 2 thru 45. How can I rewrite it to only include rows "2:5,10:13,18:21,26:29,34:37,42:45" ? Should be a quick and simple project for someone.
I have a file, wrote a macro and it keeps erroring out and not performing like i need it to. it gives me a subscript out of range error or object out range error. I need someone to help me get it figured out and i am hoping to resolve this in the next hour. see attached file.
I have a file, wrote a macro and it keeps erroring out and not performing like i need it to. it gives me a subscript out of range error or object out range error. I need someone to help me get it figured out and i am hoping to resolve this in the next hour. see attached file.
Excel VBA macro Fixing task. Only bid if you can start right away. Need to get it done in next 2 hours max.
Hi, I am attaching a sample excel file. I want some Excel macro developer to create macros to create following report I shud be able to filter (drop down) based on 3 fields Last X days “Email” (marked in yellow) “Resourcing stage” (marked in yellow) All above 3 filters are not AND but i shud be able to filter based on any of the condition to COUNT the number of cases. If one “Email id of the candidate (Email id)”( marked in blue) is repeated then take the highest count of resourcing stage and club all for same “Email id of the candidate (Email id)” Happy to clarify about the project. If you are interested in this project then please provide following. BLIND BIDS WITHOUT BELOW INFORMATION WILL NOT BE SHORTLISTED No of approximate ma...
i need some minor coding done/button created in excel file. 3 tasks if you know VBA and Excel well, it will take you under half an hour. thanks
We are looking for an Microsoft VBA expert capable of making macros that would automate the creation of routine reports on behalf of our clients. The routine reports are mainly done with Microsoft Excel and Power Point. This particular job will serve as a test of your VBA abilities, which if are satisfactory will result in future job offers from us on VBA scripting. Future jobs will be offered at $20 for every 10 macro workbook made. The complexity of future jobs will range from easy to moderate (This test job being considered moderate) depending on our clients needs. This is expected to last for 3 to 6 months. However, we wish to stress that the only motive for this $5 job it to test your abilities. Instructions for this test job: â–ª Create a macro that w...
Looking for an expert VBA developer to fix and add something to an existing VBA program on urgent basis. I need this to be done tomorrow (Sunday.) I continue working same freelancer on multiple projects but the quality on the work is important. Thank You!
To assist me with a project using Microsoft Excel, I'm searching for a VBA specialist. In order to enable data filtering and other fundamental functions, the project will require VBA coding. The needed code will have a medium level of complexity.
i have a simple task if you are good at C++ and Excel VBA. Please find the attached text file for task description
Write VBA code to export 2 additional tables - tblDrawingList and tblRevLog located on ACS-S1-Sys sheet to the same Excel sheet to which other tables are being exported as initiated by the Export button on the Export sheet. tblDrawingList is to be exported to a new sheet titled "SEC-A02.1" with "Drawing List" in bold font above the table and "Revision Number" cell above the revision columns formated in the same way as the table headers. tblRevLog is to be exported to a new sheet titled "SEC-A02.2" with "Revision Log" in bold font above the table. Both tables are to be formated in Arial 8 pt font, gridlines off, delete empty rows, leave the tables formated as Formated Tables, turn off the column filters. The entire tables should be ex...
Hello Sir i am working on your project and it's about to complete please accept the offer so i can deliver you the final work. Thank You :)
I'm looking for a VBA expert to help me with a Microsoft Excel project. The project will involve coding in VBA to enable data filtering and other basic functionalities. The complexity of the code required will be of a medium level. As I have a limited budget, I am offering a fee of $40 for this project. If you have considerable experience coding in VBA, have a flexible availability and can guarantee a neat and professional output, please contact me with any questions you may have. Looking forward to hearing from you!
I need support in creating a report using pivot tables. The excel database is 1,100 rows long and and 27 columns. I would live to keep the pivot table or macros to then do my own what-if analysis. It is a list of problems with problem tasks. I need to create a report using pivot tables to extract by: - Tech Leader - Assignment group Group by - Problem number - problem tasks - state of problem tasks open or closed - date since they were last touched
Sample TXT file (Sample Text ) is attached along with the Sample Excel Output/Final Result (Sample Output ). Project is to take a monthly TXT file (data changes every month, the number of records/data/rows will change). Monthly TXT files are dynamic and data changes monthly (format remains the same). Simple Text to Column will not work. Will require VBA, PowerBI, Power Query or similar data conversion type coding. Will provide a few TXT to test with before project will be considered complete and working.
For this project, I am looking for an experienced VBA Expert to join my team and work remotely during UK shift hours. This role requires a strong technical background in VBA programming and the ability to work quickly and efficiently. You must have a comprehensive understanding of database programming, Excel macros, and automation techniques, as well as the ability to troubleshoot issues that , this individual should have the ability to take complex tasks and turn them into achievable deliverables while working within tight deadlines. The candidate will also be responsible for the below-mentioned points: 1. Candidate should have excellent communication skills 2. Candidate will be working for a UK-based company, so, they should be ready to work on a UK-based shift 3. Ca...
You can find the File hier... Problem is ... the Excel sheet is hanging up. Seems that there are some VBA Problems...
Operate Edge browser and chrome with VBA code without selenium and drivers
A project to improve and automate an existing Excel model. There will be various scenarios that have some restrictions and prerequisites before enabling certain options. A skillful coder is needed with experience and an eye-for-detail. It is a simple project but need to take time to properly understand the demands of the project.
Need Access expert to develop Access based application. Application purpose is to support manual data cleaning. the user will review data in a form and provide input in form of drop down list combo boxes. the combo boxes are relational. Navigation / menu form...(create new validated records), option to save and continue later. relational database dependent drop down combo boxes 8 to 15 Tables The data set consist of 50K rows X 20 columns approximately. I will provide sample data for development; you have to teach me how to add the full data. the input ranges are available with me (validation lists). Need fast efficient Access expert who is strong in VBA. need solution to keep the database central and provide users with access to work from their machines on cleaning the data...
We have an Excel file with vba and we have a form with vba that searches in 2 worksheets and ads products from those to a price offer form. We need to have prices from one worksheet multiplied with an exchange rate before adding to price offer. This is already implemented but for some reasons it does not work for all products from that list. need to fix
I want a joining application with the report and integrated with biometric and document scanning!!! So I can work paperless! Can discuss more
As a client, I'm looking for a freelancer to help me with an Excel project. Specifically, I want to compare two or more sheets in a single Excel file and find their similarities or differences. In particular, I need to make sure the data in these sheets are identical, so it would be great if the comparison could be automated...Excel project. Specifically, I want to compare two or more sheets in a single Excel file and find their similarities or differences. In particular, I need to make sure the data in these sheets are identical, so it would be great if the comparison could be automated. I believe this is a great way to streamline the process to make sure that the data matches. If you have experience with programming macros that can compare Excel sheets, I would greatly apprec...
Program the equations in the attached document such that I should be able to reproduce the results in Figure 12. The code should be in Excel VBA. The work requires knowledge of applied mechanics. Please note that you need to understand the concepts to program the equations. If you bid, please state how quickly you can do the work.
For a current project, I have 2 tasks. You NEED to have excellent knowledge of Excel VBA macros, visible in your portfolio. Tasks needs to be done within 24hours
I’m looking for a Freelancer to work on a project requiring expertise in Ms Acces VBA from Excel VBA. The primary purpose of this project is to create macros to consolidate csv to access as per condition. I have written excel vba code which works fine, but I want to shift from excel to access. I'm familiar with Excel VBA, but am having difficulty with Ms Access VBA. A project well-suited to a Freelancer with existing knowledge of Excel and Acces VBA would be perfect.
We need a office script, no VBA 1. transfer data from a excel-sheet to an other excel sheet 2. perform a complex calculation 3. send the result as an email
The main thing I need to do is this. Every night I will scrape data from a supplier's website and create nine different spreadsheets. These spreadsheets contain 1000s of products with their data. I sell some of these products, and some I don't. I also have a spreadsheet containing data for the products I sell, which I export from my website. To put it simply, I need to know this, of all the products I am selling on my exported spreadsheet, which of these products are out of stock. With this data, I can then update my stock holding to ensure I do not sell products the supplier does not have in stock. You will need to use the SKU and JHB Stock data fields to do this. Here attached is my export spreadsheet - Palmetrics Product Export 12-March-2023 SA Clean Water (1) And here ar...
need to make a risk register document more user friendly to use
Latest changes to the project as discussed.
I need a VBA Developer with prior experience. Details will be shared with the selected candidate.
Finishing product will be an add-on bottom in AutoCAD, which written by VBA-AutoCAD. A window pop-up once clicks on. require to fill up: - Customer Information [Text box for Customer name, address] Select Material [Drop down list to select material-user able to add-on in future]; Thickness [Drop down list to select thickness-user able to add-on in future]; 1. Raw Material Sheet: - Raw material size [Drop down list to choose material-user able to add-on in future]; By default, length & width will be shown in Text box for user to counter check. A custom-made button click which allows user to key in length & width of Raw Material Sheet. 2. Part Drawing: - Option Button to select from i. Standard flange ii. Custom-made flange iii. Up-load drawing i. By default, user can...