Increment column macro jobs

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 information.

PLEASE DON'T BID IF 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

Linking of dropdown with another column. Work with ftp only.

Please read my requirements: (make a table of 5 columns) 1. Name of Journal: I need a List of double-blind peer-reviewed Journals of International Law. Provide the journal's website and email address in this column. 2. Publication cost: The journal's publication cost APC must be cheaper or free. Please write the publication cost per page. Don't mention any journal that exceeds thirty dollars per page. 3. Status: The journal must be Indexed with Research Gate, Google Scholar, Academia, JSTOR, etc. 4. Ranking: Mention the international ranking of the journal. 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 Organ...

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....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 suc...

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 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...

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 ...

I'm looking for a skilled Python programmer to assist in creating a metrics system for my data analysis project. Below are the key aspects of the project: - Data Type: The project will primarily involve the processing and analysis of text data. Prior experience with this data type is a definite advantage. -...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. and similarly if all the fields are filled but one field is wrong input compared to what's expected then it should mark ...

Looking for an expert who can import data from 1-10 Excel files into Google Earth. Key tasks: - Convert location data from Excel into a format readable by Google Earth (preferred Google Eath Pro Tours for Commercial Real Estate Properties - Ensure perfect alignment of data with the geographical locations - Grouping and categorizing the locations as per the content of each column within the Excel files Ideal candidate: - Proven experience with data visualization tools, particularly Google Earth and Google Earth Pro tours for Commercial Real Estate Properties -- High proficiency in handling Excel files and data - Understanding of Geographical Information Systems would be a bonus.

Developer for long term (Able to start immediately) Follow to solve issue one by one (3-4 issues only) Estimated within 1 day. Able to work with ftp.

...names on a Google sheet. - Pupils and their grades in each row. Currently I share this in view mode but they can all see each other's row of grades. I want to hide this sheet, and share another sheet “My Work” where they can enter their number and it shows only this row of grades. - not all rows. See the link and the sheet called Y11 grades - see copy below The names appear in column C - I will hide this column Their ID is in col B I need a new sheet which shows the same headings. Rows - 1 - 7 - with a link to my main sheet. This must change when I change my main sheet to always be the same. In this new “My Work” sheet they should enter a number and their row is shown. Can you update my version below to do this? BUT I would want...

Excel expert. In excel, I have the following columns: Tasks, Responsible, Workload hours, and one column for each month with deadlines. For each responsible, I need the summarized workload by week. This is to be able to evaluate (based on the estimated workload-hours) if each responsible has enough available hours to deliver the tasks.

I require an expert in Excel to assist with the reformatting of dates in one specific column of my spreadsheet. The current date format is MM/DD/YYYY, and I need to modify this to DD/MM/YYYY (01/05/2024). The project involves approximately 150 records. The ideal candidate for this task would possess strong Excel skills and attention to detail. No additional modifications are required. Some 150 records.

...to combine they all have same format but first 3-4 rows there is miscellaneous things that I don’t need to combine I’ll combine starting row 5 as example , is there a way to do that and if so what’s the best way ? Knowing that I might add new tabs in future or if a project is done , the person who maintain the excel will replace tab name and put new information . In combined sheet it will give a column at end or beginning of the information I’m combining . What’s the best way to do that ? The main tasks required are: - Merge the selected tabs into one sheet - Organize the combined data by project name - Present the data in alphabetical order The person ideal for this job should have: - Extensive knowledge in Excel handling and formulas - Proven ex...

Make Column any Tech to 40% width like the picture below , and work with the source booking too

Simple job for easy 10 rating. Combine like files into 1 csv. all files have same column heeders NEED JOB DONE ASAP. TODAY USA time.

I need a proficient Excel programmer who can assist with both data analysis and p...involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming and creating Macros in Excel is essential. - Template Modification: Experience in modifying existing Excel templates or creating new ones. - Data Integration: Knowledge of integrating and working with local files (CSV, JSON, XML) within Excel will...

I need a proficient Excel programmer who can assist with both data analysis and p...involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming and creating Macros in Excel is essential. - Template Modification: Experience in modifying existing Excel templates or creating new ones. - Data Integration: Knowledge of integrating and working with local files (CSV, JSON, XML) within Excel will...

I'm in need of a proficient developer who can create and implement a Power Automate flow. The purpose of this flow is to copy rows from Table A and migrate them over to Table B, all within our data verse. The condition for the migration is dictated by a specific value in a column; more specifically, in the "Test Status" column. If a row in Table A possesses "Test Status" in the specified column, then it should be copied over to Table B. Required Skills: - Power Automate proficiency - Experience with data verse - Attention to detail, as accurate copying is essential Please note, the rows in question are not to be deleted from Table A after copying. They should remain intact. The ultimate goal is to have a duplicate in Table B.

I'm looking for an Excel expert to create a robust three-level lookup function that can handle text data. The primary goal of this function is to facilitate data analysi...calculate things like velocity in the pipe, friction loss through the pipe, etc. on a row-by-row basis. One row might be 4" steel schedule 40, the next row might be 2" copper type L. So each row needs to reference the values from the correct row in the table (select the corresponding internal diameter, for example). I believe it may be most practical to use the dropdowns to set a cell in a hidden column as the value of the row number from the table that corresponds to the selections, provided subsequent cells in the row can use that to correctly pull data from the table. This is where I'm...

...in a data extraction and verification project within the aerospace and airplane domain. The primary task involves extracting and separating text from an Excel sheet column, ensuring precision as automated methods have proven insufficient. The extracted paragraphs must align accurately with the content of the original PDF files provided. Additionally, the freelancer will be responsible for populating other Excel sheet columns with relevant information derived from keywords associated with the content. Key Tasks: Text Extraction and Separation: The freelancer will meticulously extract and separate text from an Excel sheet column, ensuring only relevant paragraphs pertaining to the aerospace and airplane context are retained. Non-relevant text will be erased, leaving behi...

I need a proficient Excel programmer who can assist with both data analysis and p...involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming and creating Macros in Excel is essential. - Template Modification: Experience in modifying existing Excel templates or creating new ones. - Data Integration: Knowledge of integrating and working with local files (CSV, JSON, XML) within Excel will...

I am in need of a skilled professional, capable of reorganizing my database of approximately 1,000 customers. To be specific: - The Excel database contains the following data field: Name, Email, Phone number, Address, City, and Country. - The organization should be done alphabetically by name. - The new Excel template format should have each field in a separate column. For this job, it'll be ideal if you possess exceptional Excel and data organization skills and have prior experience in Database Management. Efficiency in Excel, coupled with keen attention to detail, will aid in the successful completion of this task. Anyone with a seasoned approach to the task will be greatly appreciated.

I'm looking for a proficient Abaqus modeler to develop a model of a slender column based on specific design specifications provided in the job sheet. The task will involve: - Modeling a slender column using Abaqus - Incorporating specific material properties and geometry specifications - Applying boundary conditions for combined loads of axial load and bending moment Ideal skills for this job would include extensive experience in modeling structures with Abaqus, understanding of boundary conditions, and experience in analyzing structures under combined loads. Familiarity with structural dynamics will be a major plus.

I'm looking for a proficient VBScript expert to enhance my existing code by adding an additional column. Here's what you should know about the job: - The column will serve the purpose of storing more data. - This new data is going to be textual data. Skills and Experience Needed: - Strong proficiency in VBScript - Proven track record working with tabular data within scripts - Attention to detail, as the implemented solution should flawlessly integrate with the current codebase without creating data inconsistencies. This task is specifically for VBScript professionals with extensive experience manipulating data structures. If you understand the importance of clean, organized data and have the necessary skills, I’m looking forward to seeing your bid.

I need a skilled Excel specialist to handle the automation of tasks in my daily-updated Excel file. Key Responsibilities: - Develop basic macros to automate tasks: I need macros to simplify and speed up the daily operations in the Excel file. Ideal Skills and Experience: - Proficiency in Excel: You should be very familiar with Excel tools and functions, especially in the area of macro creation. - Experience in automation: Previous experience in automating tasks in Excel, especially on a daily basis, would be highly beneficial. - Detail-oriented: The tasks are basic but they need to be carried out consistently and accurately on a daily basis. - Time management: You should be able to create a system that keeps up with the daily updates. I am open to discussing more about the pr...

We are a Premier Online Coaching Platform, evidence-driven, thriving to build an unbreakable mindset. This is also India's first website that calculates the exact number of calories with detailed macro nutrient distribution for a particular person based on their bio feedback. The website is absolute new, and nothing has been done yet apart from creating the entire thing as of now. There are a few tweaks and updates along with SEO that I need on the website to make it more human, interactive, responsive, fast & user friendly both in terms of desktop and mobile. These are the detailed requirements as of now: 1. Forms, Thank You pages upon submitting forms, making purchases and email responses. 2. Replace contact button from the home page and menu with a simple white band

...price appear on them. All the products that need to be checked are from the same website. The following are the steps:- a) Excel file containing Product url list of about 300 products, all from the same website b) We should be able to run a macro etc, which we need to do multiple times daily c) When we run the script, it should check if for all those 300 products, there is a MSRP pricing appearing on the website d) The products have many variations, so it should check for all the varitions e) It should create each variation entry into a seperate column and highlight that product as a variation f) If any variation does not have MSRP price appear, then it should highlight that G) If the MSRP is appearing for variation, then it should fetch and enter that number. It is v...

