Row column increment vba macro jobs
...ensure that only authorized personnel access the system. - Class List Management: We require a form where teachers can manually add, edit, and delete student names. This will populate the class list and allow for easy management. - Student Attendance Tracking: Our goal is to track daily student participation in our campaign. This can be facilitated by allowing teachers to tick a date in the student's row to indicate they brought plastic on that day. Ideal Skills & Experience: - Proficiency in Wix development and its membership system. - Experience in creating interactive, user-friendly forms. - Understanding of database structures and how to securely manage user data. - Strong communication skills to ensure the system meets our NGO's specific needs. This project ...
I'm looking to hire someone who can create an Excel VBA workbook to seamlessly integrate with my Zoho Desk setup. This workbook should be specifically engineered to perform the following: - Retrieve the required information from Zoho Desk tickets upon pressing a button inside Excel. Specifically, I need someone skilled in Excel VBA programming and API integration work to: - Design a user-friendly interface in the workbook where one can press a button to initiate the retrieval of ticket information. You should be able to retrieve the latest ticket, and then have two more buttons to go to next & previous tickets. - Implement secure API connections to Zoho Desk to enable the retrieval of ticket information usuing oauth. The fields I need are: Subject Account Name: C...
Get value from one column from another table only. Able to work with ftp. Just this issue
We operate a Google Sheet that fetches information from another spreadsheet identified in cell C1. Users mark checkboxes in Row A and click "Build Documents." When a user picks multiple checkboxes to generate documents, the Google Script halts after 300 seconds due to an overload. 1. The objective is to devise a systematic workaround to finish processing the document batch without additional manual intervention. For example, here's a replica of the spreadsheet you can use to test your code. The documents created all appear here: In the Spreadsheet App Sscript: In "Rahul's Code". 2. Add a line of code
I am in need of an Excel relational database. The database should have the functionality to enter values automatically from an attached worksheet. The entry of these values will be based on specific criteria, more specifically, column values. Required Skills and Experience: - Strong knowledge and proficiency in Excel - Experience in database creation, management, and optimization - Understanding of data entry and data analysis - Proven experience in creating reporting capabilities within Excel. Using the "Reference data" tab, when the value in Column B is entered in the "Example worksheet" the corresponding values should automatically populate - Tariff code, Duty rate, CPF.
I'm currently on the hunt for an individual highly experienced with Webflow to help me in beautifying my website. My website requires finesse in the areas of row spacing, and alignment; text alignment and formatting; and image alignment and positioning. Therefore, it's crucial that you have a profound understanding of Webflow CSS component frameworks and can apply these to my project consistently. Your primary tasks will involve: - Comb out the Webflow CSS components in my site in order to standardize and tidy them up. - Address specific alignment issues such as row spacing and alignment, text alignment and formatting, as well as image alignment and positioning. Since I skipped listing specific CSS components that need to be tidied up, it would be to your advantag...
I'm seeking a proficient Excel VBA coder to create a system that automates data entry from Excel files. The task involves: - Creating a VBA function that can input data automatically into my current system. - Implementing a data sorting feature as part of the data entry process to ensure that all data is easily read and interpreted. The ideal freelancer should have the following skills and experience: - Proficiency in Excel VBA - Experience with automated data entry - A solid understanding of data sorting techniques. This project requires precision and attention to detail. It should not only meet the needs listed above but also enhance data accuracy and save time.
I need a proficient structural engineer who can deliver a General Arrangement (GA) drawing and design verification for a Reinforced Cement Concrete (RCC) beam. The task at hand involves a cantilever carporch of 3.5m x 6m dimensions, destined for vehicle parking. I'm picturing an industrial-style steel beam that will be supported over an existing 250x600 RCC beam, which itself sits atop an RC column. Importantly, the carporch won't be subjected to any extra weight besides the vehicle. Your experience and skills: - Mastery of industrial design style - Proven experience in RCC and steel structure design - Proficient in providing design verification - Knowledgeable in GA drawing - Able to optimize for weight and structural stability Your main deliverables: - A GA drawing o...
I'm seeking an experienced Excel VBA expert to help me automate some basic, repetitive data entry and formatting tasks. Key Requirements: - Automate basic data entry and formatting tasks in Excel - Develop VBA script to ensure automation runs smoothly Ideal Skills and Experience: - Proven experience in developing VBA scripts for Excel - Strong understanding of Excel functions and data formatting - Ability to create automation systems that run seamlessly without user interaction Please note, no user interaction is required for this project. The VBA program should be designed to run automatically once set up. This task is relatively simple but needs to be executed precisely and efficiently. Looking forward to working with a professional who can deliver ...
I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs
I am struggling with incorrect results when attempting to subtract two values in a column of clock times in Excel. My data is in a 12-hour clock format, and I signify AM and PM directly within the time cells. I require an expert in Excel to address this issue promptly. To take on this project successfully, you should have: - Proficient Excel skills - Solid understanding of the 12-hour time format and functions in Excel - Ability to troubleshoot and rectify the problem quickly
...automating the transfer of information between those departments: linking the data, defining "trigger" events, and processing data from various inputs into "smart" trackers. I have a clear outline of what I want to accomplish - what data I need, who I need it from, and how I want the tracking of the inputs to function. My "coding" ability is a limited working-knowledge of JavaScript PDF and Excel VBA. I need someone to provide council and advise on what is possible, what tools or platform would be best for the end product I want to develop, and to advise on any alternatives. Basically, I am in the early stages of a long development process and I need an expert coder to review my outline and provide advise for the best way to accomplish what I want. ...
I'm seeking an Apple Script expert to help me automate a specific task in Numbers. - The task involves splitting a single column of four-digit numbers into four separate one-digit columns. - The split should be done in a sequential order, meaning the first digit of each number will go into the first separate column, the second digit into the second separate column, and so on. Ideal Skills and Experience: - Proficient in Apple Script - Extensive experience in automating tasks within Numbers - Strong understanding of data manipulation and processing
I'm in need of a PostgreSQL script that will loop through my table and update certain columns of the rows that meet a specific static condition. The main functionalities of this script include: - Iterating through all the rows of a given table. - Checking each row to see if it meets a certain static condition. - If the condition is met, updating certain columns within that row. This script should be designed to handle the following requirements: - The script will be used to filter and update specific rows based on a static condition. This condition will remain unchanged. - The script needs to efficiently loop through the entire table and update only the rows that meet the specified condition. Ideal skills and experience for this job: - Proficient in PostgreSQL and SQL...
... is a subscription-based practice exam platform. It offers 3 subjects: Mathematical Reasoning, Thinking Skills, Reading. Practice exam: Students receive 40 minutes to complete exams which are made up of x multiple-choice questions. Reading has 30 questions, Thinking skills has 40 questions, Mathematical Reasoning has 40 questions. Mock exam: Students complete 3 practice exams in a row - 1 Reading, 1 Thinking Skills, and 1 Mathematical Reasoning. Functionalities include ranking students against one another, timing, question categories, etc. Bugs to target: - Sometimes, a user starts an exam, only to find that some questions are already answered for them, around 14-20 questions. - Some tests (especially Thinking Skills) show double the amount of questions that it's supposed ...
I require a VBA Developer well-versed in automating repetitive tasks in Microsoft Excel. Your primary task is to automate my existing work functions to increase efficiency. Key Responsibilities: * Understand the current Excel operations and identify scope for improvement. * Develop VBA codes to automate basic standard operations. * Test the robustness and accuracy of the automation. * Combining 2 files into 1 pdf. 1st file is pdf and 2nd is excel(with selected sheets, and selected columns within sheets) Desired Skills & Experience: * Proficient in VBA, specifically for Microsoft Excel. * Experience in automating repetitive tasks. * Sharp problem-solving and debugging skills.
Seeking a proficient Excel VBA developer to aid in the centralization and automation of tasks in Excel 2010. Project requirements include: - Expertise in Excel latest version - Strong understanding of EXCEL VBA for automation purposes. Please note, specific tasks and functions to be automated in VBA have yet to be defined. Flexibility and broad knowledge in different Excel functions will be considered an asset.
...second, or third occurrence. The program will enable users to assess the quality of the Part B images and proceed to update both the Part A image and its associated Part B images by selecting and clicking "Next". This iterative process will continue until all images have been reviewed. Subsequently, the program will generate an Excel sheet containing the user's quality assessments in the third column. Overall, the program aims to streamline the evaluation process, allowing users to conveniently navigate and assess image associations while providing a comprehensive overview of their quality assessments for further analysis. - Using Python and CherryPy to develop the tool - Implementing a simple yet efficient user interface for the selection process The purpose of t...
...essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Windows OS - Experience in handling multiple databases with SQL - Strong troubleshooting skills I currently manage over 11 databases via Microsoft SQL Server Management Studio, and my system operates on Windows. You would be working an 8hr paid day in the Austr...
I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs
I need a Google App script that can scan a specific folder on my Google Drive for files and process them. The processing should involve an api that will skip tracing by first name and last name, if that returns no results then by company name, or if that returns no results then by property address to find the email. Once the email is located append it to the row in column AW. Once completed, prefix “processed_” to the file name. Api to use: skip force Key Requirements: - The script should be able to scan a specified Google Drive folder for files. - When a file is found, the script should process it by skip tracing. This involves cross-referencing the information in the file with first names and last names, company names or property addresses. - The script sho...
...and then suddenly stopped working for only the largest file. Through my own tests, I’ve learned that if I remove the 30 columns prior to the last column in the problematic Excel file, it transfers fine, so it’s not a coding issue. There’s either a problem with too many columns or something in one or more of those 30 columns is causing an error when moving the data to the database. Since the website needs to be user friendly, we can’t expect the user to fix the Excel sheet. We also can’t just write code to remove the 30 columns prior to the last column, because all user files might not have the columns in the same order, so a required column might find itself in one of those locations. Based on my test results, one possible solutio...
...relevant date column of the "ORDERMENTUM" tab in the google sheet. See sample production report attached () - this is for the items required by customers on Saturday May 4th. This data is not available to access without exporting it to a csv file. For retail orders we use Shopify but use two apps to provide the data to our production team so that they know when the customer has selected to pick up their order - Zapiet Pick + Delivery to assign an order pickup/delivery date (it does so by adding date tags to orders) and Report Pundit to organise this information into production reports. See an example Report Pundit export for Sunday May 5th (Production - Daily ) This data needs to populate into the relevant date column of the "SHOPIFY"
As my project deals intricately with WordPerfect, I'm in search of an experienced freelancer who knows the ins and outs of this software. - **Expertise Required**: In-depth knowledge of WordPerfect is a must. Your task will include document formatting, template designing, and macro automation. - **Application Criteria**: Please include proof of your expertise in WordPerfect in your application, such as a detailed description of a project you have worked on or a list of tasks performed using WordPerfect. Show me why you're the best candidate for this task! - **Note**: This project strictly requires WordPerfect skills only. Additional software expertise is not necessary for this particular project. Your exclusive proficiency in WordPerfect will be vital for the highest ...
I need a knowledgeable Excel VBA specialist, with a background in data manipulation and analysis, to create a custom macro for my spreadsheet. - The macro's primary function is to automate the creation of new rows based on certain numeric values, namely the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ideal freelancer should have solid experience in creating advanced Excel VBA macros...
...experienced MS Access developer to assist with my form development tasks. The ideal candidate is proficient in VBA (Visual Basic for Applications) coding and has the ability to design and implement forms based on my specifications. Key Responsibilities: - Designing and developing database structures based on my project requirements - Implementing VBA code for basic functionalities such as form submissions and data entry automation - Creating forms in MS Access based on a specific design I have in mind - Ensuring the database and forms meet quality standards and are user-friendly Ideal Skills and Experience: - Proven experience in database design and development using MS Access - Proficiency in VBA coding, particularly for basic functionalities - Previous experienc...
I am interested in creating an Excel VBA macro that will allow me to import PDF invoices into line items and parse them. The objective of this project is to streamline the process of invoice data entry by automating the extraction of key information from incoming PDF invoices, namely Invoice number, Vendor name, Pricelist, and Detail. The successful freelancer for this project should have: - Demonstrated experience in creating VBA macros for Excel - A strong understanding of PDF parsing and data importation - Knowledge of accounting principles is a plus The imported data should ideally be formatted in Excel as: - Each PDF invoice should be translated into a single row - The extracted information should be available in separate columns for each piece of informa...
...YOU CANNOT WRITE EXCEL MACRO TO SCRAPE THE DATA. PYTHON SCRAPPER DON'T NEED I'm in need of a VBA developer who can help in creating a small code for scraping contact details from a specific website. The task involves creating a button in an Excel file that triggers the scraping process and saves the extracted data back into the same Excel file. Note : Project budget is only 6k because it will take max 2-3 hour for experience developer Key Requirements: - Scrape contact details from - Specifically, scrape Owner Name & Address - Implement a function where a user clicking a button triggers the scraping process - Save the extracted data back into the same Excel file Ideal Skills & Experience: - Proficient in VBA programming - Experience
I need a pretty simple Excel spreadsheet. It is for a used car dealership. I need a row to imput the vehicle, one for the purchase price of the vehicle, one for the cost to prepare the vehicle for sale, one for the sale price, and one for the profit or loss on the sale. I would like it setup with tabs at the bottom for months and years
We require a specialist Excel developer capable of designing an ERP worksheet that can facilitate efficient inventory management. Notably, this will be identified through its ability to: - Track product movements (Received from Dock, Moved to Location, Picked, RTS) - Forecast demand accurately - Calculate reorder points precisely (Flag Products that are low in stock) - Distr...Sequens is Location, Part, QTY) - Ensure daily inventory updates are possible (Inventory has to be LIVE) - Add a dashboard for visual view of KPI's and results The ideal candidate will have proven experience in ERP Excel design, particularly within the field of inventory management. Expertise in IR Scanning layout will be strongly favored. Knowledge needed. - Excel Formula Mastery - Pivots Tables - VBA...
I'm in need of an intermediate level automated meeting minutes solution on Excel 2016. This project requires expertise in Excel and VBA and knowledge of data categorization. Key requirements include: - **Template Generation**: The tool should be able to generate a meeting minutes template automatically. - **Categorization**: Information in the meeting minutes should be categorized by attendee. Date Task owners Points discussed New Ideas generation' related System Process People Technology others Ideal skill set for this project includes: - Proficiency in Excel, particularly Excel 2016 - Experience in VBA/Macros for Excel - Previous work with data categorization and template generation Looking for someone who can deliver a robust, user-friendly solution that s...
Linking of dropdown with another column. Work with ftp only.
...5. Nature of journal: Legal articles, academic research papers, international law areas, including human rights, international trade, international humanitarian law, peace, security, and conflict. **Please Organize the information in a table format. Each journal should be listed in a separate row, with the following columns: 1. Name of the Journal, 2. Publication cost, 3. Indexed status, 4. Ranking of the journal, of journal. Please include as many journals as possible. You can use one row for one journal. Searching guidelines: Here, I am giving an example. is an International Journal of Science and Research (IJSR). Although it seems to be a science journal, it also publishes International law articles. The processing and publication cost is twenty-five dollars per...
I'm in need of an experienced industrial designer or mechanical engineer who can help me create a new in-row hoe design. Key Details: - **Purpose**: The in-row hoe will be used primarily for weeding. - **Environment**: The hoe will primarily be used in large commercial farms. Prior experience in agricultural equipment design or similar projects is a plus. I'm looking for someone who can: - Understand the specific needs of the agricultural industry - Design a product that is both efficient and durable - Incorporate any necessary features for maneuverability, given the large scale of use Your expertise and creativity in this field will be crucial to the success of the project. If you're up for the challenge, please send me your credentials and any ...
I am seeking a proficient specialist in Excel 2010, with extensive experience in the creation of VBA Macros, designing data entry sheets, automating tasks, and generating reports. Key responsibilities include: - Design and develop efficient VBA Macros - Design accessible and streamlined data entry sheets - Automate various Excel tasks for increased productivity - Generate comprehensive and insightful reports Ideally, you have advanced knowledge of Excel and VBA Macro programming, demonstrating a proven track record in dealing with complex Excel projects. A strong understanding of spreadsheet automation and report generation is fundamental to execute this project successfully.
I am seeking a detail-oriented freelancer to input text and numerical data into 3 small Excel spreadsheets, containing 1 column each. 2 spreadsheets for emails, one called Minnesota, one called Midwest. 1 spreadsheet of inventory numbers. See attached. Only emails are needed. Inventory is on yellow paper Ideal Skills: - Proficient in Excel - Attention to detail - Knowledge of data organization and management Highlight the entries that you are not sure of, or the handwriting is to difficult to read. English fluency in a must.
I am seeking an experienced .NET developer to build a highly dynamic REST API using the .NET 8 framework. The API will be designed to manage interactions with a database using a single, generic controller capable of handling all database tables. This project will involve implementing advanced features such as column selection, filtering, sorting, pagination, and complex table relationships like aggregations and master-detail references. Core Requirements: 1. API Framework: The API should be developed using .NET 8. I am open to using either OData or GraphQL for the API architecture, depending on what the developer finds most suitable for the project requirements. Alternative suggestions are welcome for discussion. 2. Generic Controller: The API should feature a single, generic cont...
I'm looking for an Ex...from the NSE options chain. - Educational Focus: The content presented should be geared towards explaining the basic concepts of options trading in a clear and easy-to-understand manner. - Excel Proficiency: The ideal candidate should have a strong command over Excel and be able to integrate real-time data sources effectively. Ideal Skills and Experience: - Advanced Excel Skills: Proficiency in VBA and data connections is a must. - NSE Data Integration: Prior experience working with NSE data feeds would be advantageous. - Educational Content Creation: Experience in simplifying complex financial concepts into easily digestible content would be a plus. Looking forward to working with a professional who can deliver a top-notch, educational Excel NSE opt...
I'm in need of an Excel expert who can help me automate data entry and formatting tasks. I also need assistance in creating a macro to generate daily status reports. Key Tasks: - Automate data entry tasks - Automate formatting tasks - Create a daily status report macro Requirements: - Proficiency in Excel and VBA macro creation - Experience in automating data entry and formatting - Previous history of generating reports using VBA - Strong communication skills and ability to understand and translate my requirements efficiently.
I need a skilled Excel VBA Macro expert to develop a VBA macro that can automate reports, specifically with numerical data. Your task will revolve mainly around creating a function that streamlines the reporting process, making it efficient and error-free. Ideal Skills: - Extensive knowledge in Excel VBA - Strong background in automated reporting using Excel - Familiarity with handling numerical data Experience required: - Prior experience developing Excel VBA macros - Proven track record in creating automated reports .
I need a proficient Excel macro creator to help with tasks involving data automation and formatting. The macro will need to work seamlessly across multiple sheets in Excel 365. Key tasks involve: - Automated data entry across multiple Excel sheets. - Formatting the entered data to adhere to specific standards. Ideal Skills and Experience: - Advanced knowledge of Microsoft Excel 365. - Complete understanding of Excel Macro creation. - Demonstrated ability to automate data entry and formatting in Excel. Your commitment to timely and accurate results will be highly appreciated. Thank you in advance for your time and efforts.
As the project owner, I'm looking for a skilled professional to create detailed AutoCAD drawings for the electrical services of a building. The level of detail required is macro-level, focusing on building wiring. This project is for a college assignment. The project requires the preparation of the following AutoCAD drawings: Containment Drawing: Showcasing the paths and management of electrical conduits and other containment systems. All containment will be mounted on suspended Unistrut brackets, with a minimum of 800mm of space above the false ceiling. Single Line Schematic: A detailed schematic for the main distribution board, illustrating the arrangement and connections of switches, fuses, circuit breakers, and other electrical components. Layout Drawings: These will in...
Detailed overall drawings will be provided ①Production of frame model - Basement of the first basement floor and first floor above ground, designated expression - Expression of floor level difference between the 2nd and 6th floors above ground - Expression of external finish ② Production of detailed reinforcement model - Column, girder, beam (at least 1, reinforcement spacing doubled) - Foundation, slab (only partial representation) ③ RC beam bending, shear analysis and design ④ Preparation of detailed labor distribution model (planned) schedule ⑤ Detailed reinforcement model (planned) construction cost estimation - Quantity calculation basis, work type statement, tally table, bar chart - Scheduled for final presentation - actual comparison ⑥ Preparation of final presentation mater...
Detailed overall drawings will be provided ①Production of frame model - Basement of the first basement floor and first floor above ground, designated expression - Expression of floor level difference between the 2nd and 6th floors above ground - Expression of external finish ② Production of detailed reinforcement model - Column, girder, beam (at least 1, reinforcement spacing doubled) - Foundation, slab (only partial representation) ③ RC beam bending, shear analysis and design ④ Preparation of detailed labor distribution model (planned) schedule ⑤ Detailed reinforcement model (planned) construction cost estimation - Quantity calculation basis, work type statement, tally table, bar chart - Scheduled for final presentation - actual comparison ⑥ Preparation of final prese...
I am seeking a seasoned Excel expert to manage a complex data entry project. Your focus will be the development and implementation of advanced macros to ensure efficient, effective data management. Key Responsibilities: - Executing Excel data entry tasks - De...implementation of advanced macros to ensure efficient, effective data management. Key Responsibilities: - Executing Excel data entry tasks - Developing and applying advanced macros Preferred Skills & Experience: - Proficiency in Excel - In-depth understanding of advanced macro development - Proven experience in similar data management projects The ideal freelancer will be detail-oriented, possess strong problem-solving skills, and have a track record of improving efficiency and accuracy in data entry tasks via ...
...the items in DF5 should have a corresponding item in DF6 if not that row should be taxed and the final output should be following Metrics: 1. Adoption rate - if any of the items is missing from the 4 files then that row will be marked as X i.e. miss. example : Bug1 - had a Support CR and Jira and also Project Jira but Project CR was missing then it'll be X similarly the row will be considered completed only when all the respectively objects are successfully creates 2. Control Adoption Accuracy: Each Jira and Solman extract should have few mandatory fields that must be filled and should be completed e.g Bug1 has 5 Jira mandatory fields & 4 Solman mandatory fields and if any of these fields are missing then the missing column would be marked as X. a...
I'm looking for an Excel and VBA expert to help streamline my workflow and boost productivity. You'll be responsible for: - Automating repetitive tasks: I need you to develop efficient scripts that will handle routine operations in the spreadsheets, eliminating the need for manual intervention and enhancing the overall efficiency. - Crafting custom functions: The custom functions I require are complex and involve external data sources. Your role will involve creating these functions effectively, ensuring they are accurate and function seamlessly within the Excel environment. The ideal candidate will have extensive experience in Excel, VBA, and creating complex custom functions. Solid understanding of data analysis and automation is crucial for this role. Your mai...
I'm urgently in need of a VBA expert to help tune an existing Word VBA that's not performing as expected. Even though it runs, it's not accomplishing the task it was meant for. Key objectives for this project are: - Identification and resolution of current issues with the VBA to align with its original purpose - Modification of the VBA to extract Word OLEs, while entirely bypassing PDF files (skipping them). The ideal freelancer for this task will have: - Extensive experience in VBA coding and troubleshooting - Experience with OLE extraction from Word - Proven track record in meeting deadlines. The timeline for this project is within a month. If you think you're the right fit for this project, I'd like to hear how you can hel...
