Web pages excel macro仕事

I'm looking for a Tally expert who can customize an automation script for me. The script should be able to import various data fields from an Excel file into Tally. At present we have to import the goods receipt data from excel file and material issues from excel file. The automation script should be robust and capable of handling errors and exceptions during the import process. Therefore, detailed error handling is a must. Your expertise in Tally and experience in creating automation scripts will be critical for the success of this project.

CRUD Products, Orders, Customers, Staff

Online WhatsApp Sales Representative Https:// We are looking for a motivated Sales Representative to work in the USA timezon...WhatsApp business account. Your Responsibilities: - Manage 50 hot leads each day from Facebook ads. - Follow up with customers from the previous day. - Aim for 1-2 sales per day. - Conduct weekly bulk marketing and promote special offers. - Record sales and customer information in Excel. - Submit daily sales reports. Compensation: - **Base Salary**: $250/month. - **Commission**: 5% on all sales. Schedule: - 6 days a week, 10 hours a day. Requirements: - Strong sales and customer service skills. - Proficient in Excel for tracking and reporting. - Excellent communication skills. If you're ready to help us grow and succeed, we want to hear fr...

I'm seeking a developer experienced with the Quick... I want to be able to monitor: - How quickly orders are being processed - Whether there are any delays in fulfillment The ideal freelancer for this project will have a strong background in working with APIs, particularly the QuickBooks Online API, and will be able to deliver a solution that will save me time and help me manage my orders more effectively. One File show the orderplan today in excel we like to list all order Estimate and then show the green where is the order in trello. every column with green is a list in trello. we need set up trello connection and what list we should list up in orderplan. We have building a system and doing the connection to trello and QB. we need someone take over and finish the orderplan...

...table 4. Sales Dashboard Quotation Creation Process: Inputs Required: 1. Material Code (MatCost) 2. Material Cost (manually retrieved from the web) (MatCost) 3. Factory Name(MatCost) 4. Currency (MatCost) 5. Quantity (MatCost) 6. Discount 7. Incoterms (3536_FCM) 8. Warranty (3536_FCM) 9. Opportunity Number (3536_FCM) 10. Customer Name (3536_FCM) 11. End User (Pipeline) 12. Sales Representative Name (3536_FCM) 13. Special Direct Cost (SPC) 14. Date (FCM_RR) 15. Payment Terms (3536_FCM) 16. Project Name (3536_FCM) Steps: 1. Input Automation • Populate all the required information above into the Full Cost Model (FCM), an Excel template file, automatically. FCM file template will be provided. 2. Price Calculation • Use the FCM to compu...

I currently have 4 landing pages held in WordPress. I have since set up a new CRM with Lead Connector where I can build my own custom landing pages and posts but I cannot integrate this with my new CRM. I need somebody to basically duplicate my current WordPress landing pages (4 of them) into Lead connector and make it look exactly the same as my WordPress landing pages. All the information is available in my WordPress account so this can be easily done by somebody who has experience with Lead Connector. I attempted this myself but found I just can’t get it to look exactly the same. Its important to me that the content and forms are build 100% identical to my word press landing pages. The candidate must have experience in working with both WordPres...

I'm in need of a detail-oriented freelancer to help with data entry tasks involving financial information into spreadsheets following our existing company template. Key Responsibilities: - Accurately entering financial data into spreadsheets - Utilizing our existing company template for data entry Ideal Skills: - Proficiency in using spreadsheets (Excel, Google Sheets, etc.) - Experience with financial data entry - Attention to detail to ensure data accuracy - Ability to follow specific guidelines and templates This is a great opportunity for a data entry specialist with a background in finance. Looking forward to your proposals.

CRUD Products, Orders, Customers, Staff

I need a freelancer who can extract data from structured tables in a PDF and input it into a spreadsheet. The ideal candidate should have experience in data entry and be proficient with Excel. Attention to detail is critical to ensure all data is accurately transferred.

I need help moving 1-2 of my business pages from my personal Facebook account to my business Ad page. The primary purpose of these pages is Community Engagement. Skills and Experience: - Extensive knowledge of Facebook's platform, particularly in relation to business pages and Ads - Proven track record of successful page migrations - Excellent understanding of community engagement strategies on social media - Strong communication skills and attention to detail

Je souhaite répertorier sur un fichier excel tous les restauranteurs d'une région (en France) qui sont également présents sur les réseaux sociaux (instagram principalement). Il me faudrait donc : - Nom du restaurant - Adresse - Téléphone - Lien sur les différents réseaux Si ceux-ci ne le sont pas, cela ne m'intéresse pas.

