Vba excel lock columns refreshing sheetpekerjaan

I'm looking for a graphic designer who can create an engaging, modern styled CD jacket design. Key elements that need to be included: - Band's photo - Logo - Abstract art ...creative eye for incorporating abstract art. You'll need to be able to harmoniously blend these elements within a cool color palette. Previous experience designing CD jackets or similar would be fantastic. I need my CD jacket designed. I have included an example of what I am looking for with measurements and everything. I want it designed with 2 inserts so I can insert the CD in one and a lyric sheet in the other one. All I have is the cover picture and a picture that will go inside. I have no idea for the rest of it. I'm hoping you guys can come up with that. The title of the C...

I am currently dealing with a troublesome iCloud activation lock on my iPhone. Unfortunately, I don't have access to the Apple ID or password that's linked to this lock. On my own, I've attempted a few online methods to dismantle this lock, but none have been successful. I'm seeking a freelancer who has: • Expertise in iOS systems • Proven experience in iCloud activation lock removals • Ability to troubleshoot and resolve Apple ID issues This project will be considered successful upon removal of the iCloud activation lock in a manner that leaves the device in full working order. Your understanding of Apple's security infrastructure would greatly benefit this project.

I am looking to significantly revamp my home's exterior in order to increase its c...include: - Window replacement: To maintain a unified style, the new windows should complement the modern rustic look. - Addition of front dormers: Designed to integrate seamlessly with the existing structure while adding to its visual appearance. - Stone and siding: Both these elements should be curated carefully to bring the essence of the modern rustic style to life. Experienced freelancers who excel in exterior home remodeling with proficiency in modern rustic designs would be ideal for this project. Critical abilities include an eye for design, detail-oriented work, and the capability to execute window replacements and dormer additions smoothly. Previous experience working on similar proj...

I'm looking for a professional who can help me generate contact information (name, email, and phone) for leads suitable for my direct email marketing campaign. Key Responsibilities: - Develop a robust strategy to identify and collate data from various sources. - Ensure the data is accurate and up-to-date. - Organize and present the data in an Excel spreadsheet format. Ideal Skills: - Experience in sales lead generation. - Proficiency in using data collection tools. - Strong analytical and organization skills. - Knowledge of email marketing best practices. Experience in direct email marketing or a CRM system would be a bonus. The successful candidate will be meticulous and detailed-oriented, with the ability to deliver high-quality, targeted leads to support my marketing ef...

... You can demo it here - We have modified the front end to support uploading data in and XLS format instead of JSON. The data parsing is working but we are looking to improve the data validation to alert the user of specific problems with their data they are uploading. Input data: Sheet 1: Work Order Tab Name, Address 1, City, State, Zip, Technician Sheet 2:Technicians Tab Name, Starting Address, Starting City, Starting State, Starting Zip, Ending Address, Ending City, Ending State, Ending Zip Some of these fields can be blank. Useful validation for the user will be required. See this documentation regarding the json format The XLS sheets will correspond

...Google Sheet and transferring it to 10+ different multi-page website forms that require unique login information. Additionally, the program should generate PDF documents on the target websites based on the transferred data and save them with named files corresponding to the original Google Sheet. It is crucial to incorporate error handling, data validation, mapping, and security measures into the program. If you are interested in working on this project, please provide details of your relevant experience and approach for ensuring its successful completion. The program must be compatible with the MAC operating system. Mapping Automation Parsing web-based Form entry transfer automation Designed to be easily expanded and modified to accommodate additional fields and website...

EXCEL VBA + EXCEL EXPERT. Please check video attachment and excel file and tell me if you can do this. Quality of proposal cover letter is always #1. Be #1. This will take 1 hour to code and complete if you know what you are doing.

I'm looking for a data analyst to scrape LinkedIn data and create a series of analytics from the information. Linkedin Recruiter or Premium Account will be needed for this task. Output should be presented in Google Sheets or EXCEL.

I need a virtual assistant for a daily one-hour task to input visitor information into a Google Sheet. Key Requirements: - Attention to Detail: It's important that all information is entered accurately and completely. - Manually need to collect data from various source Ideal Candidate: If you are a detail-oriented individual with prior data entry experience and can commit to a daily one-hour task, I'd like to hear from you.

