Excel macro list worksheet names sheet jobs

I'm currently working on an Excel sheet for performance analysis and I need assistance with writing the SUMIF formula. Key Requirements: - Assist with writing the SUMIF formula for my Excel sheet (vlookup, countif, and other formulas are not needed for this project) - Ensure the formula fits within the context of performance analysis Ideal Freelancer: - Experienced in Excel and in particular, writing SUMIF functions - Knowledge of performance analysis or related fields is a plus

I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me resolve these issues promptly.

I have a piece of work that I am wondering whether you might be interested in. In summary, I need to build a 'white label' web interface, that collects information from my various clients, and then feeds that information back to my company. I have the planning for this all mapped out. If you think it is something you might li...information from my various clients, and then feeds that information back to my company. I have the planning for this all mapped out. If you think it is something you might like to assist with, please let me know and we can make a time to catch up and discuss. There is also the possibility of two websites that will also need to be designed in conjunction with the web interface. I already have the domain names and registrations, so it is just a matte...

I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can help me streamline my data management processes and turn this data into comprehensib...

I'm looking to compile a comprehensive list of e-mail addresses from various companies. This list will serve as our contact database for marketing outreach purposes. The ideal candidate for this task should have the following qualifications: - Proficiency in internet research and data mining. - Previous experience in compiling e-mail lists for marketing purposes. - Strong organizational skills to categorize the e-mail addresses by company name. - Ability to cross reference collected e-mail addresses against our existing list of company names to ensure no duplication. The e-mail addresses should be those of general contacts within the companies, rather than specific executive or departmental level personnel.

I'm looking for a skilled Excel professional to help me create a custom inventory dashboard. Key Requirements: - The dashboard should focus on inventory management, specifically, visualizing product stock levels. - The data should be arranged in an intuitive manner that allows for quick and easy inventory tracking. Ideal Skills & Experience: - Strong proficiency in Excel, particularly in creating visually appealing and user-friendly dashboards. - Experience in inventory management, with an understanding of product stock levels and their relevance. - Attention to detail as accuracy in data representation is crucial for this project. - Good communication skills and a proactive attitude to ensure the project's success. Please note that due to the nature of this...

I am blending Google Sheet data with Google Ads and Analytics data but getting an error message. Need someone to help via screenshare. Thanks!

I'm in need of a proficient Excel expert who has a solid understanding of Excel macros and compatibility issues with Excel for Mac 2018 or later. The project involves assessing and modifying an existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior experience with Excel for Mac comp...

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 an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projected in one place as a dashboard.

I'm looking for a skilled Excel professional to clean a text-based dataset for me. The dataset is not massive, but it's quite messy. The data cleaning task is relatively straightforward and basic. You'll have to perform operations such as removing duplicates and adjusting formats. Ideal Skills and Experience: - Proficiency in Excel: You should be comfortable working with large datasets in Excel, including applying formulas and functions. - Data Cleaning Expertise: Prior experience in cleaning text data is a major plus. - Attention to Detail: The devil is in the details; I need someone who won't overlook small nuances in the data set. Once the data is cleaned, I'll need you to carry out some basic analysis on it. This will involve running s...

I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Excel skills in a practical, real-world setting.

...and Managers/Administrators: This system is primarily for the use of employees who will be responsible for carrying out the tasks listed on the job cards and the managers/administrators who oversee these tasks. Employees will need access to all past completed, active jobs, quotes, parts and customers. Managers will need to have access to send the completed job to QuickBooks, add / remove employee names and set an hourly labour rate. Ideal Skills: - Proficient in PHP and MySQL - Experience in developing web-based forms - Knowledge of job management systems - UX/UI Design capabilities for a user-friendly interface Please see the attached Specification PDF or view at: Please consider the functionalities I'm looking

Develop macro-enabled Excel file to handle CSV

I'm looking to create a PVC card that will serve as a loyalty card for my fashion brand, Auraya, in collaboration with other brands. Key Requirements: - The card should include the customer's name and contact details, the Auraya brand logo and name, as well as the logos and names of the collaborating brands. - The design should be minimalistic and modern in style. Distribution: - The PVC cards will be handed out in person Ideal Skills and Experience: - Graphic Design: A strong portfolio of minimalistic and modern designs is crucial. - Branding: Experience creating cohesive branding materials for multiple brands. - Loyalty Program Design: Knowledge of loyalty card design and customer information incorporation is important. below is the same of what info the card shou...

I'm in need of a professional who can convert a PDF document to Excel format. The PDF contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience in converting PDF documents with mixed content to Excel while maintaining layout integr...

