Save web files excel vbaJobs

I'm seeking a professional who can make an Excel page from a word document and then make it auto organize for our department. This job requires an ability to create a code to organize and automatically count values in certain columns. The code should be designed to recognize and count based on column values. Unfortunately, I'm uncertain about which specific columns should be counted; clarification will be needed later. Key skills would be proficiency in Excel, programming, and an eye for design. Experience in data organization and tracking is a must.

Looking for an expert in Excel VBA and Macros to automate various processes in my work-flow. Here's the brief rundown of the task involves: - Automated data analysis which includes summarizing data, filtering, Slicers, automatic calculation, and the visualization of data. - Creation of a Custom excel automatic dashboard for real-time reporting and data visualization. Ideal Skill-Set: You should be knowledgeable and experienced in the use of Excel VBA and Macros for automation. Prior experience in VBA, Macros, data analysis and report generation would be a major advantage. Familiarity with automated summary, filtering, Slicer and calculation methods is essential; knowledge of using Macros to create dashboards for real-time reporting is key....

I'm looking for a skilled photo editor to help me add designed "save the date" texts to some of my photos. The text style I'm looking for is an elegant one and I have no specific color preference for the text and design elements. The final output should be visually appealing, professional and in line with the elegant text style I'm looking for. Ideal skills and experience for this job: - Proficiency in photo editing software - Experience in text design, particularly elegant styles - Creative flair for creating visually appealing designs - Strong attention to detail to ensure a professional-looking final output

I'm looking for an experienced VBA programmer to extend and modify the existing 'getpdf' project. The key focus is on integrating it with Microsoft Excel. Key Responsibilites: - Integration with Microsoft Excel: This involves extracting data from Excel files and downloading data from VBA which is PDF-based data, renaming it, and using Selenium. Ideal Skills: - Strong VBA programming skills. - Proficiency in integrating VBA with Microsoft Excel. - Experience with Selenium for web data extraction. - Prior work with GETPDF data extraction preferable.

We required to develop some requirements to be done on Excel macro using office 365.

I'm looking to build...in one place for purchase, providing a smooth user experience. - Product Reviews: Customers should be able to post reviews on each product. This will not only offer insights about the customer satisfaction levels but also boost the credibility of my products. - User Account Registration: I also want to integrate a user account system. This will make it easier for customers to track their orders, save their favourite items, and expedite their future checkouts. The ideal freelancer for this project is one with strong experience in e-commerce website design and development, preferably a familiarity with Asian-style aesthetics. They should have a proven track record of integrating a shopping cart system, product review feature, and user account registration ...

As the project owner, I am looking for a talented individual who can handle two crucial tasks in Excel: 1. Adding advanced functionality with IF, VLOOKUP, and INDEX MATCH formulas. 2. Implementing conditional formatting. To be successful in this project, you should have: • Proficiency in Excel's advanced functions and calculations • Experience with customizing Excel using conditional formatting • Attention to detail and the ability to execute tasks accurately. Your primary task will be to help me improve Excel's current functionality by implementing the advanced functions mentioned and customizing my Excel using conditional formatting. Your deep understanding of Excel will be crucial to successfully carrying out these tasks...

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfac...