I'm in need of a Python developer to create a script that will convert data from a Google Sheet into individual text files. Key Requirements: - Data Handling: You should have experience in handling data from Google Sheets, and be able to efficiently transfer it to text files. - Unique ID Generation: The script should include a mechanism for generating a unique ID for each text file. This ID should be randomly generated. - Custom Header or Footer: Each text file should have a custom header or footer. Ideal Skills: - Proficiency in Python - Experience with Google Sheets API - Strong understanding of data handling and file creation - Knowledge of random ID generation - Ability to add custom header or footer to files

Hola de nuevo Martín, qué tal estás? Espero que todo bien. necesito pasar algunos datos, son cuentas anuales de una empresa, son cuatro años de datos de 2010 a 2014, cada año tiene seis páginas de datos y cada página tendrá como 10 datos, Te interesa? Un saludo. Sería insertar los datos de los archivos que te adjunto, solo los datos de activo, patrimonio neto y pasivo y cuenta de pérd...todo bien. necesito pasar algunos datos, son cuentas anuales de una empresa, son cuatro años de datos de 2010 a 2014, cada año tiene seis páginas de datos y cada página tendrá como 10 datos, Te interesa? Un saludo. Sería insertar los datos de los archivos que te adjunto, solo los datos de acti...

I require proficient excel skills to create two distinct spreadsheets. The first spreadsheet should focus on an immediate expense breakdown, specifically highlighting repair costs as an individual category. Knowledge in business accounting would be advantageous to ensure accurate representation of financial data. The second spreadsheet requires a CAPEX table, based on an example I will provide in PDF format. Freelancers will ideally have: * Expertise in Microsoft Excel * Background in accounting or financial planning * Detail-oriented and able to follow a provided example * Ability to create easy-to-understand, visually appealing spreadsheets Please assure that the work is precise and completed on time.

tugasnya hanya mengetik macam macam barang yg di beli di tamplate excel yang sudah saya sediakan beserta menghitung rumus sederhana perkalian dan pemjumlahan

I am in need of a proficient Google Sheets wizard who can utilize their expertise in managing and modifying spreadsheets for a specific task. I am interested in adding dynamic drop-downs to the cells in the ranges A1:A1000, B1:B1000, and C1:C1000 in Google Sheets. Key aspects for my project include: - Dynamic Population: These drop-downs must be dynamically populated and each row should maintain its independence from other rows. - Dropdown Values: The values for the initial dropdowns (A1:A1000) are derived from a specific list on Sheet2 of the Google document. - Manual Updates: The values on Sheet2 will be updated manually by the user. The perfect candidate should possess the following skills: - Advanced knowledge in Google Sheets: You must be able to easily navigate Google Sheets ...

Negocio gestionar excel - Importante: conocer ingresos + gastos para obtener el neto. segundo: conocer IVA de ingresos + IVA de gastos para saber cuánto pagar al trimestre y poder anticiparme. tercer: entender los ingresos si es por cantidad de clientes o por modificación de tarifa IVA DE ESPAÑA - COMUNIDAD DE MADRID PONER LOS EXCEL ENTENDIBLES Y BUENA GESTION PARA ENSEÑAR A INVERSORES

...existing Excel VBA project that interfaces with AutoCAD 2020. I'm looking for an experienced VBA developer to update the current functionality. Key Requirements: - This project involves updating an existing Excel VBA tool that works with AutoCAD 2020. The tool is currently used to generate data in Excel extracted in AutoCAD drawings what can be easy changed and send back to the relevant Drawings. You will be required to maintain the current functionality while also enhancing its capabilities. - The existing tool is aimed at automating the process of generating Excel data from AutoCAD drawings based on. The updated version should be user-friendly, and should ideally also allow for some form of automation of repetitive tasks within A...