...to assist with text creation. Daily Targets: Successfully post a minimum of 160 links across the internet each day. Important: Only links that remain live and online will count toward your daily target. Links that are removed, deleted, or flagged will not be considered. Tracking and Reporting: Maintain a well-organized record of all links posted. Submit proof of work at the end of each day in Excel format, listing all successfully posted links. Work Schedule: Days: Monday to Friday Hours: 8 hours per day Skills & Requirements: Attention to Detail: Accurately track posted links and ensure they stay live. Efficiency: Achieve the daily target of 160 live links consistently. Online Familiarity: Ability to navigate various websites, forums, directories, and communities. Writin...

I'm looking for a comprehensive Excel budget sheet tailored for personal finance. It should help me track monthly expenses, savings goals, and debt repayment. Key Features: - Track monthly expenses: The sheet should have a clear layout for tracking all monthly expenditures. - Monitor savings goals: I want a section that helps me visualize my progress towards different savings targets. - Debt repayment tracking: I need a part of the sheet dedicated to my debt, with space for each individual loan or credit line. Built-in Formulas/Functions: - Automatic expense categorization: The sheet should have a method for categorizing expenses, ideally automating this process based on pre-set criteria. - Savings goal progress calculation: A built-in function to calculate how close I am to...

...include: Company Logo (provided upon project award) Consistent and modern design formatting Clear and organized layout for easy readability The design should reflect a professional and contemporary look that aligns with our brand identity. Both price sheets should be formatted for easy editing in the future (preferably in Microsoft Excel or Word). Requirements Proven experience in graphic design or document formatting Proficiency in tools such as Microsoft Excel, Word, Adobe Illustrator, or similar Ability to integrate branding elements (logo, color scheme, etc.) Quick turnaround time (please specify availability in your proposal) What We Provide Current price sheets Company logo and branding guidelines Deliverables Two separate price sheets (Distributor and Customer) in...

Llevo aplicaciones para manejo de negocios de diferentes clientes. Requiero que la persona tenga conocimientos en Bases de datos, Excel y, sobre todo, Appsheet. Algunas App ya están armadas y tengo que hacerles mantenimiento, testing y mejoras, otros proyectos debemos comenzar a construirlos. Solo se requieren algunas horas semanales, totalmente flexible!

Necesito un experto para solucionar y resolver problemas con las fórmulas de suma/resta en mi hoja de cálculo financiera de Excel, particularmente en la hoja de ingresos. Habilidades ideales: - Dominio de Excel - Fuertes habilidades matemáticas - Atención al detalle - Capacidad para resolver problemas - Experiencia con hojas de cálculo financieras

Excel expert to analyze my data. Your goal will be to provide insights from my data, so experience in identifying trends, performance metrics and conducting predictive analysis is a plus.

I'm seeking an Excel expert to analyze my data. Though specifics weren't provided, the ideal candidate should: - Have a strong background in data analysis - Be proficient in Excel - Able to derive insights from data - Capable of cleaning, transforming and aggregating data before analysis - Be proficient in performing statistical analysis in Excel - Expertise in creating and manipulating Pivot Tables - Utilize complex formulas and functions for in-depth data analysis - Create data visualizations using Excel charts and graphs - Capable of integrating data from multiple sources - Skilled in generating comprehensive reports based on the analysis - Ensure data accuracy through validation techniques - Identify and analyze trends in the data over time - Expe...

Hi there - I'll deliver the work as we have discussed. Thanks for the work!

Catalog should cover, Custom graphics, Table for dimensions, Custom infographics to explain product details, Showing product picture in details and illustrative way. I'm seeking a professional graphic designer to create a 4-5 page corporate brochure. The brochure's purpose is to appeal to potential clients and encourage them to request a quote. Key Requirements: - Proficiency in design software (Adobe InDesign, Illustrator, etc.) - Experience in creating corporate materials - Excellent understanding of visual communication and branding - Ability to translate catalog details from a provided document into a visually appealing and professional design Your design will need to balance professionalism with approachability, clearly presenting our company's offerings in a way t...

I'm looking for a proficient Excel expert to develop a simple yet effective project and task tracker template for me. It should accommodate tracking of daily, weekly, and monthly tasks. Key Features: - The template should include automatic updates. - Task reminders are essential to help keep track of deadlines. The design of the template should be simple and clean, avoiding unnecessary clutter while ensuring all necessary information is easily accessible. Ideal skills for this job include advanced Excel proficiency, experience in template creation, and an understanding of project management principles. Th image attached is an example of what it currently looks like. It is not formatted well and looks disorganized.

