Update closed workbook sheet using excel vba jobs

I'm in need of a professional to help populate my BIGIN CRM with contact information from an Excel file. The task will involve: - Transferring data from Columns A, B, C of my Excel file to BIGIN CRM. - Achieving appropriate data segregation based on geographic location within the CRM. This task will require a keen attention to detail and strong experience in and BIGIN CRM and integrate emails to Outlook. A solid understanding and experience in data segregation & bIGIN PLATFORM is also key for successful delivery of this project. The aim is to streamline my contacts for easier management. Your keen knowledge of geography and ability to dissect contact data is highly needed.

I am looking for a skilled designer to craft a visually appealing page(s) layout using a minimalist design approach by adding some pictures which will be provided along with our sample handouts and PPT attached. This project requires keen attention to aesthetics along with a good understanding of color theory, specifically the use of a triadic color scheme, to enhance the overall experience. Essential skills and expertise include: - Extensive experience in minimalist design practices - Profound understanding of triadic color scheme - Strong track record in creating visually appealing layouts.

...Magento website. - Creating backup files that encompass all necessary aspects of my website. - Completing a full site transfer using the created backup files to preserve integrity and functionality. You must have: - Expertise in website migration, particularly Magento sites. - Proficient knowledge in creating and using backup files. - Familiarity with hosting environments, specifically VPS. - Strong understanding of Magento 2. I am open to guidance on best practices for site transfers and backup file creation. This project requires a careful and knowledgeable freelancer, who can ensure a smooth and successful website transfer. Need help with setting up a Magento site using back up files. The freelancer should be able to do the following: - Help me set up my h...

I am seeking an experienced web developer to create a professional portfolio website for me. - The primary goal of this website is to showcase my work to potential employers or clients. - The ideal number of pages for the website would be between 5-6. - The design should be clean, modern and easy to navigate. - I would like to have a content management system that allows me to easily update the site with new projects. The ideal candidate would have a strong portfolio of previous work, particularly in portfolio website development. They should be proficient in relevant programming languages and platforms, and have a good eye for design. Good communication skills are also important to ensure that the final product meets my expectations.

As someone struggling with certain aspects of Excel 2016, I need an experienced VBA Developer who can assist in creating custom Excel functions and rectifying existing Excel errors. Key duties will include: - Macros programming to automate repetitive tasks - Troubleshooting and fixing inaccuracies in the current Excel functions, if any Despite my lack of specificity about the exact functions or errors, I expect the developer to have a strong understanding of Excel functions in general and to use this knowledge to identify any issues that may exist. Ideal candidates should: - Have significant experience in VBA development - Have a solid understanding of custom Excel functions - Be proficient in troubleshooting & error handling...

I will prepare a professional resume, cover letter and update his profile as well. I will also make changes if needed.

I need to have an excel sheet to track expenses made on each items coming under 'purchases for office construction works', stationery for office, project software tool like project management tools, hosting service plans etc also for nterior decoration, expense on inaugration and also i need to list expected cost for future purchases

I am currently in need of a proficient Excel expert capable of aiding me in data analysis for my investment data portfolio. The Ideal Candidate Should: - Have in-depth knowledge and experience in Excel, particularly in handling and managing large amounts of data with efficiency. - Be familiar with investment-related data and understand trends to aid in analysis. - Be able to demonstrate past work on similar projects, ideally in the investment sector. Project Scope: - The task involves in-depth data analysis of my investment portfolio which encompasses various types of data. - The freelancer will need to interpret and analyze the data using advanced Excel formulas and techniques. The successful freelancer should include their past work in their application. ...

I require an expert in Python and Excel to assist with data analysis and manipulation tasks. The central focus will be: - Data Reshaping: You'll be transferring data from daily received *.xls files to a timeseries database. Tee database must be updated regularly, every day when one or more new datasets are available. - Data Cleaning: This involves improving the quality of data in our Excel files. Inaccuracies are often a result of missing data, which you'll need to identify and rectify. Key skills and experience needed: - Proficient in using Python with Excel for data analysis and manipulation. - Expertise in data cleaning, particularly in identifying and addressing missing data, double occurences, inconsistent datas - Experience in reshaping...

