Macro vbadela
When i run macro in sheet 3 in excel, data is not getting generated in JSON,blank data is coming Wanted someone to rectify the macro error so that able to generate the file in JSON format
I am looking for a freelancer who can create an Excel macro that will help me with data formatting. Specifically, I need the macro to delete content between empty rows, and then delete the empty rows themselves. The project requires the following: - A macro that can identify and delete content between empty rows - The ability to delete the remaining empty rows - The macro should be compatible with Excel 2016 or later Ideal skills and experience for this project include: - Strong experience in creating macros for Excel - Knowledge of Excel data formatting and cleaning techniques - Familiarity with Excel 2016 or later Please see attached file for example. If you have any questions or suggestions regarding this project, please do not hesitate to contact me.
We are seeking an experienced Excel VBA/Google Sheets expert to develop a progress monitoring dashboard. The dashboard will be used to monitor progress on various projects and tasks and provide key stakeholders with real-time updates. The ideal candidate will have extensive experience with Excel VBA or Google Sheets and be able to design and develop complex spreadsheets and dashboards. Key Responsibilities: Design and develop a progress monitoring dashboard using Excel VBA or Google Sheets Work with stakeholders to identify key metrics and develop data visualization tools to display progress Automate data collection and analysis to ensure real-time updates on project progress Develop macros and scripts to streamline data entry and analysis Collaborate with other depa...
We are seeking an experienced Excel VBA/Google Sheets expert to develop a progress monitoring dashboard. The dashboard will be used to monitor progress on various projects and tasks and provide key stakeholders with real-time updates. The ideal candidate will have extensive experience with Excel VBA or Google Sheets and be able to design and develop complex spreadsheets and dashboards. Key Responsibilities: Design and develop a progress monitoring dashboard using Excel VBA or Google Sheets Work with stakeholders to identify key metrics and develop data visualization tools to display progress Automate data collection and analysis to ensure real-time updates on project progress Develop macros and scripts to streamline data entry and analysis Collaborate with other dep...
VBA programming to compile all tabs and apply other updates as discussed.
I am creating a form (yes /no) where the answers determine what other questions to show or hide.I am using form buttons (option buttons and checkboxes). I am able to program all of excel as i want it, but i cannot hide the form buttons, resulting in them floating on the sheet when the data around them is hidden. I need to know how to hide them.
I have .xlsm file with Macros. It is working fine in Windows but not in MAC. I don't have code for this. I need someone who can help me to work it in Macbook Air.
I am looking for a talented and experienced expert in VBA coding to assist with a project. I require assistance with writing macros, debugging existing code, and performing data analysis. The complexity of the VBA code required is expected to be intermediate at a minimum. I do not currently have an existing code that needs debugging, but this may change in the future. I need an experienced professional who can understand and develop advanced VBA scripting in a structured format. If you think you have the skills and experience necessary to complete this project successfully, please get in touch!
Upcoming project, we are looking for Excel Macro Developer 2 to 3 years of Experience
I'm seeking experienced help to create Excel VBA Macros to help me accomplish a task. I have no experience with VBA, but I need someone to create macros that can bulk-add images from a folder to an excel sheet in the corresponding cells. The level of complexity is intermediate. Someone with experience in creating Excel VBA Macros would be great. If you think you can help me with this project, please let me know! Thanks.
I have a 3 storey office mock project where I need to show compliance to regulations. I am currently drafting this project to be part of a portfolio for my registration with VBA. I would like to hire a building surveying to check my work.
Run a macro according to the request. (Run total 5 blue colors tab, starting from 2012-2018 tab or whichever that is earliest one in the excel. Click on All Sim Model Button. Excel macro will run, and just leave it until the simulation is completed.) Deadline is indicative and may be earlier or later depending on the macro and the amount of data.
Prosimo, vpišite se ali se prijavite za več podrobnosti.
Hi Everbody, please create a Excel-sheet and VBA Modules (programm-file). We need the following fuctions: 1. separate Sheet with credentials in programm-file. As we got serveral Clients, the credentials have to be organized in rows per client. column 2 shows the client-specific-data-file (csdf) name in the same folder as program file 2. authorize at Amazon with Selling Partner API 3. get the GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE from Amazon 4. save the result to csdf sheet "settlementreport" 5. ensure not report are duplicates. ensure we got all report in the timeline, not timeperiod is missing same for a VAT-Report from AMAZON. Report name willl be delivered later to you. Save result to CSDF sheet "VAT-Transaction-Report". Be sure it is complete and no dup...
Looking for a skilled freelancer to create a Microsoft Word Micro that can perform specific tasks. The main task is prepare a MS Word micro that should be able to automate repetitive tasks. Ideal skills for this project include experience with Microsoft Word macros. Only apply if you have advanced Microsoft Macro skills.
Scope of work is to finalize and help commercialize a PowerPoint COM add-in. Experience in PowerPoint Add-In and the Office Object model is essential. 1) Review and clean up my code (I have around 25 custom features in VB.NET) and translate some code from VBA to VB.NET 2) Finalize building a task pane that allows users to search and insert images, icons, templates. This works almost as needed, apart from slide templates and some final touches on the user experience. Need API experience for this 3) Help prepare for commercialization, incl. support with digital signature (e.g. Sectigo), install packager (e.g. WiX), and a license model with free trial Include the word pineapple in your proposal
I have an excel doc - as the User updates a UserForm (from Developer) the content of the document change. When he submits the userform the excel save as PDF (done with Vba). I want to send the file to the user without him knowing it is an excel file...so I basically need some sort of interface. Working in Excel but not looking like excel.
We pull monthly excel sheets with phone numbers that have a ton of different formatting. So every month we manually search and replace ( , ) , + , + , - , and finally a space. We replace them with nothing so then all phone numbers in the column look like this 8554347483 instead of (855)-434-7483. Would like to speed up this process.
I'm copying and pasting data into a spreadsheet that I need to change the layout of. The Data is in the form of question and answers. It starts with everything in one column in an identifiable pattern. What I need is for each Question and matching answer to be on a row. I am manually editing, but it is taking too long. The spreadsheet attached shows clearly what I need. It starts as "Copied and pasted" and what I need is "Transformed". The key here for a speedy turnaround, otherwise I might as well carry on doing it manually! By way of explanation: The format is: Question#, Q, {question], A, {answer} 7 Q Is osmosis passive or active? A Passive 8 Q Define active transport A The movement of molecules from an area of low concentration of that molecule to an ar...
I am looking for a freelancer who can help me with an Excel Automation project. The ideal candidate will have experience with automating basic tasks in Excel. Tasks: - Automating data input from different sources - Automating formatting and sorting of data - Automating basic calculations and formulas Skills: - Advanced knowledge of Excel - Proficiency in VBA and macros - Experience with data manipulation and analysis If you are interested in this project, please provide examples of previous Excel Automation work you have done.
I am seeking a freelancer with expertise in VBA to create an automated report generator for data analysis purposes using Microsoft Excel. The ideal candidate should have experience in statistical analysis and be able to integrate custom formulas as needed. The report generator should be compatible with Microsoft Excel and must be user-friendly for non-technical individuals.
Hi there! Do you have experince good sheet scripts. Thanks
I am looking for an expert in Visual Basic for Applications (VBA) scripting to help me with a project. I already have the data set to work with and it is relatively small with less than 500 rows. I need Help designing macros and performing data analysis with macros utilizing VBA scripting. The ideal freelancer would be someone with experience in creating macros and working with spreadsheet applications like Excel and Google Sheets, who can apply their knowledge to help execute sophisticated functions with the data set I am working with. This should be a relatively straightforward and fast-paced project, so please get in touch if you think you are up to the task!
Busco freelancer que hable ESPAÑOL que realice la consolidación mediante programa, macro o cualquier mecanismo que automatice la consolidación de información de 400 archivos de excel (con varias hojas) con estructuras similares (más no iguales) en UN SOLO archivo CSV o XLSX de 60 campos. Se valora tiempo de entrega (máximo 2 días)
Prosimo, vpišite se ali se prijavite za več podrobnosti.
As a personal project, I'm looking for a talented individual to create a basketball simulator using VBA in excel. The primary purpose of this project is to be able to calculate performance analytics. This requires that the simulator be able to accurately track player stats and generate visuals such as graphs and data tables to aid in analysis. The project must be completed and delivered by April 13, 11 PM.
extract , paste, verify, copy data from one file to another basing on various conditions. Needs to accept user sceen input for choice of cell action, cell and file location.
Need to create a VBA that does the below. Excel macro knowledge must As per the dimension in the Excel packing list, it automatically creates boxes in the AutoCAD LT application. Also adds descriptions inside the boxes from the Excel cell.
Need Images and Videos of Bespoke Tailoring Cinematic videos. Images need in high resolution files. Examples.
There are two sheets in which the names and codes are similar but not 100% Match. Example in sheet 1 the Item Code is "LG Monitor UG4992X4Y" and in second sheet the Item Code is "UG4992X4Y". We want a new sheet with column a containing the SHEET 1 Item Code and Column B containing SHEET 2 Item Code. There are totally 9000+ Item code. You need to be familiar with VBA coding, fuzzy lookup and Xmatch. The budget is 2000 To 3000 INR. We are not look for 100% accuracy but atleast 80-90%
Welcome to my project to convert a current program code into a new programming language. The end goal is to produce a 1:1 conversion of the code, which means that any existing functionalities and features should remain the same. The programming language I require is Excel Macro. Additionally, after the conversion is completed, I will need the code to be thoroughly tested for accuracy and reliability. This project requires a skillful developer with experience in coding and converting programs. If you think this project is for you, I would love to hear from you and learn how you can help me reach my goal!
Hello , I need someone to help me in completing this Modeling and simulation project. I really don't know where to start. The project description is in the pdf data that I included in my description.
Assist in Completing the Developing of the VBA Code for a Mobile Sales App
Need a fix on a macro to sort some result on my sheet file
I am looking for the right person to help create a macro in Excel VBA to automate data processing tasks. The macro will need to be able to work with text data, running calculations on it and presenting the results of those calculations. No interactions with other files are needed, and the macro must be able to perform calculations on the data without any extra input. If you are familiar with Excel VBA and have extensive experience writing macros that can easily work with various types of text data, please get in contact with me. I am looking for someone who is available to begin working on this project immediately and can guarantee the quality of their work.
I am looking for a freelancer with experience in Microsoft Excel to help create an automated Excel sheet. The freelancer will be tasked with creating a sheet with the ability to process and analyze data. The freelancer must be experienced in working with Excel tools such as Standard, Pivottable, or Macro-Enabled workbook. When applying, unsuccessful freelancers should include details such as past work and project proposals to better demonstrate their qualifications. While this project does not include any existing data to be used, freelancers should still demonstrate the ability to use data and analyze it in their application. If you think you have what it takes to complete this project, don't hesitate and apply now! I am excited to hear your ideas and suggestions.
Change the userform to have 2 file selections. 1) Scanner File 2) SAP download file containing the database. Update the data in the SAP download file and save it.
I'm looking for an experienced VBA programmer to help create an excel macro for a project report of our company. The macro should be written in Visual Basic, and present an intermediate level of complexity for the generated report. We need the project completed within a week. The successful applicant will possess strong VBA experience, as well as understanding of business add-in applications in Excel and related programming languages. If you have proven experience in developing and optimizing efficient business systems and data analysis tools, we invite you to apply!
I need to create separate sheet for selected columns using checkbox
I wrote this or probably filched bits and cobbled them together about 20 years ago and it has served me so well all this time running in various guises or often just on it's own, but I would love to see it in VBA. The file is a cut down version of a worksheet I use to copy product information (usually prices but sometimes text information) from suppliers files to my own files. There are 2 macros, the first in VBA sets up the names used to the top of the sheet to work downwards, the second "Macro 5" is the Excel 4 macro.
I need help creating an Excel Database to store my data and query it as needed. Additionally, I will need the database to be integrated with an existing system. Having expertise in VBA is a must, as it will make setting up the database much easier. I’m looking for someone who’s experienced with creating such databases, and who can integrate the data with my existing system. I need someone who can quickly deliver results, so being able to execute the project diligently and accurately is also essential. If you think you can help me with this, please reach out!
I have an Excel sheet. Need macro to make various charts.
VBA to build a macro in Excel that pulls in and stacks rows of raw data from a couple dozen flat files, de-dupes, and does some basic concatenation and formulas. Should be a breeze for someone well-versed in VBA/Excel. More detailed specs will be provided. The Macro should be 100% Functionnal with no issue or bugs and working in with all EM_Files
I am looking for a freelancer to create a pipeline simulation project using Excel VBA. It should be written in Excel VBA, stored in a spreadsheet and the complexity of the model should be simple. The successful developer must have experience in Excel VBA programming and be able to produce a robust model to handle the simulation. I am flexible with the project timeline depending on the complexity and the developer's availability. Please contact me if you are interested in this project.
My project is to create a simple, macro-enabled excel spreadsheet. I need it to support basic data entry and calculations, as well as to be able to pull data from external sources. The spreadsheet does not need to be formatted but should be accessible and easy to use to any who comes across it. I need someone with excel skills to create this spreadsheet and make sure it works properly. These are the three external data sources that the spreadsheet will pull data from; • • • Attached is the formula that the spreadsheet needs to perform and produce a daily line graph indicating the indexed price change. Thanks for considering this project.
Work part-time for us! Using your knowledge of Excel you will be helping to push our e-commerce business to the next level! This position is part-time. 2 - 4 hours per day. Between the hours of 9 am EST- 5 pm EST. The Skillset summary would be as follows: MS Excel - Proficiency in writing formulas and macros MS Excel - Programming using VBA that involves Http Webservice connection Postman - Understanding how Http Webservice API works, using the code in a CURL format MS SQL Server - Must be able to write SQL Queries such as Stored Procedures that involve Http Webservice connection - Must be able to create Sitemaps to scrape the correct data Bigcommerce - Understanding how the import file works
...question,,, panel for editing and creating macros* panel for analysis of results (while they are filled in, highlighting whether or not the session has already been completed by the patient/responsible or guests analysis panel - creates the patient's final report (with notification after completion) - report has to be signed with digital certificate by the administrator and available in pdf. *macro (some information presented by respondents (patient/responsible and guests) are considered red flags and will be redirected to a document (editable word) that also has its own editable logic (created by the administrator) (example whenever someone answers a certain question (Maria) the system recognizes that (Maria) is a red flag and in the word document… (Maria = Child o...