...one for Mac and the other for Windows. These scripts should navigate and complete application forms online using data from an Excel spreadsheet. Key tasks for the scripts include: - Navigating to the specified website and locating the application forms - Filling out the forms with user credentials sourced from an Excel (.xlsx) spreadsheet The scripts should be able to handle: - Login information for multiple users - Completing forms quickly and accurately Ideal candidates for this project should have: - Proven experience in creating automation scripts for form-filling - Deep understanding of both Mac and Windows operating systems - Proficiency in handling Excel data - Experience with online application forms Please note, the scripts will not require handling do...

I'm seeking a skilled WordPress developer to create a custom plugin that displays product prices based on SKUs. This price lookup will be shown on a separate page with a search bar for SKU inputs. Key Requirements: - Develop a custom WordPress plugin that displays product prices by SKU. - The option to upload the latest prices should be in the form of uploading an Excel Sheet - The last update date should be shown. - It should have the option to show custom Fields like Category of the Product being Searched , HSN Code and Tax % Ideal Skills: - Extensive experience with WordPress plugin development. - Strong understanding of SKU-based pricing systems. - Proficient in PHP, JavaScript, HTML, and CSS.

I'm looking for a proficient Excel expert to develop a simple yet effective project and task tracker template for me. It should accommodate tracking of daily, weekly, and monthly tasks. Key Features: - The template should include automatic updates. - Task reminders are essential to help keep track of deadlines. The design of the template should be simple and clean, avoiding unnecessary clutter while ensuring all necessary information is easily accessible. Ideal skills for this job include advanced Excel proficiency, experience in template creation, and an understanding of project management principles. Th image attached is an example of what it currently looks like. It is not formatted well and looks disorganized.

I'm in need of an Excel expert who can utilize the VLOOKUP function to assist me in matching customer information within a single Excel file. Ideal Skills: - Proficiency in Excel, specifically with VLOOKUP - Experience in data matching - Attention to detail for accuracy

I'm in need of an Excel expert who can utilize the VLOOKUP function to assist me in matching customer information within a single Excel file. Ideal Skills: - Proficiency in Excel, specifically with VLOOKUP - Experience in data matching - Attention to detail for accuracy

I need a comprehensive Excel sheet tailored for tracking employee work hours, overtime, and materials. This sheet should allow for easy manual data input. Ideal skills and experience for the job: - Proficiency in Excel - Prior experience in creating tracking sheets - Good understanding of time and material tracking - Attention to detail

I'm looking for an Excel expert to develop a comprehensive dashboard for sales data. This will involve defining key performance indicators, organizing data, creating a report, and generating histograms and frequency tables. Key Tasks: - Design and implement a user-friendly Excel dashboard for sales data. - Identify and define relevant KPIs, focusing primarily on the Inventory Accuracy Rate. - Organize the data in a meaningful way. - Create a comprehensive report. - Generate histograms and frequency tables. The data will not be updated on the dashboard. Therefore, it's crucial that the dashboard is designed to be static, yet insightful. Ideal Skills: - Proficiency in Excel, particularly in dashboard creation. - Experience with sales data. - Strong analytic...

I need a Power App created from my Excel data. This app will primarily be used by my internal team members to automate certain processes. Key Features: - Workflow Automation: The primary purpose of this app is to streamline our workflows. - Data Handling: The app should facilitate data collection and updates. Ideal Skills: - Proficient in Power Apps and Excel - Strong understanding of workflow automation - Experience in creating user-friendly internal apps This project is aimed at improving our efficiency by minimizing manual tasks and reducing the time spent on data handling.

I need an Excel expert to help me automate my change order form. This form is crucial in the construction industry for tracking additional work beyond the initial contract. Ideal Skills: - Proficient in Excel 365 - Experienced in creating and automating Excel spreadsheets - Knowledge of construction industry practices is a plus Requirements: - Automating the process of adding tabs for additional change orders (jobs can have between 1 and 20 change orders) - Automating the written dollar amount - Setting up pre-filling information for the next change order With this automation, I aim to streamline the process, reducing manual input and potential errors. Looking forward to your proposals.

Description: We are looking for a skilled graphic designer to create a professional and eye-catching flyer / social media creative for our "MS-Excel Mastery" course. The flyer will be used for online promotions and must effectively communicate the course details, benefits, and call-to-action. Reference: Please refer to the attached flyer for design style and content inspiration. We are looking for something along similar lines but with a fresh and unique look that aligns with our branding. Requirements: Course Details to Highlight: Course Name: MS-Excel Mastery Learn skills from Basics to Advanced. Perfect for: Students, Professionals, Business Owners. Admissions Now Open for the January 2025 Batch! Price: ₹5500 (Original Price: ₹6999). Course Highlights: 100% ...