I'm looking for a VBA programmer to help me with creating custom functions and macros for data analysis in Excel. Key Tasks: - Creating Macros: The project involves developing macros that can automate repetitive tasks and facilitate data analysis. - Building Custom Functions: I need custom functions to aid in data cleaning and manipulation, as well as report generation. Ideal Skills: - Proven experience in VBA programming, especially in Excel. - Strong background in automating tasks and data analysis. - Ability to develop custom functions for data cleaning and report generation. Output: - The generated reports should be in an Excel spreadsheet format, as well as a PDF document. Please provide samples of your previous VBA work, specific...

I have a powershell script that is made to work as a DNS utility that will allow me to create/delete/update DNS entries. It is not currently able to handle CNAME as i think it was made to handle A records based on the create scetion of it. I need it be able to do all 3 fuinctions on different record types with thier individual required inputs. One of the main problems im running into is it is not able to handle a hostname instead of IP4 when trying to run it. I need it done very promptly. Preferably today.

I'm seeking a skillful freelancer experienced in brand and identity design to quickly create an extensive brand style guide. This guide should include: - Modernization of Existing Logo - Modernization of color palette - Typography guidelines/modernization - Technical Data Sheet Templates - Brochure Templates - Letter Heads - Business Cards - Email Signatures The main objective of this project is to ensure consistency across all my marketing materials. Therefore, I need someone with a keen eye for visual continuity and attention to detail. With your expertise, let's bring brand consistency to life. Existing assets can be found at Please submit the completed guide as your submission

I need an expert in Amazon Web Services (AWS) to help me with Identity and Access Management (IAM) tasks for our Amazon S3 buckets. Key Tasks: - Setup IAM for User Management to control access to S3 buckets - Implement proper access policies to ensure security and compliance - Create a process for generating public links for files, and allowing us to manually update the file available for download Ideal Candidate: - Proven experience with Amazon S3 IAM and user/group management - Familiarity with AWS security best practices - Ability to create automated or semi-automated solutions for generating public links for file downloads - Strong communication skills to help us understand and manage the system going forward Feel free to ask for any additional details you might need.

I'm looking for a skilled MS Excel professional who can work on a multi-sheet file that requires data analysis, formula application, and design enhancements. Key Requirements: - Data Analysis: The primary aspect of this project is to analyze the existing data. - Formulas and Functions: Implementing formulas and functions to drive accurate calculations and insights. - Formatting and Design: Enhancing the visual appeal of the sheets, ensuring they are user-friendly and professional. The file contains 2-5 sheets, and I anticipate that the work will involve a mix of data analysis, formula implementation, and design adjustments. Since I've opted to complete the project, I'm open to any additional suggestions you might have to enhance the overall functionality of ...

I need a proficient Google Sheets expert who can help with customized formatting. The purpose of this formatting is specifically for project management. Key tasks will include: - Setting up customized formatting within Google Sheets - Creating a format that is optimal for project management - Ensuring that the formatting is user-friendly and intuitive for team members The ideal freelancer for this project will have: - Strong expertise in Google Sheets - Proven experience in customized formatting, particularly for project management purposes - Exceptional attention to detail

I'm looking for a talented graphic designer to update our current logo. Our plan is to transition the name of the business over a few years. See attached the existing logo and name The new name is FLUID POWER MECHANICAL We also want to change the icon to something more generic, not FP Then in 12 months we are going to change the name to POWER MECHANICAL So we would like two logos please • FLUID POWER MECHANICAL • POWER MECHANICAL Features o Same blue colour, or similar o Same or similar font so it is recognizable o I think keep it caps font o Perhaps the icon could be a wrench?

In order to effectively drive my ongoing project, I'm in need of someone skilled at gathering specific data and preparing it into a highly organized spreadsheet. The data needed include: - Name - Email - Job/Business - Phone number(Whats app) of (NRI) Non Resident Indians in UAE The ideal ca...specific data and preparing it into a highly organized spreadsheet. The data needed include: - Name - Email - Job/Business - Phone number(Whats app) of (NRI) Non Resident Indians in UAE The ideal candidate for this task should demonstrate: - Proficiency in data collection, and data management. - High level of accuracy and attention to detail. - Proven experience in sourcing data and utilizing Excel or similar spreadsheet software. Looking forward to advancing my project with ...

I need someone to transcribe the content of the picture to a excel as the same way. I have 100 picutures like this one. How much for this job?