I need someone to consolidate data from multiple Excel sheets. The data in these sheets consists of both text and numeric values. The goal is to bring all this data together into a single sheet, while handling duplicates in a distinct manner. Key elements of the project include: - Merging text and numeric data from several Excel sheets into one - Handling duplicate entries by marking them without removing - Organizing the data by grouping it as per the provided sheets separately Ideal candidates should have: - Proficiency in Excel and experience working with data consolidation - Understanding of handling and marking duplicate entries if any - Ability to accurately organize and group data Your task will be to create a consolidated view of text and numeric data...

Hi Work-Nix Solutions, I would like to work with you again please on refining the great Excel-spreadsheet that you have helped me to build.

Hired already client is aware of details

Task: Redesign the attached floor plan. Requirements: - 2 Foyers (North Entrance and South Entrance) - 4 Bedrooms - 1 Kitchen (same location) - 2 Bathrooms (same location) - Dining Room - Living Room 2D furniture sample for each room. Notes: - Structural columns are marked with red circles. - The locations of the North and South Entrances, Kitchen, and 2 Bathrooms are fixed. Please include the code printed on the attached PDF of the current plan in your proposal to confirm that the project details have been thoroughly reviewed. Thank you.

I'm in need of an Excel developer who can aid me in analyzing data, creating advanced formulas and functions, and programming macros. With your expertise, the primary goal is to develop an Excel file that will be used to generate various reports. Ideal Skills and Experiences: - Proficient in Excel data analysis and manipulation - Experienced in creating advanced formulas and functions - Able to implement macro programming - Adept in generating insightful reports from complex data Our goal is to provide you with an exportable dashboard in Excel, a tool that will efficiently display opportunity details per property and provide a dedicated area for your notes. Opportunities that meet the threshold should display the value. The dashboard should be sortable a...

Sila Dafter atau Log masuk untuk melihat butiran.

I have a project that involves exporting a question paper to PDF format in two columns with alignment. The purpose of this task is to facilitate the printing of the question paper. Key Elements: - The question paper is in Latex format. - The script was written in Laravel and uses Vue.Js and Inertia.Js. - The PDF should feature a two-column layout with proper alignment. - The header and footer should include page numbers and a custom logo or school name. I am looking for a skilled developer who has experience with Laravel and Vue.Js, as well as the ability to work with Latex and PDF files. The ideal candidate should have a strong understanding of layout design for PDFs, and be able to demonstrate experience with similar projects. The project has a high priority and needs to be comp...

Sila Dafter atau Log masuk untuk melihat butiran.

I am in need of a Senior Financial Analyst to assist with our company's financial modeling, forecasting, and data analysis and reporting. The ideal candidate must be familiar with various financial concepts, data analysis, and proficient in the use of Microsoft Excel, Tableau, and QuickBooks. Key Responsibilities: - Develop and maintain financial models for our operations and future forecasts - Analyze and interpret financial data - Prepare regular reports on financial performance - Utilize Microsoft Excel, Tableau, and QuickBooks for data management and analysis. The candidate must have significant experience in financial modeling and data analysis, preferably in a senior role. The ability to communicate complex financial information in a clear, concise manner is hig...

Hi everyone, I am looking for a freelancer who is able to help me with a Magento 1 task. I got a template: ‘’Porto theme’’ and I can’t find out how to build / structure pages properly. The manual is not sufficient for me. How can I integrate the page structure ...contacted the developers: ‘’P-themes’’ and they suggested to go into the folder: ‘’app/code/local/Smartwave/Porto/etc/import’’ on the server, but from there I don’t know how to integrate these (short)codes on the page properly. Hope you can help me integrate it and explain how to build a page this way. There are some other pages that I want to structure properly, so your help is appreciated to create columns and other theme functions. My ...

I'm in search of an individual who is both tech-savvy and creative, capable of designing and editing an Excel-based yearly budget tracker for my department. This document must not only be functional, but visually appealing, making use of our company's branding and in a way that ensures user-friendliness. Key Requirements: - Creating a Comprehensive Tracker: I need a budget tracker that can calculate data and maintain it in a clear and organized manner, reflecting both incoming and outgoing finances. - Visual Appeal: This tracker should not be a typical, boring spreadsheet. It should feature vibrant colors and bold fonts, while still maintaining a clean and simplistic design. Additionally, it should incorporate our company's logo and color scheme to ensure it's o...