Here i will put Logos and Images you can use. We are an online Marketing Agency, wich generates Leads for our Customers through Meta ads. I have designed a Lead magnet, but iam not even close to happy. I will put 2 Files here, one is the pdf i tried to copy and my own (inkl) the Content. I only need redisign. I dont want to have a 1:1 copy of the good pdf i will share with you, but it should be on this niveau from the design perspective. Our Font is Inter and we use the following colors: #000000 #ffffff #ebd48e #e9bc39 #e53816. Feel free to come up wtih your own design ideas. You know, in wich direction it will go. Thank you very much, im very interested in you ideas.

Necesito un freelancer que acceda a la web: y utilizando los siguientes filtros: - Órgano concedente -> Administración del Estado -> Ministerio para la Transformación Digital - Fecha de Concesión -> Desde agosto de 2024 a diciembre de 2024 - Título de la convocatoria -> Kit Digital - Instrumento de ayuda -> Subvención y entrega dineraria sin contraprestación Exportar en formato xls y unificar en un Excel con distintas paginas para cada mes la información que aparece en dicha web. Adjunto imagen de dicha web con los filtros puestos para julio de 2024

I'm looking for a seasoned Typescript developer with expertise in Palantir Foundry. The goal is to automate real-time monitoring through a Qlik Dashboard, using Foundry Functions and a mapping excel document. Key Aspects: - Real-time Analytics: The automation should focus on real-time monitoring. - Integration with APIs: The system will pull data from various APIs, so experience with API interaction is crucial. - Proficient use of Qlik: The automation will occur via a Qlik Dashboard, so familiarity with Qlik is essential. Ideal Skills: - Deep knowledge of Typescript - Extensive experience with Palantir Foundry - Proficient in Qlik - Strong understanding of real-time monitoring systems - Experience with API integration

I have a PDF file of 104 pages in A4 portrait format. I need pages 21 - 23 inclusive to be extracted to one new PDF file. I need pages 24 - 39 inclusive to be extracted to a second new PDF file. I need the certificate on page 39 to be extracted to a third PDF file and rotated so it is the correct way round on an A4 portrait finished document. ++++ READ THIS VERY CAREFULLY: I will only consider applications from freelancers meeting the following criteria: 1. You will be based in the EU. Applications from outside the EU will be rejected. 2. You will have all Freelancer verifications in place - ID (KYC), payment, email and phone. 3. You will have Preferred Freelancer status. 4. You will not add any comment to the Project Clarification Board. 5. You will write ...

Excel to Branded Adobe Forms Conversion as per discussed to design the excel and connect them to a QR code for students to download it.

DONT USE AI TO WRITE COVER LETTER. I WILL NOT HIRE BOTS. Write briefly if you can work under budget and can start immediately. Enter Excel file with recent projects I have completed, well organized, and categorised for future use and portfolio reference. My profile: https://www.freelancer.in/u/Ansaf1

I'm in need of a web scraping expert who can help me extract text data from a specific website. The project involves scraping user data and compiling it into an Excel file. Key Requirements: - Proficient in web scraping techniques, with a focus on extracting text data. - Able to deliver the scraped data in Excel format. - Prior experience in scraping user data is a plus. Please note: The data to be scraped from the website is exclusively text, with a focus on user data.

I'm looking for an Excel macro that validates IPv4 addresses, subnets, ranges, and TCP/UDP ports. Requirements: - The macro should validate only IPv4 addresses. - Upon detecting an invalid IP address or port, the macro should both show a warning message and highlight the cell. - The macro needs to validate IP address, subnet, range, and port. Ideal Skills: - Extensive experience in Excel and its macro programming. - Understanding of IPv4 addressing. - Ability to implement user-friendly error handling. PAYMENT WILL BE MADE VIA 25$ GIFT CARD.

DONT USE AI TO WRITE COVER LETTER. I WILL NOT HIRE BOTS. Write briefly if you can work under budget and can start immediately. Enter Excel file with recent projects I have completed, well organized, and categorised for future use and portfolio reference. My profile: https://www.freelancer.in/u/Ansaf1