...the site (tariff payment and number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist regist...

Looking for a savvy surveyor who can get to the crux of the ready mix concrete market in Varanasi, India immediately. I need an in-depth study on: - Current market size & its growth trends - Rival firms & their market share Key requirements include: - Compile a detailed report, covering your analysis & proposing actionable strategies. - Provide raw data in Excel or CSV format in addition to the report. Prior experience in market surveying and a knowledge of the construction industry are big pluses. Your ability to work fast while maintaining accuracy is paramount. Let's revolutionize the Varanasi concrete market, one data point at a time!

I need help with simple copying and pasting tasks from online directories. The data needs to be organized by category. The primary task includes: - Copying data from various online directories - Pasting the data into an Excel/CSV file - Organizing the data by categories Ideal skills: - Excellent attention to detail - Proficiency in data entry and Excel/CSV - Understanding of data categorization The task is straightforward and doesn't require any complex skills. I am looking for someone who can deliver accurate results in a timely fashion.

...file (output from the Google Vision API) as input and generate video segments whenever the subtitles change. Responsibilities: Develop a Python script that reads a video file and a JSON file (Google Vision API output) as input. Parse the JSON file to extract subtitle information and their corresponding timestamps. Use the subtitle timestamps to segment the video whenever the subtitles change. Save the segmented video clips with a naming convention: segment_[index]_[text].mp4, where [index] is a sequential number and [text] is the corresponding subtitle text. Ensure the script is well-documented, efficient, and handles potential errors gracefully. Provide clear instructions on how to run the script and any dependencies required. Requirements: Strong proficiency in Python progr...

Preciso transportar dados de uma pesquisa do google formulário para gráficos gerados em Excel, para serem adicionados em trabalho acadêmico.

I have excel table with project tasks by dates start and end and duration. I want to change it to project table. Preferred microsoft format.

We are looking for a developer to help us develop an add-in for outlook that works for outlook on windows desktop app and web app. The add-on will be able to: - Read and analyze every email and send the files to our servers - Receive inputs from our server and suggest actions (save files to specific locations, proposed responses etc)

I urgently need a professional who can input textual data onto an Excel sheet in a visually appealing and easy-to-understand way. Key Responsibilities: - Representing textual data in a clean and organized manner within an Excel sheet. Ideal Candidates Should Have: - Proficiency in Excel, particularly in handling and presenting textual data. - Strong attention to detail, ensuring that all data is correctly input. - Ability to work quickly and efficiently, as the project has a tight deadline. If you have experience with data representation and can work fast, please apply.

I'm seeking an expert in Excel who can help me with three key areas. Tasks include: - Data entry: I have an Excel spreadsheet with around 100-1000 rows and columns that require data input. - Data analysis: Extracting meaningful insights and patterns from the data provided. - Spreadsheet formatting: Ensuring the data is presented in a clear, professional manner which is easy to interpret. Specific functions and formulas required include: - Basic operations like Sum, Average, and Count. - Conditional formatting, to highlight key data points. - Pivot Tables, to present the data in a clear and organized manner. The ideal candidate should have a strong track record in data handling, analysis, and visualization using Excel. Great attention to detail and the abil...

...Luckily, this one fell into my honeypot. ## How to check? You can check if your computer is compromised by seeing if your computer's hostname appears in any of the attached screenshots. **Note: Though the attack is ongoing since ~2 weeks, server contained files of last week** ## If you're one of the 86+ victims on the list: You likely ran the game using "npm start," which downloads attacker payloads and runs them on your computer while you are inspecting the program/game. The attacker then initiates FTP connections to steal your files. They're specifically targeting cryptocurrency wallets, passwords, server passwords, and solidity contracts, although they try to download pretty wide range of file extensions (ie.: PDF / DOC / XLSX / .ENV / TS / ...

Static billboard design Image needs to be to the left (try both images to see which works) Text Danny Bond Never Leave Out Now Spotify Logo Apple Music Logo Amazon Music Logo Try and match the font to the font used in the blue poster attachement Dimensions: 500px x 1000px File type: JPEG DPI: 72 DPI Motion content: Static only Colour: RGB (CMYK will not di...to be to the left (try both images to see which works) Text Danny Bond Never Leave Out Now Spotify Logo Apple Music Logo Amazon Music Logo Try and match the font to the font used in the blue poster attachement Dimensions: 500px x 1000px File type: JPEG DPI: 72 DPI Motion content: Static only Colour: RGB (CMYK will not display correctly) Bleed: Not required Quality: High/Maximum Scale: Save at 100% (1000p...

Development and Enhancement of Excel VBA Project Tracker.

I require the expertise of a skilled data scraper who can quickly retrieve text data from a specified website. The site in question is I need the following specific information delivered in Microsoft Excel Format: - Country Name - Grand Lodge Name - Website address - Email address - Phone - Address - Grand Master name (if available) The ideal freelancer for this project would have significant experience in data scraping, particularly text data, and an understanding of the website's structure to retrieve the desired information effectively. Speed and efficiency are of the essence. Your ability to deliver this project promptly without compromising accuracy will win you this bid.

To give you a brief idea the da...seeking a Python expert who can give me 100% accurate "mapped" data without duplicates or missing information. YOU WILL BE REQUIRED TO WRITE/SEARCH NEW script to modify my data in Excel sheets - I have 3 Excel files having a total of 50000 rows, These are ingredients from recipes, I need you to do the following tasks - (A) - Assign a new ingredient ID number to all non-duplicate Ingredients. (B) - Replace "Name of ingredients" with the newly assigned number in the whole file (C) - For all ingredients - search, get the FDC ID from USDA Food Central and save this info in a separate file. Outcomes - 1. My Excel files - with names replaced with ID (non-duplicate) 2. 1 New file ie. the list of AL...

I'm looking for a skilled React developer to enhance an existing application that allows users to draw rectangles on PDF files. Responsibilities: - Implement the ability to resize rectangles using a slider. This will enhance the current user experience and make the application more intuitive. - Add functionality to select multiple rectangles and delete them at once. This feature will improve efficiency and save users time. Ideal skills and experience: - Proficiency in React: as the modifications are to be made in a React application, a strong understanding of React is essential. - Experience with PDF manipulation in React: to ensure the correct implementation and smooth functioning of the new features. - UI/UX design: to ensure the new functionality is integrated seaml...

I'm intending to create an Excel roster to effectively manage the allocation of shifts, roles and skills within my organization. Key details I aim to competently track include: Example-if i select a product we are making that day it automatically populates how many people required for that product and when box is clicked it shows the names of people available that day. The names we can enter and remove has needed if employees leave or new employees arrive. - Employee Names: I want to record the names of each staff member in my organization. - Shift Management: I want to assure every shift for specific products has appropriate manning. Ideal Candidate: A freelancer who has experience with HR data management and Excel roster creation would be ideal for this task. They...

...focused on identifying Effluent Treatment Plant (ETP) and Sewerage Treatment Plant (STP) manufacturers, as well as wastewater treatment plant suppliers in Maharashtra. As a freelancer, your task would involve comprehensive research to compile a database of relevant companies operating in the field of wastewater treatment across Maharashtra state. The information gathered will be organized into an Excel sheet, including but not limited to: Company Name Email Address Website Address Location and Address Contact Number The scope of the research will cover suppliers located in major industrial estates and towns across Maharashtra. This includes but is not limited to areas such as Mumbai, Pune, Nashik, Aurangabad, Nagpur, and others with significant industrial presence. Your role ...

...consultant who helps people save on telecom and gas/electricity. I compare all invoices and often offer a cheaper rate. Customers save an average of 50% through me, which amounts to an average of 800 euros per year. Through me, customers receive exceptional discounts that they cannot get anywhere from providers. The intention is that people fill out a request form on the advertisement so that I can contact them later. People who live in Flanders can register via the following link and I will prepare a no-obligation quote for them. I now want to create 2 different advertisements for social media. My intention is for people to be interested and respond to it. I am looking for someone who can make a design that fits my concept. In attachment there are several examples on ...

...an experienced freelancer who can effectively perform data entry tasks involving financial data. While the specific type of data has not been specified -- it could range from invoices and expense reports to bank statements -- the chosen professional should exhibit versatility and aptitude in working with various forms of financial data. Key Requirements: - Proficiency in Excel: You'll need to be well-versed in using Excel for data entry tasks. - Background in Finance Data Entry: Experience or relevant knowledge in finance data entry is crucial. This ensures you can deliver accurate results. To apply, offer a detailed approach on how you would tackle this project. Also, provide evidence of your past work as well as your experience in the field. This will assure me of...

Advance Excel work to be done urgently.

...highly skilled Excel VBA developers who can enhance my workbook's functionality and deliver efficient solutions. The scope of this project includes: - Automating data entry procedures to increase efficiency, reduce errors, and ensure accuracy - Designing custom Excel functions for a more streamlined experience - Producing comprehensive reports as per need Key Skills and Experience: - Proficiency in Excel 2013 and Excel 2016 is a must. - Strong knowledge of Excel VBA development - Prior experience with data automation and custom function creation - Expertise in generating powerful reports in Excel I am focused on seeing quantifiable improvements in efficiency and data accuracy through your work. If you have the required ski...

Create a form in Excel following the pre-determined options. The results of the answers must be recorded in a second tab

updated excel file let discuss more in chat

I intend to streamline the process of document submission and verification in relation to EDPMS entry and BRC, with a focus on customs or trade-related documents. The ideal candidate will ensure proper documentation is submitted and will run stringent checks for validati...trade-related documents. The ideal candidate will ensure proper documentation is submitted and will run stringent checks for validation purpose. Key Responsibilities: - Submission and verification of customs or trade-related documents - Verification and correction of any errors found in the documents Experience & Skills: - Experience in the customs or trade sector is essential - Proficient in Excel/CSV - Strong attention to detail and high accuracy in document handling - Previous exposure to EDPMS and BRC is...

I've already done most ...the key piece of work. - Comprehensive Review: It's important that you review my analysis comprehensively and suggest corrections or improvements where necessary. - Final Financial Year Analysis: The analysis should cover multiple financial years, ensuring a comprehensive assessment of my trading performance. Ideal Skills and Experience: - Proficiency in Excel: The data prepared to do is in an Excel spreadsheet format, so advanced Excel skills are essential. However I also have a full list of my trades that is only in pdf. - Financial Analysis: A solid background in financial analysis and portfolio management is necessary for this project. The ideal candidate will have a keen eye for detail and the ability to provide reliable, acc...

As your assistant for this project, my job will be to type data into an Excel spreadsheet. However, I currently don't have specific information on what type of data (text, numbers, dates) you require. Additionally, I need clarification on whether you have any specific formatting needs for the data and if any calculations or formulas will need to be applied. Ideal Skills: - Proficient in Microsoft Excel - Precise and quick typing ability - Understanding of Excel formulas (just in case) Your prompt response to these questions will help ensure successful completion of your project. Looking forward to working with you!

I'm intending to create an Excel roster to effectively manage the allocation of shifts, roles and skills within my organization. Key details I aim to competently track include: Example-if i select a product we are making that day it automatically populates how many people required for that product and when box is clicked it shows the names of people available that day. The names we can enter and remove has needed if employees leave or new employees arrive. - Employee Names: I want to record the names of each staff member in my organization. - Shift Management: I want to assure every shift for specific products has appropriate manning. Ideal Candidate: A freelancer who has experience with HR data management and Excel roster creation would be ideal for this task. They...

• Automate the collation of data from two sheets, "Data" and "Report," into one Excel workbook. • Transfer data from specified columns in the "Data" sheet to new columns in the "Report" sheet. • Implement exception handling to address missing values during the data transfer process. • Develop an email notification feature to inform managers about the completion of the collation process. • Add "Data" suffix to transferred column names in the "Report" sheet for differentiation. • Provide a solution to automate the process without manual copying and pasting of VBA code. • Name the final file as "Book of Transfer_[Date of extraction from the portal]". • Automate the proce...

...Features: - Property Search: Users should be able to search for properties in my database - Property Details: Users should be able to view detailed information about the properties - Favorites List: Users should be able to save properties to a favorites list User Authentication: - The app should allow users to sign in using their Email and Password. Property Search: - The property search feature should integrate a map view for a better user experience. Users should be able to visualize the location of the properties they are interested in. - It should also include the option to save searches, which will be a convenient feature for users who are actively looking for properties. Ideal Skills: - Proficiency in Xamarin development - Experience with SQL Server databases - Pr...

For my expanding fashion business, I'm on the hunt for inspired and skilled fashion designers -- those who excel in creating both underwear, swimwear, and sleepwear for Womens. But, the real cherry on top would be a knack for lingrie designs. Key Requirements: - Ability to create unique, innovative designs that target different audiences - Proficiency in both trendy and classic styles. We value versatility! - Expertise in working within a monochrome and neutral color scheme Desired Skills: - Expert knowledge of fashion trends in underwear, swimwear and sleepwear - Exceptional creativity and innovation - Strong sketching skills with attention to detail With your help, we can revolutionize the market by producing designs that encapsulate both the traditional classics and...

I'm seeking a meticulous data entry operator capable of transferring data from digital documents to an Excel sheet. This task involves: - Taking solely textual data from digital documents. - Conducting minor internet research and using ChatGPT when necessary to fully understand the instructions. - Accurately entering the required information on the provided Excel sheet. The ideal candidate for this job is one who is proficient in the use of Excel spreadsheets and has excellent attention to detail. Previous work experience in a similar data entry role is advantageous. This work is specifically in the context of creating content for product listings in e-commerce sites. So if you have specific experience in this area, that would be an additional bonus.

Hi, I need to link various data between sections in my current Perfex CRM installation. I'll provide you a staging version of the CRM where you can try the customization and then replicate it into the main version. I've attached an explanatory excel where you can see what data is to be shown in other sections of the CRM. (CRM ) Below you can see what data need to be sync in the Perfex CRM. 1. When creating a Lead-related Task, copy the data [Address] [City] [Description] 2. When creating a Proposal related to the Lead, copy the data [Network] In CRM I created a custom Network field (multiselect) for Leads and Customers and the same field within Proposals as well. When creating a proposal associated with a lead or customer the Network data should appear automatically ...

I require a freelancer proficient in excel to assist with data cleaning and sorting tasks for a range of diverse digital files. Your expertise in managing and optimising Excel spreadsheets will be invaluable and greatly appreciated. Key tasks will include: - Using Excel functions to clean datasets, removing discrepancies and inaccuracies - Sorting data into relevant fields and categories for easier access and analysis The optimal freelancer will have: - A meticulous eye for detail to ensure data accuracy - An understanding of Excel formulae and functions - Proven data cleaning and sorting experience - The ability to meet tight deadlines without compromising quality. Your primary role will be to untangle and streamline my Excel spreadsheets, m...

I'm in need of a VBA or VSTO developer who can assist with data validation tasks in Excel. You would be responsible for: - Validating numerical and textual data - Organizing validated data in a separate sheet Ideally, you should have experience in working with data validation, especially in Excel. You should also be knowledgeable about building or modifying VBA / VSTO for data validation. Specific criteria for data validation are available and will be provided. Your skills in understanding validation requirements will be instrumental. Familiarity with Excel functions and features is necessary, and proficiency in handling both numerical and text-based data will be of importance. Strong attention to detail will be crucial for successful output.

I need a freelancer well-experienced in VBA to automate the generation of reports for my business, specifically in Gmail. It's critical for this project to be completed as soon as possible, and here are the specific needs: - Develop VBA scripts that will automatically generate and send specified reports. - Must have a deep understanding of Gmail infrastructure in order to correctly implement the automation process. - Must demonstrate a proven track record in completing similar automation tasks. Your expertise in ensuring efficiency and accuracy is important. If you believe you're the perfect candidate and can deliver this project promptly, please reach out.

Here are the job instructions for the images: Please cut out all the images using the pen tool and save the path. Do this by drawing around the image, so this may take a little longer and remove the background leaving it white. Please leave a small clear border at the edge, say 10% of the image size, Save the original image as a max quality jpg file RGB Re size the image to 1500 pixels across at 300DPI and save as a TIF file CMYK Re size the image again to 700 pixels across at 72 DPI and save as a JPG file RGB The file name can be the same for all of these and pleas put them in different folders

As discussed I have completed the template for Home Team Workbook.

Descripción del Proyecto: Registro de Envíos: Seguimiento detallado de cada paquete, incluyendo número de seguimiento, descripción, fecha de recepción en Miami y estado actual. Dashboard de Control: Visualización clara y precisa de la cantidad de paquetes en bodega de Miami, en tránsito y en bodega/aduana. Base de Datos de Clientes: Gestión de información de clientes, incluyendo nombre, número de teléfono, dirección y saldo recargado de tarifas premium. Análisis de Rentabilidad: Generación de costos previstos para cada embarque, incluyendo costos de transporte, tarifas de aduana, impuestos, entre otros. Cálculo de la rentabilidad de cada embarque y visualización comp...

I'm seeking a home-based freelancer proficient in Microsoft Word, Excel, PowerPoint, Outlook, and Tally ERP 9 for a variety of tasks. Key Responsibilities: - Data Entry: Accurate, timely, and efficient data entry support is a core requirement. - Document Formatting: Assistance with formatting a range of documents, ensuring a professional and consistent appearance. Ideal Skills & Experience: - Proficiency in Microsoft Office Suite: You should have a strong command of Word, Excel, PowerPoint, and Outlook. - Data Entry: A proven track record in data entry, with a focus on maintaining a high level of accuracy and meeting deadlines. - Tally ERP 9: Experience in using Tally ERP 9 is preferred, but training can also be provided. - Organizational Skills: Ability to manag...

...seeking a skilled professional to create a web application which automates the extraction of simple tables from word documents and the transfer of this data into a macro-enabled Excel sheet. Key Requirements: - Extraction of simple tables from Word documents - Transferring the extracted table data directly to a macro-enabled Excel sheet - Ensuring the data transfer is accurate and error-free Ideal Skills & Experience: - Proficiency in Web App Development - Strong experience in data extraction and manipulation - Proficiency in working with Word and Excel documents - Familiarity with macro-enabled Excel sheets - Attention to detail to ensure data accuracy and error-free transfer The final product should be a user-friendly, efficient, and r...

I require a coder proficient in Ctrader Indicator development to execute my vision. I need an indicator that identifies trend reversals, highlights overbought and oversold conditions and generates buy and sell signals. Specific calculations must include: I would like an indicator for Ctrader which calculates and displays the s...vision. I need an indicator that identifies trend reversals, highlights overbought and oversold conditions and generates buy and sell signals. Specific calculations must include: I would like an indicator for Ctrader which calculates and displays the size of a body and total size of the CURRENT candle in the current time frame. It should also display the following on a new line according to this Excel formula: =IF(BODY<=(CANDLE/2);"LLX";"...

...analysis and solution design with complete documentation. We wish to study and analyze the API of in order to create a new web application that will make use of it, so that a teacher can create educational activities for his students. We want to design a page that gives various options and various settings, which make API calls to teachablemachine.withgoogle.com. These settings can depend on the options the user has to design objects/activities within the teachablemachine. Simply the creations will be done with API Calls from an external application. After selecting the settings, we want, by pressing save, to see on a separate screen the result of these calls according to the choices made by the teacher. When the settings are changed, the student will see the