Hi everyone, I am looking for a freelancer who is able to help me with a Magento 1 task. I got a template: ‘’Porto theme’’ and I can’t find out how to build / structure pages properly. The manual is not sufficient for me. How can I integrate the page structure ...contacted the developers: ‘’P-themes’’ and they suggested to go into the folder: ‘’app/code/local/Smartwave/Porto/etc/import’’ on the server, but from there I don’t know how to integrate these (short)codes on the page properly. Hope you can help me integrate it and explain how to build a page this way. There are some other pages that I want to structure properly, so your help is appreciated to create columns and other theme functions. My ...

...Detection In terms of output, I require the processed videos to generate a Metadata file, which ideally is formatted into an Excel or CSV file. This data should include details such as date, time, classification, and direction. While I do have an Azure account for hosting and I am comfortable with it, I am also open to suggestions on which programming language would be the best fit for this project. The ideal freelancer for this task should possess the following skills and experience: - Proficiency in Python, C++, or Java - Familiarity with Microsoft Azure or similar - Experience in image classification and object detection - Ability to create Metadata files in Excel or CSV format. Remember that while these are the core requirements, I am open to suggestions and m...

I'm in need of a tool that can effortlessly upload text information from an Excel document to a website form on a daily basis. The tool should also facilitate the mapping of Excel columns to the corresponding fields in the website form through a user-friendly interface. Key requirements include: - Daily automated upload of data from Excel to the website form - A straightforward, user-friendly interface for mapping Excel columns to website form fields - Accurate and efficient transfer of text information - A secure and reliable tool that ensures data integrity Ideal candidates for this project should have: - A strong background in web development with experience in form automation - Proficiency in Excel, including working with data ext...

I have a simple powerbi poject. I have a dataset in excel based on which i need a table in the dashboard. I also require a filter to filter the rows The filter should be based on 3 columns in the table. In the dataset a user can be in more than one column. for example lets say the 3 columns are A, B and C. the values can be A, B, C or blank in those columns. user X had values A, B and blank in the columns A, B and C In this case if you filter the data using value A from the dropdown, it should show user X also if you select B. However if you select value C in the filter the user/row will not be present.

...inputting it into an Excel spreadsheet. The key aspects of the project are: - **Data Extraction:** This involves comprehensively retrieving data from various websites. Some sites may have more complex structures, requiring the freelancer to navigate and extract data accurately. - **Excel Formatting:** The extracted data needs to be entered neatly into an Excel spreadsheet. - **Advanced Level Detail:** The data extracted should be detailed and comprehensive, including historical data and analytics where relevant. The ideal freelancer should have experience in web scraping and data entry, as well as a good understanding of Excel. They should be meticulous, capable of handling potentially complex website structures, and able to work with a high level of det...

I'm looking for a SEO specialist to help me to improve the traffic on my website. The focus is on local search engine optimization / onpage-seo. ## Note: - I need only an instruction excel - list. The language of the page is in german, but an online translation tool can be used. - No Plugin will be used, but other proven SEO - Tools are possible. Key Responsibilities: - On-page SEO analysis to identify the status of the page (one page, homepage) - You will send me your seo recommendations for onpage optimations - You will use a seo tool (we discuss which one is best) - I only need a written instructionfile what should be done at page, - start asap - Time: 2 hours a week for one month Ideal Candidate: - experience with on-page SEO for websites - Strong analytical skills ...

Hi Nadia A. The project is: Research and identify qualified 1,000 sign manufacturers /stores /sellers /suppliers (that sell signs) across Germany. Compile the leads data into a Excel format.

...digitized and transformed into an Excel spreadsheet. The document consists of approximately 238 pages, and I require the following: - Organization: Calls, texts, and data should be separated into distinct columns in the spreadsheet. - Data Layout: The information should be laid out in an ordered manner which we will discuss further. Additional requirements include: - Calculations: The Excel sheet should include specific calculations like total call duration and data used. - Data Fields: The "To/From", "City", and "Time" fields should be organized in distinct columns within the spreadsheet. Ideally, I'm looking for a freelancer with: - Proficiency in PDF to Excel conversion. - Strong organizational and data ...