...camera. A default user will be provided and other users will be pulled from a specified Excel file on the device. 2. Matching Activity: Users will scan three different QR codes, which the system will match. Each QR code has 4 fields, which the shall be processed and match logically. Add a container to add additional QR codes when a field does not match. once all matches, The user can press a button to save the record as an Excel file. There will be a Photo container that will lookup jpg file in device local folder, if one of the field from QR code is entered . 3. Report Activity: A simple list format for viewing saved data. Data Logged: The application will save user details and QR code data to Excel files in a specific location on the device. Ideal Skills: - P...

I'm seeking an experienced Excel professional to customize a workbook for tracking sales leads. The workbook should be user-friendly, as leads will be entered manually. Key Requirements: - Create a comprehensive and intuitive workbook for logging sales leads. - Incorporate advanced Excel functions to enhance tracking and lead management. Skills & Experience: - Proficient in Microsoft Excel with a strong understanding of its advanced functions. - Experience in developing and customizing Excel workbooks for lead tracking. - Previous experience in sales or lead management is a plus. Please note, the project does not require automating follow-ups or importing leads from other systems. The focus is on creating a tailored workbook for manual data entry.

...camera. A default user will be provided and other users will be pulled from a specified Excel file on the device. 2. Matching Activity: Users will scan three different QR codes, which the system will match. Each QR code has 4 fields, which the shall be processed and match logically. Add a container to add additional QR codes when a field does not match. once all matches, The user can press a button to save the record as an Excel file. There will be a Photo container that will lookup jpg file in device local folder, if one of the field from QR code is entered . 3. Report Activity: A simple list format for viewing saved data. Data Logged: The application will save user details and QR code data to Excel files in a specific location on the device. Ideal Skills: -...

...a country's sustainability indicators. Key Requirements: - Proficiency in Tableau with experience in creating interactive dashboards. - Ability to visualize economic data in an understandable manner. Please note that while I have not specified the primary indicators to visualize, All of the data, how I want it to be visualized and structured on the page will be given. I will send the expert excel sheets, data and instructions on where each data set should be inserted and how different data sets might link to each other. All I need is a somebody who can do the visualization part of the project and provide with a clean looking and presentable interactive dashboard ideally on Tableau, but any other tool would do for the sake of a better result. The primary purpose of this ...

I'm looking for a freelancer who can assist me with data entry. The specifics of the data entry tasks are not yet defined. I may need help with manual data entry, data extraction, and data cleaning. Ideal candidates should have: - Experience with different types of data entry - Proficient in using Excel and other data management tools - Attention to detail for data cleaning tasks Please note, the source of the data and the final format are yet to be determined. Therefore, flexibility and willingness to adapt to changing requirements are essential.

I require assistance with manual data entry from my digital files, predominantly Excel and Word. The data is mixed, encompassing both text and numeric components. Ideal Skills and Experience: - Proficiency in Excel and Word - Excellent attention to detail - Prior experience in manual data entry - Ability to handle mixed data (text and numeric) - Strong organizational skills

I need my sales data cleaned and sorted. The data is currently stored in Excel/CSV files and contains duplicates, inconsistent formats, and missing values. Ideal skills and experience: - Proficiency in Excel and data management - Experience with data cleaning and sorting - Attention to detail to identify and rectify data issues - Ability to work with large datasets

...will extract a specific dataset, compile the results, and deliver them via email on a daily schedule. Key Responsibilities: • Design and develop a custom script or tool to connect with public APIs of multiple platforms (Meta, TikTok, Craigslist, etc.). • Implement webhooks or scheduled tasks to fetch data once daily. • Process and compile the collected data into a structured format (e.g., CSV, Excel, or PDF). • Automate email delivery of the dataset to a specified email address. • Provide clear documentation for the tool, including setup and maintenance instructions. • Ensure data accuracy, error handling, and logging for troubleshooting purposes. Requirements: • Proven experience working with RESTful APIs and webhooks. • Proficiency in s...

...Easy for Techs who work remotely to access • We can design excel template for the timesheets which can then easily be cut and pasted into Xero (our accounting package which also does our payroll). • The documents are live However, we are unsure as to whether Google Docs will allow us to do the following: • Have 1 x Google Doc with individual tabs which can be quarantined/separated so that Techs can only view their own (and not other Techs) time sheets/tabs? • Allow 2 x payroll staff working at separate locations to edit the time sheets (individual tabs?) submitted by Techs and also make comments that are visible to payroll staff only and not to Techs. Please advise if you think you can assist and set up something for us with an excel template that we...

I need a professional to assist with updating the body content of my existing landing pages. The changes primarily involve updating dates within the text. Ideal Skills and Experience: - Proficient in English with excellent grammar and proofreading skills - Experience with landing page content - Ability to make changes promptly and accurately