Hi Ishaq. Can you have a look at this app for us. We want to convert it from a commend line batch file to a GUI app in Python. We had one of our team build the app in C# a few years ago, but he has left and we have the source code. The app will extract an image from an excel spread sheet based on the column ref and put the image into a nominated directory with the imaged named as per another column in the source excel spreadsheet. I can send yu a full demo of the app. regards Rob

I'm currentl...certain text. Skills and experience required: - Proficiency in Microsoft Excel is essential. - Familiarity with conditional formatting in Excel to highlight cells. - Experience working with text-based data in Excel. - Attention to detail to ensure the correct text is highlighted. I need a quick or instant way either with a formula or conditional formatting to find where each of the values in this column are located in the bordered areas, and then highlight those specific cells. Basically I am going to a website, downloading a long list of parts with individual numbers and then need to be able to quickly search all of those numbers in my excel spreadsheet all at once and highlight those cells instead of having to individually plug each number or value in and sea...

As a frequent user of Microsoft Excel, I'm looking for a skilled professional to design and implement a powerful goal seek macro for my spreadsheet. Here are the details: - **Scope:** The macro's primary purpose is to automate complex calculations, which would otherwise be time-consuming and prone to errors if done manually. - **Functionality:** The macro should be capable of performing multiple cell goal seek operations. This means it should be able to iterate through several scenarios until a set of conditions are met. - **User Interface:** I prefer to trigger this macro through a button click within the spreadsheet. **Ideal Freelancer:** To successfully complete this project, you should have: - Proficiency in Microsoft Excel, including advanced knowle...