I'm looking for a IoT/WSN security professional to address a Hatchetman attack vulnerability on a RPL protocol network using 6LoWPAN technology. The goal is to implement two robust security solutions that to prevent hatchetman attack occurrence in RPL routing protocol. Ideal Skills and Experience: - In-depth understanding of RPL routing protocols, Contiki 3.0 and Cooja Simulator - Hands-on experience with 6LoWPAN wireless technology - Proven expertise in IoT/WSN solution design and implementation Key Tasks: - Implement Hatchetman attack in Contiki 3.0 - Implement Resolution of Hatchetman attack using 2ACK scheme. - Implement Countermeasure to Hatchetman Attack using Multiple Encryption - Evaluate the two solutions with each other and with the standard RPL (RFC...

Please Sign Up or Login to see details.

...applications, API integration with eBay, and inventory management. The application will interface with aspects of my business (selling digital items) that are not typical for eBay, so off-the-shelf apps aren't capable of handling. It should be a standalone Windows app. Key features you should be able to develop: - Listing Quantity updates -- Update my local inventory count as items sell -- Pull from my local inventory files on demand and update quantities available on eBay accordingly - Order Tracking -- Alert on new orders -- Identify repeat customers -- Pull specific info from buyer note or buyer messages -- Help with fulfillment by pointing to locations inventory is available (i.e. from local files) -- Have a place to store images related to trans...

My Excel file is very heavy and unorganized. I want it to get cleaned and effecient

Hi Dream Dezine, I noticed your profile and would like to offer you my project. We can discuss any details over chat.

Google app script expert needed for stock price and data for world wide countries. Basically we have done for few countries we need you to replicate for more different countries, each country will consists about 8 google sheet types and some types may have dozen or up to few hundreds google sheets. Then some of the data needs be transferred and stored to SQL and taken from SQL by API also. This is team work, you will be working with bunch of server guys and python guys. So you need to possess these abilities and criteria : 1. Able to make google sheets fast, make editor for the GS fast and send all of the Google sheets ownership to me. 2. Able to work on SQL and API. 3. Able to collaborate as a team. 4. Agile, fast delivery, and responsive 5. Integrity, Honesty, Independently ini...

I'm looking for a social media manager to help me with my small, home-based massage therapy business. Key Responsibilities: - Manage and update my Facebook, Instagram, Twitter, and LinkedIn accounts - Prioritize Facebook and Instagram for marketing purposes - Help attract new clients through social media - Engage with current clients and encourage referrals - Drive foot traffic to my clinic Ideal Candidate: - Experienced in social media management, preferably in the health or wellness industry - Expertise in utilizing Facebook and Instagram for business purposes - Proven track record of attracting new clients through social media - Excellent communication skills to engage with current clients and encourage referrals - Understanding of the massage therapy or broader wellness ...

...- Strong communication to understand the omnichannel support required - Design skills for an intuitive and attractive in-app experience NOTE THE ABOVE DESCRIPTION WAS AUTO CREATED BY Freelancer, but I found it might be usefull. = SPEC-01: AI-Powered Auto-Broker Application Development - MVP == Background This project involves developing an MVP for an AI-powered buyers' agent auto-broker app using FlutterFlow and completing an existing partially completed app design(see images). Developer should be able to integrate existing tools and services to maximize development speed and cost efficiency, laying the groundwork for more advanced features in later phases. The app leverages the MarketCheck API for automotive data and employs AI technologies to enhance the car buying ex...

...business owner, if you are agency, sales manager or project manager pls do NOT accept 04. we dont mind if u are just a small team. as long as responsibility, work hard, fast respond and quality. 05. Respond message to your client even after working hour, sat or sun & public holiday 06. we only deal with team with fast respond, quality, friendly, good attitude & responsibility 07. prepare daily update in googlesheet 08. in some discussion will go by zoom & will request permission from freelancer before project start 09. reasonable new features charge and willing to accept minor features request by client even not status earlier. 10. Reply message to your client even after working hour, weekend even public holiday. Issue will happen anytime. 11. First priority respond t...

...Net Maui. The app is utilized on both iOS and Android platforms. Key tasks include: • Deliver full conversion from Xamarin to the latest .Net Maui framework • Replace the current ZXing barcode library • Determine and implement a suitable alternative barcode library like , or others that meet my project specifications (refer to the attached requirements) - Add lesser fixes and update requirements (see attached) • Ensure compatibility across both iOS and Android platforms The ideal candidate should have: • Extensive experience in Xamarin and .Net Maui • Deep understanding of barcode libraries • Proven track record in app development that focuses on transformation and integration. This is an exciting opportunity for a person ...