...Folder name "iXBRL" , inside folder contain multiple html file(hundreds to thousands), each html file contain multiple tables(vary from 15-35, depend on each html file). Python to extract specific table and vertically stack them together to create an Excel file.(first column add html filename.) inside html file is encoded in chinese, so must use chinese to view it. table name/string partially e.g. "現金流量表" or "被投資公司名稱" or "資金貸與他人"or "轉投資大陸地區" or other name(later can be change). extract table based on table names/string. the table may not be there(depend on the html). If so just skip or single row blank. have to be easy to read and maintain in the future. .py file(source code) not .exe binary file (I think it's ...

My objective is to create short duration (5-10 minutes) documentary-style videos showcasing interesting video footage of your local models for our platform. We are hiring freelance video photographers like you, to shoot easy fashion style video shows with local female models you recru...you invite to model for you, and we pay you from US$500 per shoot project, more once you become familiar with shooting for us. ModelsUpClose are video entertainment producers,  hiring video photographers from across the world in fashion style General Exhibition video shows since 1997.   It is essential we agree on your proposed model before starting a project. We have a Job Specification sheet to ensure your success and can discuss storylines and themes to suit you and your models...

Need someone to go through one of my company bank statements for the last 8 months and prepare both years financial statements (profit/loss and balance sheet).

I have a project that requires purely text data entry. I have a set of handwritten notes which need to be entered into a spreadsheet. Key Requirements: - The data is text-based, and it's crucial that the freelancer can transcribe this accurately and efficiently. - Proficiency in using spreadsheet software like Excel or Google Sheets is a must. Ideal Skills: - Fast and accurate typing skills - Proficient in using spreadsheet software - Experience with data entry, especially from handwritten sources

...Project Scope: • Research and identify qualified sign manufacturers/companies/suppliers/sellers/stores across France. • Utilize various online resources, including: o Search engines (Google, Bing, etc.) o Social media platforms (Facebook, Instagram, LinkedIn) o Industry directories and publications (list specific resources if known) o Business databases (mention specific databases if known) • Gather and verify contact information (name, email, phone number) for each lead. • Compile lead data into a Excel format . Qualifications: • French reading and understanding - ONLY • Excellent research and data collection skills. • Proficiency in using online search tools and social media platforms. • Strong attention to detail and accuracy. &b...

I need an Excel tool that can sort data by category and provide users with an interactive experience. I'm looking for an experienced Excel developer who can create a user-friendly, yet advanced, Excel tool. The tool should have the following features: - **Filtering**: The tool should allow users to filter data by category. This is a crucial aspect of the tool's functionality, as the data will be organized by this field. - **Interactive Buttons**: I would like the tool to have buttons that allow users to sort data. When a button is clicked, the data should rearrange itself based on the selected category. For example, when a user clicks on the button related to 'Category A', all data entries related to 'Category A' should be displayed. -...

I have a 5-10 minutes MP3 file that needs to be transcribed urgently. I need the transcription to be accurate and in a sheet format. Ideal Skills and Experience: - Proven experience in audio transcription - Ability to deliver high-quality work under tight deadlines - Proficiency with sheet formatting - Strong attention to detail This is an urgent project, so I am looking for someone who can start right away and deliver the transcription quickly. If you have the required skills and can meet this deadline, please bid on this project.

From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.

I need an employee time tracking system on Google Sheets. The system should automatically calculate total hours worked, allow for marking ...Features: - Automatic Calculation: The system should calculate the total hours worked by every employee within the specified date range. - Attendance Tracking: There should be an option to mark employees as present or absent. - Project Details: Each row should contain fields for the project number and name. - Multi-employee Handling: The system should accommodate multiple employees' data in a combined sheet. Skills and Experience: - Proficient in Google Sheets - Experienced in creating automated time tracking systems - Familiarity with employee attendance tracking - Ability to create a user-friendly interface that can handle data for mult...

We are building a financial application whereas you can put money hence our AI works on it through big data and automation. The project is about algorithmic auto-investing trading on world wide's financial market. Fixed Rate Job Paid based on success delivery per country. $10/country. Make about 5-10 API/country for installing python, setting SQL for our applications and Google Sheet. For each country may need API for such as : 1. Historical Data 2. Financial Scrapped Source 3. Financial Summary Scrapped Source 4. Interest rate 5. Some More Required Skill & Experience : 1. Php & SQL 2. Familiar with python installing & setting up environments 3. Experienced in Linux Debian & LNMP server by SSH 4. You need to know on how to run python scripts on debian by ssh,...

I'm looking for a professional who can help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple format for my tables, in line with a minimalist style. Ideal Freelancer: - Proficient in Excel, with a deep understanding of formula creation. - Experienced in table formatting and design, with a flair for minimalism. - Able to deliver high-quality, error-free work in a timely manner.

I'm looking for a skilled professional who can assist me with updating product information on two PDFs. Additionally, I need a one-page "specials" sheet created with a professional and corporate style. This sheet should be in line with our company's branding guidelines. Key Tasks: - Update product information in two PDFs - Design a one-page "specials" sheet - Ensure the design is professional and corporate, adhering to our branding guidelines Ideal skills and experience: - Proficient in Adobe Acrobat for PDF editing - Strong graphic design skills and experience in creating corporate designs - Ability to follow existing branding guidelines while designing new assets - Attention to detail to ensure all changes are implemented accurately ...

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. 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 looking for a skilled Power BI developer who can create detailed financial reports and dashboards, primarily based on data from Excel spreadsheets. Key Responsibilities: - Develop compelling, visually appealing reports and dashboards that are easy to interpret and navigate. - Tailor the reports and dashboards specifically to financial analysis, ensuring they provide the insights necessary for informed decision-making. Ideal Candidate: - Proven experience creating financial analysis reports and dashboards in Power BI. - Proficiency in integrating data from Excel spreadsheets. - Strong attention to detail and the ability to translate complex financial information into clear, concise visual elements. This project requires a high level of expertise in Power BI, fin...

I'm seeking a seasoned back-end engineer with expertise in Node.js and MongoDB. Your primary responsibility will be developing APIs that integrate seamlessly with external services. Key tasks include: - API development: You should have a proven track record of creating robust, efficient APIs. - Integrating with third-party services: The APIs ...scalability is crucial, even if it is not explicitly stated as such by the client. Ideal skills and experience for this job include: - Proven track record of API development in Node.js - Strong understanding of MongoDB - Experience in integrating various third-party services - Prior work on projects with high performance and scalability requirements If you believe you have the necessary skills to excel in this role, I encourage you t...

We are seeking experienced lead generation professionals to assist in identifying companies raising equity capital for a growing company over the next 3-6 months. Ideal candidates will have a strong background in financial services and...well-researched leads in specific industries. 2. Retainer: £1000 per month. PROCESS 1. Lead Research: Identify and research potential leads. 2. Email Outreach: Send emails to prospects. 3. Response Handling: Forward prospect responses to the business developer. 4. Scheduling: The business developer will schedule and conduct the sales calls. 5. Data Management: Upload researched data to our CRM in Excel format to ensure no duplications. If you are a driven lead generation professional with the required experience and skills, we would love to...

I'm looking for a skilled SAP FICO consultant with expertise in the Financial Accounting (FI) module. The selected professional will primarily handle: - General Ledger (GL) management - Accounts Payable (AP) - Accounts Receivable (AR) - Bank-related activities Additionally, you will be required to generate key reports including: - Profit and Loss Statement - Balance Sheet - Cash Flow Statement Ideal candidates should have in-depth experience managing the above tasks within the FI module. Extensive knowledge of SAP FICO and a keen understanding of financial reports are vital for this role.

...following features. 1- A list of all invoices (Master List) with the field names I will provide. 2- A list of all Contracts with the field names I will provide. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. The database should have a login page. After Login, there should be a a Main Page, with link to the above mentioned list pages plus, Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages. For Add New Invoice page, I should be able to add an invoice details in it, and if it's related to a contract or purchase order, I should be able to a...

I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently using Word 2010 and will be working with Java/Spring/JavaFX for the programm...

I've developed a database using MongoDB for dummy user data. I need an expert to review and enhance it in terms of schema design and security. Key Aspects for MongoDB Schema Design Review: - **Naming Conventions**: Ensure the names of collections and fields align with established conventions. - **Data Types**: Verify that the data types are correctly assigned and appropriate for each field. - **Indexing**: Check if indexes are set up and utilized effectively. Security Measures and CIS Benchmark Review: - **Authentication and Access Control**: Validate that the authentication mechanisms and access controls are properly implemented. - **Encryption and Data Protection**: Review the existing encryption measures and data protection strategies. - **Auditing and Logging**: Ensure th...

I have a list of 50000 urls, I would like to scape the pages to see if they contain references to scripts - I will provide a list of the urls and the scripts. Deliverable should be an excel with the 50000 urls and whether they contain the link for each script. Looking for fast turnaround

...br/pesquisa/cid10) A script or tool that can take a list of CRM and CID numbers as input. Automate the search process on the specified websites. Extract the required data and compile it into an Excel file with separate sheets for doctors' information and disease descriptions. Requirements: Programming Language: Preferably Python. Libraries: Experience with web scraping libraries like BeautifulSoup, Selenium, and data processing libraries like Pandas. Output Format: Ability to export data into an Excel file using Pandas or similar libraries. Error Handling: Robust error handling to manage failed requests and parsing errors. Compliance: Adherence to the websites' terms of service and rate limits to avoid being blocked. Project Scope: Input: A list o...