Create the macro automation for the sheet

I am seeking an experienced Excel professional to set up a comprehensive spreadsheet for tracking various scooter specifications. Given data must include the following: - Brand - Model - Engine Displacement - Maximum Speed - Weight Capacity - Availability in Different Colors: This will need to be formatted such that each color has its own individual column. - Price: The price listed should reflect the Manufacturer's Suggested Retail Price (MSRP). - Additional Features: This may include factors like ABS, Bluetooth connectivity, etc. - Fuel Efficiency: Recorded in km/l or mpg. The ideal candidate will have proficient skills in data organization, Excel formatting, and data entry. Experience in automotive or scooter industry will be beneficial.

I want a formula in column D of the attached spreadsheet to convert the date in column C to DD/MM/YYY

I need help with solving 40 college-level math problems. The topics include coordinates and basis, diagonalization, eigenvectors and eigenvalues, introduction of linear transformation, row column and null space, the characteristic equation, vector space and subspaces. It's not a crazy assignment, just a bunch of problems that I don't have time to solve. Ideal Skills & Experience: - Proficiency in College-level Math - Understanding of coordinates and basis, diagonalization, eigenvectors and eigenvalues, introduction of linear transformation, row column and null space, the characteristic equation, vector space and subspaces. - Ability to provide correct, concise answers without detailed explanations. - Familiarity with various mathematical notations.