I’m looking for a freelancer proficient in Excel who can create a dynamic tool for my restaurant business that helps in managing my food costs and menu pricing calculations. Key responsibilities include: 1. Cost Analysis: Crafting a spreadsheet that can factor-in: - Food cost percentage - Gross profit margin - Break-even analysis 2. Menu Pricing: The spreadsheet should provide calculations on: - Menu item profitability - Menu item pricing based on the desired profit margin Ideal candidates are detailed-oriented and have substantial knowledge in cost analysis and pricing strategy in the restaurant industry. Excel expertise including functions and formulas is paramount. Past experience in successfully building such tools will be a definitive plus.

I need a simplistic, one-page website linked to a database. This page will have limited content, including a logo and a 'check authenticity' button. The database will be provided in an Excel sheet format, and must be integrated seamlessly into the page. Key Requirements: - Develop a one-page website - Integrate an Excel database for product authentication - Provide a clean, simplistic design Ideal Skills and Experience: - Experience in web development, particularly one-page websites - Proficiency in database integration, specifically Excel - Ability to create clean and minimalist designs - Strong understanding of web security and authentication processes

Please Sign Up or Login to see details.

I'm seeking an expert in data analysis to help with profiling and analyzing our financial data. The ideal professional will have the following experience and skills: - Proficient in financial data analysis - Able to generate comprehensive analytical reports - Experienced in Excel for data presentation

I'm looking for a 5kW solar inverter specifically designed for residential usage. It should be equipped with a battery backup system to ensure continuous power supply during outages. Key Requirements: - 5kW Power Output: The inverter should be capable of handling 5...battery backup compatibility is essential. - Residential Solar Solutions: Previous work on residential solar projects, understanding the unique requirements of this environment. - Battery Backup Experience: Knowledge of battery systems and their integration with solar inverters will be highly beneficial. Please provide details of your relevant experience in your bid. Please refer this sheet for project specifications

Hi Dmytro, i have a new domain that i would like added to our server ( ) with SSL please. Also, if you have time, update any packages please?

I am seeking a qualified web developer for the construction of a com...construction of a comprehensive business website. The primary goal of the website is to serve as an informational platform, displaying details and images of the various products and/or services my business provides. Key project requirements: • Build an organized, easy-to-navigate business website • Incorporate a section for detailed product descriptions and images • Ensure the website design aids easy update of content The ideal freelancer for this project would be experienced in business web development, content management systems and have a knack for visual design. A background in product marketing could prove beneficial, as understanding how to attractively present product details is a key co...

I'm searching for a skilled Virtual Assistant (VA) to manage a small inventory of less than 100 entries. Your responsibilities will include: - Data entry: Accurately inputting necessary information into our system. - Spreadsheet management: Expertly organizing and managing our inventory data in Excel. - Reporting: Creating clear, concise, and actionable reports based on the inventory data. To execute these tasks proficiently, you should be well-versed in the SUMIF and Pivot Tables functions in Excel. Prior experience in managing small to medium-sized inventories will prove beneficial. Your ability to pay attention to detail, demonstrate excellent problem-solving skills, and deliver results in a timely manner will be important for success in this role.

Create Dashboard for Data in Excel Sheet

My Oshine WordPress site, , is completely down. I need an expert to get it back up and running, as well as incorporate a number of updates to the site. Key tasks include: - Resolving the issue that's causing the website to be down - Updating the theme and plugins - Merging content from two existing sites In addition, I need assistance in: - Fixing broken portfolio links and adding new items - Training for me to self-manage site content Ideal candidate should have: - Proficiency in Oshine WordPress theme - Experience in troubleshooting and resolving website issues - Knowledge of content management and consolidation - Good communication skills for training - Ability to work in a timely manner to ensure the website is operational as soon as possible.

summarize in a specific table in Excel

Hi Ravi Ranjan K.,I have a task of import of purchase excel to tally prime for now .

I'm in need of an expert in Excel for data entry and cleaning. The tasks involve handling text-based, numeric, and date & time data. Key Responsibilities: - Perform accurate data entry - Cleanse and format the data as needed Ideal Skills and Experience: - Proficiency in MS Excel - Proven experience with data entry and data cleaning - Attention to detail - Ability to work with various data types, including text-based, numeric, and date & time data

I'm in need of someone who can help me make a few minor edits on my website. The primary task at hand is updating articles, but I'm unsure yet if I want to update all or only specific ones. It's a political website so needs to be updated for the upcoming election with new articles. Should only require a few minutes of work to swap out article links