I have a list of 2060 SKUs in an Excel sheet that I need corresponding images scraped from Website A. Each image should be saved with the SKU number as the filename (e.g., for SKU 32440). Key Requirements: - Scrape images from Website A for 2060 SKUs - Save each image as a high-resolution jpg with the SKU number as the filename Delivery: - I will provide you with the Excel sheet containing the list of SKUs via email. - You should deliver the images in a compressed file with 2060 images, each named according to the corresponding SKU. Ideal Skills and Experience: - Experience in web scraping, particularly image scraping - Proficient in Excel for managing SKU lists - Ability to deliver high-resolution images - Attention to detail to ensure correct match...

I'm in need of a talented designer with strong illustration skills, specifically in using Midjourney and Adobe. You need to be experienced with creating character consistency using MJ using their --CW and --CRef functional...Midjourney and Adobe. You need to be experienced with creating character consistency using MJ using their --CW and --CRef functionality. I need someone with past experience. I have a character I created in MJ and I want to first turn him from the current 3D style, into a Duolingo character style with a little bit more depth. I need the style to be compatible with Rive Animation. I need a character fact sheet as well for a few interactions. Ahmed is a visa officer. If you can just more depth to the character, beyond Duolingo, but still somehow 2D, that will...

ITALIAN LANGUAGE MANDATORY. Starting from a list of 12500 Company names in excel, we need to fill in the other columns finding online: - website URL - Zip Code - VAT Number - Type of Industry (selecting it from the excel drop down menu)

i want to be data entry job use word, pdf , excel , PowerPoint , and any type of graphic design work . i have 3 years teaching experience with data collection , data entry , and graphics design . i have fully and wonderful experience in Microsoft office , excel, PowerPoint , photoshop , illustrator, CorelDRAW, filora

...therefore need top-quality leads to contact, and they have to meet 2 criteria: 1. The business should NOT have a website (Facebook, free websites etc. are ok) 2. The business MUST HAVE a contact phone AND e-mail. The businesses need to be in the home service business in the UK (Plumbing, Electrician, Roofer, Mason, Painter, Cleaner, Pest control, etc.) We need a CSV file with the following columns): BUSINESS TYPE BUSINESS NAME BUSINESS ADDRESS BUSINESS ZIP BUSINESS CITY BUSINESS LOCALITY (IF APPLICABLE) BUSINESS E-MAIL BUSINESS PHONE BUSINESS SOCIAL LINKS (IF APPLICABLE) SOURCE FOR INFO! (this is the source where you got the info from) I say high-quality leads because when we cold-called samples earlier half of them had websites and some was wrong number and some where close...

For this project, we need to consolidate customer data from multiple Excel files into one Excel sheet using macros. This will allow us to manage our data more efficiently. Key tasks include: - Creating a macro that can extract and merge customer data across several Excel files. - Managing the data in a way that it is grouped by Customer ID. Skills and Experience: - Extensive knowledge in Excel and proficiency in creating macros. - Prior work experience with data consolidation projects. - Exceptional attention to detail. - Ability to organize data effectively. - Knowledge of data management according to customer demographics.

I'm in need of Revit expert to craft a custom template for me. Key Deliverables: - **Pre-set levels, plan views:** I'll provide you with the specifics, you set them up. - **Detail-oriented columns, joists, beams, trusses:** I'm looking for these to be detailed with basic dimensions and parameters. - **Standard line types, dynamic families:** Including those you need to create from scratch. - **Sheets and basic Revit components:** Your role includes not just setting up the template, but also ensuring it's well-documented and easy to use for someone with intermediate Revit proficiency. Ideal Skills: - Proficient in Revit, with demonstrable experience creating custom templates. - Strong understanding of architectural and structural components and design. If you...