I'm seeking an experienced Excel macro specialist to take on a key role in automating my work tasks. Let's dive into specifics: I have given Start time, Interval, End time in excel When i give start time(Ex:9:15), when that time reached E col data automatically copied in into G col, Next Interval is 10 Mins, When 9:25 reached E col data automatically copied in into H col, When 9:35 reached E col data automatically copied in into I col,When 9:45 reached E col data automatically copied in into J col, When 9:55 reached E col data automatically copied in into K col, When 10:05 reached E col data automatically copied in into L col, When 10:15 reached E col data automatically copied in into M col.(H col vale > G col, that cell is green, H col vale < G col, that cell is ...

Data not stored, after create. (Might no column or submit function.)

I need an Excel macro that will primarily handle formatting and sorting data, and to be used on a daily basis. Key Responsibilities: - Developing a macro to automate formatting and sorting of data in Excel 2019. - Ensuring the macro is optimized for daily use, with minimal errors and efficient performance. Ideal Skills and Experience: - Strong expertise in Excel macro development. - Prior experience creating macros for daily use. - Proficiency with Excel 2019 is a must. - Attention to detail and thorough testing skills. Looking for a developer who can deliver a robust, reliable solution that can handle repeated daily use without any issues.

Modify existing condition after button clicked. Add a column to the table to store upload and API

its a very simple task with following requirements 1. Column E in one of the sheet is having a drop down menu with 3 options only. I want that once any option from drop down is selected once it cannot be deleted or amended by any user. 2. Till the time data in Column E is not selected/ entered, the users should not be allowed to enter data in any subsequent column. 3. Access/ Permission to delete/ amend data in column E to be given to selected Users and once any user is removed from the allowed user list he should not b able to amend or delete data in column E. please only bid if you really think you can handle this task with proficiency and have already done it before.

l has a Google sheet file. I want to create a script for the Daily sheet. When a new row is completed and a new input is introduced in column C, the script should look for the closest past entry, by date, for the Unit Price in column P and add it to the new row being completed in column G, which is the market Price, the same for the date and which provider made the last purchase.

...cleaner, more professional look with improved user-friendliness. The primary focus is on making the UI responsive and ensuring seamless API integration for enhanced user experience. Scope of Work: Frontend UI Enhancement: Improve the design of List page with a datatable layout, including features such as Search Sorting Filters Grouping Show/hide columns Column Adjustment Horizontal, Vertical Scroll Create Sub Task from List view Column wise field edit Task reordering Task & Sub Task Expand collapse function Multiselect option Enhance the detail page design with inline edit functions Responsiveness: Ensure that the frontend UI is responsive across various devices and screen sizes for optimal user experience. API Integration: Integrate APIs seamlessly into the f...

I need an expert to create a system where a rest hours sheet is integrated with a database within the same workbook in Microsoft Excel. Key requirements: - The integration should be made using VBA Macro or simple cell reference. - The database should store information about individuals, leaving out any date, hour or minute details. - The database requires no regular updates triggered by specific events. Ideal skills and experience: - Proficiency in Microsoft Excel - Experience in working with VBA Macros - Understanding of data management in Excel

Please Sign Up or Login to see details.