...Google Sheet with Tranferz API. We need the API to retrieve and update data on our sheet based on the following specifications: - Fetching and updating Driver Information: The API will need to fetch and update data related to drivers. This includes their availability, current location, and other relevant details. - Displaying Ride Details: The API should be able to fetch and display ride details for each driver. This information is crucial for the drivers to efficiently manage their schedule and assignments. - Updating Payment Information: It is essential that the API updates payment information in our Google Sheet. This includes payments received, pending payments, and other financial details. I'm looking for a professional who can ensure that this data is u...

I'm in need of a skilled freelancer who can assist me in collecting contact information for recruitment companies specifically operating in Saudi Arabia....this data, please share it in your bid. Skills/Experience: - Strong research skills - Data entry and data mining expertise - Proficient in Saudi Arabian business landscape - Attention to detail and accuracy - Web scraping - Web search - Leads Results should be in an excel sheet format, outlining the name, position, email address for each contact. Contacts for each company should be grouped together, end file should be in 1 sheet, not separate sheets. Send me: 1- Your strategy in finding those companies and collecting names and emails of relevant employees, 2- Total number of expected VERIFIED leads, 3...

...Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 300 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, ...

Hello, I need convert a PDF invoice to Excel to import to our invoices software

I'm looking for an experienced Power BI developer to create bespoke reports and dashboards, which will be integrated into Microsoft Teams. Tasks: - Handling data from Excel spreadsheets and converting it into insightful reports and dashboards. Skills and Experience: - Strong command of Power BI for report and dashboard creation. - Proven experience with Excel spreadsheets. - Good knowledge of integrating Power BI into Microsoft Teams. The goal is to make complex data easy to understand, facilitating better decision-making within our team. Your work will directly impact our day-to-day operations and strategies.