I am currently using ZOHO Books and am looking to migrate to Odoo Accounting. I need an Excel expert to help with the migration process. Key Tasks: - Migrate complete set of invoices and bills from ZOHO Books to Odoo Accounting. - Transfer all customer and vendor details accurately to Odoo. - Ensure that financial reports are maintained and migrated correctly. Ideal Candidate: - Proficient in both ZOHO Books and Odoo Accounting software. - Excellent experience in data migration and Excel. - Familiar with maintaining and handling large databases. - Detail oriented, ensuring data integrity throughout the process. This is a large scale project as my current ZOHO Books database exceeds 1000 records. I need someone who can efficiently and effectively handle the migrati...

I'm in need of a proficient data entry specialist to assist with a substantial volume of data entry work. This is a very basic task, a lead scraping website doesn't allow me to export data. So we will copy and paste from one website to a google sheet. There are 2,241 entries needed This project will take ~20 hours I am attaching a screenshot of the picture of the website and of the spreadsheet

Answer the attached question correctly, and briefly explain. using principles of subnetting. I'm looking for an expert in networking who can provide correct answer and clear and concise explanation of the attached question. Answer the attached questions, the provide table of the subnets Accepted file format Excel or Word

...amaryahenna.com. The purpose of this website is to sell my products online seamlessly. Key Information: - Type of Store: E-commerce - Volume of Products: Less than 50 items - Website Example: Site Requirements: - Intuitive navigation and easy to use checkout system - Mobile-friendly design - Product pages with high-quality images and detailed descriptions - Engaging and easy-to-update blog section - Basic SEO settings Missing Elements: - I have yet to develop a logo and complete brand identity, so your expertise will be crucial in this area. Ideal Candidate: - Proven experience with WordPress and Shopify - Portfolio of E-commerce sites, ideally small-business focused - Strong UI/UX design sense - Basic SEO understanding - Logo and brand identity development skills Let'...

I'm in need of a professional to write concise yet comprehensive reports. Details regarding the purpose and type of reports were not specified. Ideally, the freelancer should be adept in creating performance analysis, expense tracking, project updates, financial, sales, and progress reports as all these may be requested. T...were not specified. Ideally, the freelancer should be adept in creating performance analysis, expense tracking, project updates, financial, sales, and progress reports as all these may be requested. The frequency of generating these reports is also yet to be confirmed, so preparedness to deliver on a daily, weekly, or monthly basis is essential. Superior skills in data analysis, proficiency in excel or other relevant software and report writing is a must fo...

...proficiency in Excel, especially in performing statistical analysis using frequency distribution and creating informative visualizations. To get specific, the scope of work involves: - Converting my Excel sheet data into meaningful insights via statistical analysis - there is 12 workbook, represent date palm trees five varites. - each tree has branches which is recorded in the cell. -some trees did not produce - need a colorfull charts that represent branches . IF BRANCH IS 0 MAY BE WE COLOR RED. IF ONE WE GIVE OTHER COLOR, IF 10 MAY BE GREEN. - NEED TO HAVE THE SUM OF BRANCHES TOTAL NUMBER IN EACH WORK BOOK - BRANCHES MAY PRODUCE 4 KILO OR 5 KILO: NEED TO HAVE A FORMULA THAT I CAN CHANGE AND KNOW THE TOTAL PRODUCTION OF EACH WORKBOOK AND THE...

...seeking a Python developer who can automate certain calculations in my existing Excel files. The calculations that are currently done manually in Excel need to be automated. This means the Python script you develop will need to accurately and efficiently perform these calculations every time it runs. As for the frequency, the system should run calculations on demand. This way, I can trigger it whenever I need the numbers updated. The calculations are based on the data currently stored in my Excel files. So the script will need to read this data, perform the necessary calculations and update the files with the new results. The ideal candidate should have: - Proficiency in Python - Experience in working with Excel files - Understanding of automati...

I need assistance with entering inventory data into Quickbooks Desktop from an Excel file. - I'm looking for a professional who has experience with Quickbooks Desktop. - The job involves bulk data entry, focusing specifically on inventory. - You will be provided with an Excel file containing the inventory data. - Attention to detail is crucial to ensure accurate and efficient data entry. Ideal skills: - Proficiency with Quickbooks Desktop - Experience with data entry, particularly inventory - Attention to detail and accuracy in data entry - Familiarity with Excel files and their import into Quickbooks