I'm in need of Revit expert to craft a custom template for me. Key Deliverables: - **Pre-set levels, plan views:** I'll provide you with the specifics, you set them up. - **Detail-oriented columns, joists, beams, trusses:** I'm looking for these to be detailed with basic dimensions and parameters. - **Standard line types, dynamic families:** Including those you need to create from scratch. - **Sheets and basic Revit components:** Your role includes not just setting up the template, but also ensuring it's well-documented and easy to use for someone with intermediate Revit proficiency. Ideal Skills: - Proficient in Revit, with demonstrable experience creating custom templates. - Strong understanding of architectural and structural components and design. If you...

...data from Excel Sheets. The goal of this task is to determine if the presented ad spend had a significant impact on total sales or sales in our stores. The data spans from May 2016 to May 2024. Key Requirements: - Compile ad spend data from Google Ads and Facebook Ads, and sales data from Excel Sheets. - Perform trend analysis on the data sets to determine if any discernable impact exists between the ad spend and sales. - The focus should be on whether ad spend, regardless of platform, led to a measurable and discernable difference in sales. Ideal Skills: - Strong data analysis and interpretation skills. - Proficiency in working with ad spend and sales data. - Experience with trend analysis and correlation studies. - Proficient in Google Ads, Facebook Ads, and...

Hi, i am looking for help with a solidwork project. I want to build tuned pipe , expansion chamber for dirt bike. I do know all my dimensions lenght and diameters. I want to be able to draw a line wich will be my centerline and then on this line i want customize every lenght and diameter of each section. Then had radius in sections. I would lik...point to be able to adjust length and diameter for each my subsection. Because each pipe is build with many differents cones -Each section/cone needs to be customable on the amount of flat pattern needed. Each flat pettern are to be angle from both edges Steel plate thischness will be 1mm All dimensions are to be outside diameter. I want to be able to enter all my dimensions and length on an excel sheet(edit table) that will be inclu...

...leveraging historical data from their Investor Relations (IR) presentation and Annual Report. This will include a thorough examination of revenue and cost factors along with balance sheet and cash flow analysis. Task 2: Potential Acquisition or Investment in the 'Foods' Category by Dabur Objective: Draft two to three slides outlining the opportunity and rationale for Dabur's potential acquisition or investment in the 'Foods' category. Suggestive Approach for Task 1 1. Data Collection: - Gather historical financial data from Marico's IR presentation and Annual Report, focusing on the income statement, balance sheet, and cash flow statement. - Supplement this data with relevant industry reports to understand market trends and forecasts...

Translation of two files, from English to Hebrew. File #1 contains 8 rows of text in Excel format, 119 English words. File #2 contains 85 rows of text in Excel format, 2,035 English words.

Búsqueda/Recopilación de Datos: Búsqueda de Correos Electrónicos para Empresas Tecnológicas - Estoy buscando un freelancer que pueda ayudarme a recopilar direcciones de correo electrónico de una lista de empresas. - El propósito de este proyecto es recolectar datos para fines de investigación. - El freelancer ideal debería tener experiencia en recopilación de datos y ser competente a la hora de realizar investigaciones en línea. - El proyecto requiere recopilar un número sustancial de direcciones de correo electrónico de una muestra de aproximadamente 4800 empresas. - La atención al detalle y la precisión son cruciales en este proyecto para garantizar la validez de las direcciones de co...

We have a list of around 4,795 energy consultants. This list contains the name of the consultant, the company name they work for, contact information including general email address, telephone number, website, and address. However, we need you to find out the personal corporate email address of each consultant, and insert it into Column K in the Excel sheet. Check the attached file. Time : 48 Hours Budget 50$ Lowest Bidder will win Milestone Payment : no advance milestone payment. After Completed work get payment. Thanks

I'm seeking a freelancer to correct the date format in my Excel sheet that is currently not displaying correctly. Key Requirements: - The Excel sheet must display dates in the format DD/MM/YYYY. Additional Details: - The corrected date format is only required on specific sheets within the same workbook, not all sheets. Ideal Skills & Experience: - Proficiency in Excel and its date formatting functions - Experience with correcting date format issues in Excel - Attention to detail to ensure all specified sheets are updated correctly.