I am in need of a specialized WordPress developer with experience in Excel operations and data showcasing. Key tasks: - Create a WordPress page that extracts numeric and text data from an Excel sheet. - Implement highlights and color-coded information on the webpage for better readability and understanding. - The data on the Excel sheet will be updated on a monthly basis, hence the website should be able to fetch the data automatically upon any modifications. Ideal skills: - Proficiency in WordPress and Excel integration - Experience in creating visually appealing data showcases or infographics - Strong understanding of data extraction and display technologies The aim is to have a user-friendly webpage that accurately represents the update...

I'm in search of an Excel expert who can assist me with complex tasks in Excel. Specifically, help is needed in two key areas: - Formulas & Functions: While basic arithmetic operations are simple for me, I need assistance with text and date functions. - VBA Macros: I'm looking for someone who can develop advanced user forms and interfaces. This requires a high level of VBA expertise. The ideal candidate would have a strong background in Excel, with a focus on formulas, functions, and VBA. Previous experience working on advanced macros and a deep understanding of text and date functions will be a huge plus. The ability to communicate effectively and understand my specific needs is essential.

I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently using Word 2010 and will be working with Java/Spring/JavaFX for the programm...

I need an AutoCAD expert to help me make some modifications to existing DWG drawings. - The main task is to flip and rotate the drawings so that the garage is on the right side. - The title blocks also need an update to complete the modific...make some modifications to existing DWG drawings. - The main task is to flip and rotate the drawings so that the garage is on the right side. - The title blocks also need an update to complete the modifications. Additionally, the foundation sheet must reflect a 3-course stem wall with footer. Ideal skills: - Proficiency in AutoCAD - Experience with architectural drawings - Ability to update title blocks - Attention to detail for flipping and rotating drawings - Ability to accurately reflect a 3-course stem wall with footer on the founda...

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

I'm looking for someone who can design a sophisticated budget template for me in Excel. This template should: - Track both income and expenses - Project weekly outcomes - Compare actual amounts to budgeted amounts - Include more than 20 budget categories - Incorporate graphs and charts for visual representation. Skills necessary for this project will include advanced Excel knowledge and experience with financial modeling. The ideal candidate will have previously worked with complex budget templates and be comfortable creating a user-friendly interface. You should know how to devise a system that simplifies input and keeps data organized and easy to understand. Your ability to turn raw numbers into straightforward graphs and charts will be particularly valuable. I cu...

I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.