Increment column macro jobs

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

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

I'm in need of a Python programmer capable of building a license key ge...generated license keys. * Building a response system that displays license keys on a 'Thank You' page after purchase. * Setting up an automated email system that sends emails to the customers with their unique license key and a download link to Excel Template PRO. * The email system should also forward invoice details to the buyer with a copy to the site administrator. + The Coder has to create a Macro in my Excel Template to validate License keys connecting to our DB. Ideal applicants will possess: * Proficiency in Python and MySQL. * Experience in API development and integration. * Ability to create unique, verifiable license keys. * Experience in automating email responses and building user...

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.

I have a macro that has been put on my desktop from another computer and I need to get it uploaded to word

...functionalities do you need in your E-commerce website? Product listing and categorization, Need help configuring Lumise Plugin What platform do you want to build your E-commerce website on? WordPress We are looking for a freelancer to refine our Website through WordPress. We are using the Lumise plugin product designer and would like a couple of things fixed on the that page. 1. Remove the price column in the upper right corner 2. Add Clipart, Layouts, Backgrounds for designers to add to their product 3. Change/remove "Add to Cart" replace/add "Start Campaign" button Allow this to generate an email or order for us to verify we have all details needed then we will place it as a product to our product page. 4. Generate automated text with next step...

I am seeking assistance in crafting the design for a marathon T-shirt. The final product will be printed, primarily requiring placement and alignment of sponsor logos and names, with minimal graphic work involved. Key Project Details: - The T-shirt's color scheme will be a red shirt with white font. - Sponsors' logos and names should be arranged vertically and horizontally in a row and column format. - The font style for the sponsors' names should be Gotham regular. Ideal Skills and Experience: The work file has been created illustrator - Proficiency in graphic design software - Experience in T-shirt or apparel design is a plus - Ability to adhere to specified color schemes and font styles - Attention to detail is paramount, ensuring correct placement and alig...

I'm looking for a skilled JavaScript developer to create a function that can replace an existing Excel macro using Goalseek to calculate equipment rental fees. - Objective: The main goal of this task is to automate the calculation of the monthly rental fee for equipment. The JavaScript function you develop should be able to replace the existing Excel macro that uses Goalseek. - Data Handling: The function should be designed to receive input data manually from the user. This means that the function should be able to take in data directly from the user, process it, and return the calculated rental fee. - Complexity: The current formula used in the Excel macro for calculating the rental fee is moderately complex. It involves elements such as interest rates and amo...

Seeking a seasoned FullCalendar expert to execute some specific tweaks to the timegrid column in resource view. My requirements are as follows: - Modify column width , look at the picture . I need to custom the width of the column ( Any Tech ) to 40% and the rest -60% with divide evenly the total column left ( maybe 3,,5,8,...... ) fullcalendar plugin V3.1

I'm in need of a highly professional JavaScript and CSS expert to design and implement a data table with a broad range of functionalities. These include: - Sorting - Filtering - Pagination - Column resizing - Grouping - Column rearranging - Column hiding/showing Moreover, the table must also include extra features like dynamic totals calculation in the footer. Additionally, the data table should support dynamic cell data visualization. This feature should cover color coding, icon representation, and progress bars depending on the data type, which is to be detected when the data is assigned to the table element along with all the columns and their names. If the columns are resized, reordered, hidden or shown during runtime, these view details should be saved ...

...portal should accept XLSX files and validate them against having correct column headings in A, B and C. Key Features: - File Upload: The portal should be able to handle XLSX files for data upload. - Validation: The portal should check if the uploaded file has the correct column headers in A, B and C. If the spreadsheet fails this validation, it should provide an error message with guidance on how to correct the issue. - Accessibility: The portal should be accessible to anyone, without the need for user accounts. Ideal Skills: - Proficiency in web development with experience in building portals and handling file uploads. - Strong understanding of Excel file structures and the ability to programmatically validate column headers. - Knowledge of front-end de...

I need a reliable system that automates a process, doing a couple of specific tasks: 1. Reading specific data captured in Excel files. 2. Automatically sending texts via SMS when there's a data match in a particular column of the Excel file. This task will require programming skills, particularly with Excel and automation tools API. Experience with SMS gateway integration is a huge plus. You will be required to advise on appropriate SMS gateways if you have prior experience. The matching data column in the Excel file should be the trigger initiating the text sending automation. The target of this automation is to streamline and expedite our communication process, reducing manual effort involved in sending periodic SMS updates. If you have past experience automating...

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

I need an expert in Excel macros to develop a tool for me that would allow me to automate some specific tasks as I work in Excel. Key Specifications: - The tool needs...allow me to delete specific columns based on the value in a particular cell. Ideal Skills: - Proficiency in Excel macros/VBA - Prior experience in customizing Excel files - Good communication to understand my needs and implement them accurately I have an excel sheet with production data, the file has extra data that i do not need, so i need Macros to delete certain columns, change column widths, change column names, wrap text if needed, add several text boxes that will appear on the output file if filled in, have print preset done as well. i will provide actual files and examples if you're interested ...