Vba excel update column työt
I'm looking for a skilled freelancer to create a custom quoting template in Microsoft Excel for my business. The template should be intuitive, easy to use, and visually appealing. Key Features: - The template must be fully customizable in design, enabling me to adapt it according to my branding and specific needs. - I'd like the template to incorporate conditional formatting for data visualization. This feature will help better present the data, making it easier to understand and interpret. Ideal Skills and Experience: - Proficiency in Microsoft Excel, particularly in creating templates. - Experience in designing visually appealing and user-friendly templates. - A strong understanding of how to implement conditional formatting for effective data visualization. I...
As an innovator in high-tech office spaces, my team and I are seeking a skilled AI specialist to develop a comprehensive elevator management system, implementing artificial intelligence and advanced functionalities. Key Responsibilities: - Overseeing the monitoring and controlling of the elevator system, to achieve optimal movement and energy efficiency. - Developing a real-time status update and alert system, to keep passengers and management well-informed. Required Features: - Voice recognition capability, allowing passengers to input commands vocally. - A user-friendly touchscreen interface, permitting passengers to navigate their ride easily. - Integration with our building's security system, to ensure safety and streamline operations. As the expected number of floors a...
...and agreements. • Experience with software audit tools and technologies. • Excellent analytical and problem-solving skills. • Detail-oriented with a strong ability to interpret data and documentation. • Effective communication skills, both written and verbal. • Ability to work independently and collaborate with cross-functional teams. • Proficiency in using spreadsheet software (e.g., Microsoft Excel) for data analysis. Preferred Qualifications: • Certified Software Asset Manager (CSAM) or similar certification. • Familiarity with IT asset management (ITAM) principles and practices. • Experience with conducting audits in enterprise environments. • Knowledge of software compliance frameworks and standards (e.g., ISO/IEC 19770). ...
I'm in need of a Wordpress guru who can meticulously comb through my website, inspecting all links, rectifying any errors and improving overall functionality. Key Tasks Include: - Conduct a thorough review of all internal links on every page, particularly focusing on the 'Services' page where I have noticed some issues. - Resolve any identified errors and improve the operational efficiency of the links. - Review a main navigation menu to include the following: 'Home', 'Services', 'Contact Us'. Your input on optimizing the structure and layout of this menu will be appreciated. - Utilize your Photoshop skills for some minor graphics work. Ideal skills for this job include: - Proficient in Wordpress and familiar with its menu structure. - Strong...
I am in need of a skilled professional who can assist me in setting up the Odoo Books system for my invoicing processes. Requ...Requirements: - Configure the system to enable the creation of goods and service invoices in USD. - Implement moderate customization to the invoice templates, focusing on layout changes and adding custom fields. - Import all of my product information from an Excel sheet. This includes product names and their respective cost prices (which are in INR). Ideal Candidate: - Proficient in working with Odoo Books and setting up invoicing processes. - Experience with customizing invoice templates within Odoo. - Skilled in data import from Excel sheets to Odoo. I look forward to working with a professional who can deliver these requirements effectively...
I am in need of a proficient excel wizard who can simplify my day to day tasks. While the specifics aren't in place, ideally I'm looking for someone who can efficiently perform data entry, come up with efficient formulas and functions, and provide comprehensive data analysis. Proper data formatting is key, for which I don't have a specific preference, however, creating simple tables, color coding cells, or using pivot tables and charts are all strong possibilities for this recurring project. Since no specific criteria was given, please do include your past work, experience, and a detailed project proposal when you apply. Skills and experience preferred: - Familiarity with advanced Excel functions and formulas. - Experience with data analysis and visualizatio...
I need an expert data analyst to clean and integrate data from excel files into a Power BI dashboard. Key Project Details: - The primary data source is excel files. It's crucial that the freelancer is proficient in Excel for extracting, cleaning, and transforming the data. - Dataset is farmers data including demographics and crop details. - The main focus of this project is on data visualization. I need the dashboard to present the data in a clear, visually engaging way. - The dashboard will be updated quarterly. Ideally, the freelancer should set up a process for this to be done efficiently and accurately. The task involves: - Understanding the data and the requirements for visualization - Cleaning the data to make it suitable for the dashboard - Identifying a...
Bonjour, je suis archéologue. J'ai du texte, des photos, des images, un document Excel a insérer dans un seul rapport paginé. Il faut faire la mise en page et transformer en PDF.
I'm looking for an Excel expert to create a costing sheet for a product. Key details for the job include: - It's mainly a costing sheet that will help me calculate the final price of my product based on material costs. Ideal Skills and Experience: - Proficiency in Excel - Solid understanding of financial calculations - Previous experience in creating costing sheets for products Looking forward to receiving your bids.
I'm in need of an experienced professional to develop an automation solution for my ERP system. The task involves incorporating manual item file changes from inventory forms into the system. Here are the key details: - **Required Changes**: The necessary changes that need to be integrated include Category, Internal Case Pack, Case alpha description, brand, and item code. - **Specific Fields**: For each item file, the fields that must be updated manually are Product name, Category, Internal Case Pack, and Case alpha description. - **Product Details**: The item file for every product should contain the Product name, Category, Internal Case Pack, and Case alpha description. The ideal candidate for this project should have a strong background in ERP systems and automation. Experience in...
Apple Account ready. Code ready. No issue. JUST UPDATE OF THE APP, NOT SUBMIT AS NEW Need immediately
...1. User Management - **1.1 CRUD Operations on Users** - Admins can create, read, update, and delete user accounts. 2. University Management - **2.1 Adding Universities** - Admins can add new universities, which will then be available to users. - Each university entry includes details such as name, location, and available courses. 3. Course Management - **3.1 Adding Courses** - Admins can add courses to specific universities. - Course details include name, description, and associated faculty. 4. Content Moderation - **4.1 Managing Posts** - Admins can delete any reviews deemed inappropriate or not compliant with platform policies. - Admins can perform CRUD operations on posts to edit or update details as needed. General System Requirements - **Security** ...
I require a detailed, easy-to-use Excel invoice template. The main features needed include: - Line items for products or services delivered: It's crucial that you add functionality for categorizing and detailing all the products or services delivered within the invoice. - Contact Information of both parties: The invoice must have dedicated sections to clearly present contact information of both the issuing and receiving party. - 1 page invoice in A4 size (fixed) with calculations based on user input amount. It's beneficial if you have profound knowledge of Excel and understand accounting principles to design the template in a highly organized and straightforward manner for ease of accounting tasks. Prior experience with invoice template design will be a great ad...
I'm looking to engage a freelancer skilled in data entry and Microsoft Excel to help type significant amounts of text data into an Excel sheet. Your responsibility will include: - Typing text data into an Excel sheet in an accurate and efficient manner. - Maintaining a consistent style and format throughout the entirety of the data entry. - Reviewing and proofreading your work to ensure absolute accuracy. You should display proficiency in Excel, attention to detail, and commitment to maintaining a consistent, professional style across all data. Please submit your bids along with an estimate of timeframe. Though the project completion timeframe was not specified, a timely delivery will still be appreciated.
...need of a skilled Python expert to transform a raw excel report into a final template version of excel. The project requires two main tasks: Formatting and re-arranging of columns along with calculation updates for one column. Key Points; - Need 3 open reports to pull the information and split the reports at the end. - Formatting Changes: The report needs specific columns to have pre-defined blank values for certain columns: Col B, E, J, R, W, AB, AE, AJ, AV, BG, BI, BJ, BQ, BU, BV, BW, BX, BY, BZ. - Calculation Updates: The calculation layer within the excel report needs to be updated and finalized. The ideal freelancer for this project should have a profound understanding of Python and extensive experience in manipulating and formatting excel repo...
Everyday I have to extract some datas from around 100 invoices (PDF files) and copy it to an Excel file. I do it manually (copy/paste), but I need a tool to have it done automatically. These invoices have a consistent format structure, and the fields I need to copy to Excel are always the same. They are informations like: invoice number, date, customer's name, product code, price, etc. All the fields that need to be on Excel are highlighted in color red on the 2 files I'm providing as an example. Any other info not highlighted in red, doesn't need to be on Excel file. The automation process must execute without fail, ensuring that the location of highlighted fields - which are always the same in every file - does not affect the extraction. The o...
I'm looking for a professional Excel user with a strong grasp of nutrition concepts to develop an advanced tool for me. Here's what I need: - A comprehensive Calorie Calculator - Macronutrient Calculator to recommend the optimal amounts based on three different goals: Weight loss, Muscle gain, and Maintenance - BMI Calculator - Be able to calculate these based off body weight, height, activity level, age and gender inputs The ideal candidate should not only be proficient in Excel, but also have a good understanding of nutrition principles. The faster this can be completed, the better.
I'm looking for an experienced Webflow developer to update certain sections of a website. 1. Scroller section with right side image sticky to be created. You may copy and use public webflow templates to acheive this but match colour and font of existing site. 2. Addition of headers and titles in some sections Make sure all work is responsive Please see drive for exact work - Please give exact bid and timeline. Would be great if you can start work now.
I'm looking for a skilled Affinity Publisher designer to create a monthly newspaper for the catering and hospitality sector. Key Requirements: - The newspaper should have a modern and sleek design, appealing to a wide audience. - Your task will be to create a stunning layout, incorporating the latest trends in graphic design. - You should be able to work with a monthly update schedule, ensuring the newspaper is ready for distribution in a timely manner. Ideal Skills: - Strong proficiency in Affinity Publisher, with a strong portfolio of previous newspaper or editorial design. - Ability to understand and match the aesthetic required for an advertising publication. - Excellent communication skills to ensure the publication meets our advertising goals. We will discuss monthly b...
I need an Excel 365 PowerQuery script that can fetch daily market data and handle potential data source interruptions or changes. I will be providing a URL that contains the market data, and you'll need to replicate the Google Sheets function =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). This function provides real-time data from the specified URL. Please note that the data is structured using HTML tags. Key requirements: - The PowerQuery should be able to be refreshed with the google sheet. - It needs to include robust error handling. If the data source is unavailable or the structure changes, the PowerQuery should not break but continue to function, ideally providing a notification that an error occurred
I'm searching for a talented full-stack developer to establish an e-commerce site akin to Shopify but entirely focused on the upload and download of digital files. Key Functionalities: - Implement user registration and login feature. - Develop robust file upload and download functionality for various types of files: documents such as PDF, Word, and Excel; images including JPEG, PNG, GIF formats; and media files such as audio and video. - Integrate a highly secure and user-friendly payment gateway for transactions. Ideal Skills for this Project: - Proficient in full-stack development. - Experience in building e-commerce platforms, particularly with user account management and file sharing features. - Strong understanding of payment gateway integration. - Ability t...
As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to d...
...being displayed after each selection until we exit the program): 1. Admit a patient The program will ask if the PCR test result is negative or positive and that will decide what type of patient we have and what information we will ask for. 2. Print patient information It will print all the patient information using the toString Method 3. Submit a PCR test result It will ask for the patient id and update the pcr test value for that patient. Any regular patient who gets a positive PCR test should be considered a covid19 patient from that moment. (Hint: copy old object data to the new object) a covid19 patient will be discharged if the PCR test result was negative. 4. Do rounds It will ask you to enter the current temperature for every Covid19 patient. It will treat all the pati...
We're on the lookout for a proficient Wordpress developer to assist with theme customization, plugin installation, and content update tasks. Experience is pivotal as we're not just looking for someone to get the job done but who can also advise us on better practices and improvements. Key tasks include: - Theme Customization: Help us modify our existing theme to better fit our brand and enhance user experience. It's vital that you have a solid grounding in PHP and CSS. - Plugin Installation: Evaluate, install, and set up necessary WordPress plugins that will add to our site's functionality. - Content Updates: Regularly update site content based on the needs of our evolving business. Given the nature of these tasks, we're not just looking for someo...
Adjustments to the Botanical Bliss render as discussed in PM. (adding 2" and adding a 2nd tape line).
I am looking for a freelancer with expertise in PowerBi and Excel. The task will revolve around creating a one-time report/dashboard on PowerBi sourced from a single Excel spreadsheet. The ideal candidate should have: - Previous experience with PowerBi and Excel - Proven track record of data analysis - Attention to detail Please note that the Excel file won't be changing over time, so there is no requirement for the PowerBi report/dashboard to be updated. Content Description: I have statistics from every UFC fight and want basic visualizations made (I have a rubric)
I'm looking for a skilled Python developer to create an Ant Colony Optimization (ACO) algorithm that can read numbers in a matrix to calculate the shortest distance and its respective cost. Key Features: - The algorithm should respect origin and destination points, which will be indicated by specific row and column numbers. - Ideally, the code should be able to parse a .xlsx file format. Desired Skills: - Proficiency in Python programming language - Experience with optimization algorithms, particularly the Ant Colony Optimization algorithm. - Familiarity with .xlsx file parsing. I already have a basic code and can provide it to you as reference material; however, I need someone to improve and expand on this code to meet the requirements. It is essential for the proposed so...
I need a power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: -Retrieve product ID, Quantity and Location -Gather specific production data including the production number. Ideal sk...-Proficient in DAX query language -Comprehensive experience with Power Bi -Excellent attention to detail -Previous experience in inventory data management will be a plus. What to do: I need to get a query in DAX (Power Bi) that gives me the same result as what I show in the excel file ( table ( column in yellow)). The excel file was obtained from the attached SQL query () The two screenshots show the power bi tables. I need to get a new column in power bi that shows me the results like in the yellow co...
Update android app to be supported android TV
I am looking for a skilled developer to create a Windows-based ...developer to create a Windows-based application that can interact with a remote database. The application should primarily focus on retrieving and generating website sitemaps based on different criteria. The ideal candidate should have: - Proficiency in Windows application development - Strong experience in working with databases, particularly remote databases - Knowledge in data retrieval and data update functionalities - Ability to understand and incorporate additional requirements as the project progresses Please note that the selected freelancer may need to provide examples of past work and project proposals. Note: Application should be able to connect different type of databases such as MS SQL Server, MySQL, O...
Hi Soumya Sekhar M.,can you provide me a support to update the faker app with a new
I'm in need of a skilled PHP/MySQL programmer to help me resolve issues with my legacy application. While the data in the current database isn't critical and can be easily recreated, the system is currently not allowing the addition or update of database records, although deletion is possible. Key requirements and responsibilities: - The main issue is resolving the problem of not being able to add or update database records. - There are no error messages displayed, so a deep understanding of PHP and MySQL is needed to identify and solve the root problem. - Once the issue is resolved, the next step would be to optimize the application to prevent similar issues in the future. Ideal skills: - Proficient in PHP and MySQL - Experience in working with and debugging leg...
Looking for someone to help update my linkedin profile
I'm in need of legal research focusing on probate, trusts and trust administration within Colorado, to support a forthcoming filing. The research will require identification of the relevant probate laws and legal codes in Colorado, specifically in the area of some specific aspects I will share in private. This summary should encompass the most current laws - so an update on recent changes in laws is important. The goal is to provide me with supportive applicable laws to my filing Ideal candidates for this project should be well-versed in probate law, specifically related to trust administration. A background in legal research and a familiarity with the Colorado legal system will be highly advantageous. Accuracy, attention to detail, and the ability to convey complex legal i...
...solid understanding of API integration. User interaction is another key aspect of this project. I expect the grid to support the following interactions: - **Click on rows to view details**: Users should be able to click on a row to view more detailed information about that entry. - **Edit data directly in the grid**: The grid should allow users to modify the data directly within the grid and update the database accordingly. - **Select multiple rows for batch actions**: Users should be able to select multiple rows to perform batch actions, such as deleting or updating multiple entries at once. Ideal candidates should have prior experience working with ag-Grid and implementing similar functionalities. Your understanding of frontend technologies, API integration, and user experi...
I'm seeking an Excel expert to create a user-friendly data entry workbook. The job is straightforward and requires the following: - **Data Entry:** The workbook should mostly focus on simple data, like names and dates. I am not looking for any intricate calculations, formulas, or pivot tables. The main focus is on creating an Excel workbook that streamlines the process of entering simple data in a structured and efficient way. Experience in creating user-friendly UX within Excel is a plus. No integration with external systems or services is needed - this is a standalone project. I look forward to collaborating with an experienced professional who can deliver an effective, easy-to-use data entry solution within Excel.
I require AutoCAD shop drawings for the intention of construction planning for a commercial building. The freelancer should include comprehensive architectural details. A strong background in creating accurate AutoCAD drawings detailing architectural specifics for commercial projects ...accurate AutoCAD drawings detailing architectural specifics for commercial projects is a must. The desired candidate will need a strong understanding of construction processes, especially within the commercial realm, to ensure every detail contributes to a seamless build. Your craftsmanship will directly influence our build strategy, so we expect precise and detailed work. Please only apply if you excel in AutoCAD and have direct experience in the realm of architecture and construction of commercial ...
I'm looking for a seasoned Excel expert to create a set of macros that can automate my data extraction process. Here's what I need: - Automate data extraction: The primary purpose of these macros is to enable automated data extraction from local files. The data in question is stock market data. The ideal candidate for this project would have: - Proficiency in Excel: You should have a strong grasp of Excel, particularly in designing and implementing macros. - Experience in data extraction: You should have a track record of successfully automating data extraction processes. Looking forward to hearing from you.
I'm looking for a skilled graphic designer to help me update my current logo. The task involves incorporating an abstract style 'X' letter behind the existing logo. Add X to my logo, on a white, black and blue background. Provide files as requested in the attached document for various uses marketing, print uses. Key Requirements: - Add the 'X' letter to the current logo as shown in the attachement. - Position the 'X' behind the existing logo Ideal Skills and Experience: - Proficiency in graphic design - Experience in logo modification/embellishment - Strong understanding of abstract design - Ability to blend new elements seamlessly with existing design
I have a magento webstore running on magento 2.3.4. I want to update it to the latest version with all patches, while maintaining current customers/database/products. I also want usps first class mail parcel/usps ground advantage to show up again as a shipping method.
I am looking for an expert in Excel to design a dynamic spreadsheet for project tracking. This spreadsheet will focus on monitoring task progress and deadlines. Key Features: - Daily updates: I will be updating task progress and deadlines daily, and so I need the spreadsheet to be user-friendly and efficient. - Task highlighting: If a task is falling behind schedule, I need it to automatically become highlighted in red. This will help me prioritize tasks and ensure no deadlines are missed. - This will need to show throughput for every phase and also provide an average through in volume. Skills and Experience: - Proficient in Excel - Experience in creating dynamic spreadsheets - Understanding of project management principles. I look forward to working with a detail-orien...
...going to be separate for all pages. The header is supposed to be a branch of a tree with the sitelogo on it in the middle. - On a desktop view we want the left side of the screen to have a tree trunk run along on the left till the footer And leaves on the right. - Footer content should include: Column 1: Small kalataru logo and under it social media links Column 2: About us Contact us Careers Kalataru Magazine Column 3: FAQs Returns and exchanges Shipping and Handling Terms of Service Privacy Policy Column 4: Sign up to our email Newsletter (Email ID text box with validation) (Subscribe button) - Integration with payment gateway (phonepe) - Cart and login mechanism should be OTP based and very direct and easy - Collect user data in a proper format (ip, usage...
Please read the job listing below before creating something. I need a logo designer who could give my logo a sleek revamp. It currently contains a truck, which needs to be replaced with a car trailer. Here's what the job entails: - Remove the existing truck element from the logo - Replace it with a single car trailer - Modify the existing text to fit my new business - Update the phone number as required Nicely's Trailer rental LLC 304-673-7378 Do not change to colors, font, or layout. The ideal candidate will have a keen eye for design, experience in typography, and a knack for transforming an idea into a visual. Your ability to work with different colors, layouts and elements will be vital in this project. Understanding my brand and channeling it into the redesi...
For this task, I am specifically seeking a freelancer who is proficient at data entry and familiar with Excel spreadsheets. The project primarily involves numeric data, so accuracy is vital. Key Responsibilities: - Input numeric data into an Excel spreadsheet. - Maintain a minimum 98% accuracy level. Ideal Skills and Experience: - Proficient in Excel. - High attention to detail. - Experienced in numeric data entry. - Proven track record of maintaining high levels of accuracy. Please ensure you have the necessary skills and experience before placing your bid. I look forward to your detailed proposals.
I need to manually add text and picture annotations to a PDF document . I have a pdf document but pictures do not show up some places in the document, I have the pictures and need someone to have two columns with the original on the left and add the pictures in a second column on the right of the original document where they should have been inserted . there are about 15 photos that need to be matched up . should not be more than 2 hours . also there are 8 names that need to be inserted wherever they show up in the document .
Need to extract data from website: , into an Excel file. Specifically name, discipline (medical practitioner, midwife, nurse, OT, physio, psychologist, podiatrist), location (incl suburb and postcode), initial registration date, registration expiry. There would be at least 100,000 rows of data. Only barrier, is this data is not able to be 'searched' efficiently. Individual names can be looked up. Or disciplines with a select number of names demonstrated...but I can't find a way to show ALL clinicians at once. Looking for a solution which can reliably pull all the names from the database.
I need an experienced web developer to adjust text and pictures on my website. - Update Text and Picture: The task involves replacing certain phrases within the existing text so it looks good when hovering over the text/picture of our existing provider. - Picture and Text Placement: I need a new provider's picture and text added to the 'Our Providers' section of the webpage. - Button Links: Additionally, the task includes changing a link so that it opens within the same window as the webpage, rather than a new tab. This will be required across several buttons on different parts of the website. Completion Deadline: This task needs to be completed as soon as possible. Ideal Freelancer: - Proficient in web development and website design. - Ability to work with...
I'm looking for an Excel expert who can build a simple yet effective sheet for basic arithmetic calculations. Key requirements: - Perform basic arithmetic operations: The main functionality of the sheet should be to perform basic arithmetic operations such as addition and subtraction. - Real-time collaboration: The sheet should support real-time collaboration, where multiple users can edit the Excel file simultaneously. Ideal skills and experience: - Strong background in Excel: The freelancer should have a deep understanding of Excel and the ability to create formulas for basic arithmetic. - Real-time collaboration proficiency: Experience in implementing real-time collaboration features in Excel will be highly beneficial. - Attention to detai...
I'm looking for a reliable and experienced data entry specialist who can assist me with entering data from images. The images will be directly uploaded to a website, and I need the data to be transcribed into various formats like Excel sheets, Word documents, and for copywriting purposes. Ideal Skills and Experience: - Prior experience with data entry from images - Proficiency in Excel and Word - Copywriting experience is a plus The primary goal of the project is to create a comprehensive database in various formats, so the ability to accurately transcribe and organize data is crucial. The chosen freelancer should have keen attention to detail and a high level of accuracy.
I need an expert to set up an automation system in Google Sheets for specific data from the NSE India website. Key Requirements: - Data Source: The data source will be '' - Data to be Integrated: Only the column titled '%CHNG IN OI' should be extracted. - Update Frequency: The automation should update the Google Sheets column once every day. - Data Display Format: The data in the Google Sheets should be displayed in percentage values. - Historical Data: No historical data tracking is required. The focus is solely on current updates from the source website. Ideal Skills: - Proficiency in Google Sheets and automation tools. - Experience with web scraping and data extraction. - Knowledge of data presentation and formatting in Google Sheets. -...