Excel vba list web files työt
FIN... Excel-tiedosto sisältää satoja rivejä eri tuotteita, joista on esimerkiksi seuraavat tuotetiedot: positio, tuotepyyntö, tuotevaatimus, tuotenimi, tuotenumero, tuotekuvaus, hinta ja kuvakuvalinkki. Näistä tiedoista pitäisi saada atomatisoitua tuotekortteja. Tuotekortti on käytännössä A4-kokoinen PDF-dokumentti, jonka yksi sivu on yhden tuotteen tuotekortti. Mainitsen tässä InDesignin, koska sitä osaan käyttää ja ajattelin, että jos voin määrittää InDesigniin kenttien paikat, niin olisiko mahdollista, että Excel-tiedot tippuisivat jonkin scriptin avulla näihin kenttiin ja ikään kuin visuaalinen ulkoasu pysyisi koko ajan omissa hyppysiss&a...
Hei, Olen tuore asfalttialan yrittäjä (yrityksessä neljä henkilöä) ja tarvitsen seuraavia palveluita: myyntilaskujen luominen työkirjanpidosta (kilometrien laskeminen, eri työkohteiden erittely ja eri työtyyppien erittely). Osaat käyttää sujuvasti exceliä ja muita perustoimisto-ohjelmistoja. Laskut kootaan viikon loppupuolella, kun viikon työt on tehty. Mahdollisesti muuta toimistotyötä tarjolla myöhemmin, jos osaava henkilö löytyy.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.
Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.
Toimitamme tuotetietokannat excel-tiedostoina, tuotteiden valokuvat ja tuotteiden avainsanat yms. ja ne syötetään csv-tiedoston avulla hakukoneystävällisesti (esim. Woothemes Product CSV Import Suite + Yoast Woocommerce) wordpress-sivustolle, jolle on jo asennettu woocommerce ja jossa on jo tuotteita. Tuotteita tulisi lisää noin 200-400. Woocommercea käytetään Catalogue-modessa, eli sivusto ei ole varsinaisesti automatisoitu verkkokauppa.
2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.
2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.
I'm looking for a professional to apply on my behalf to various job platforms like Indeed, LinkedIn and Glassdoor. Apply For The following 1. software developer 2. desktop support analyst 3. programmer analyst Ideal skills for the job:...Indeed, LinkedIn and Glassdoor. Apply For The following 1. software developer 2. desktop support analyst 3. programmer analyst Ideal skills for the job: - The roles should be mid level or senior-level with a salary of 70K or more - I'm only interested in jobs located in Orange County or LA County in California. - You will need to send my resume to each application. - I expect a comprehensive excel list of all applications made. Please note that the applications should be tailored to each platform and role, showcasing my relev...
I'm in need of a detail-oriented support secretary to assist with my weekly Excel report for our various mining exploration projects. The tasks involve basic data analysis and project management. Key Responsibilities: - Data Entry: Accurately inputting project data into the report. - Financial Tracking: Keeping tabs on project budgets and expenditures. - Performance Metrics: Monitoring and recording project performance indicators. Ideal Candidate: - Proficient in Excel with experience in data analysis and project management. - Some familiarity with mining industry terminology. - Excellent attention to detail and good with numbers. Bonus: - Previous experience in mining projects. The task should take around 3-4 hours each week, with the report needing to be complete...
I'm looking for a skilled frontend developer with expertise in Microsoft Excel. The primary task will involve creating a frontend that interacts with Excel for report generation. Ideal Skills: - Proficient in frontend development - Extensive experience with Microsoft Excel - Strong understanding of report generation processes in Excel Please note, the specific data types for the reports and the frontend framework have not been predetermined, so flexibility and adaptability are key. I look forward to your bids.
I'm seeking assistance with data entry from paper documents into an Excel spreadsheet. The documents contain mainly text, with some handwritten content that is mostly legible. Ideal skills for this job include: - Proficient in Excel - Excellent attention to detail - Able to decipher and accurately transcribe handwritten text - Experience with data entry from paper documents - Good understanding of text-based data
I'm looking for a skilled frontend developer with expertise in Microsoft Excel. The primary task will involve creating a frontend that interacts with Excel for report generation. Ideal Skills: - Proficient in frontend development - Extensive experience with Microsoft Excel - Strong understanding of report generation processes in Excel Please note, the specific data types for the reports and the frontend framework have not been predetermined, so flexibility and adaptability are key. I look forward to your bids.
I'm looking for a talented developer to create a custom Windows program that can correct postal codes for a ...capabilities. Key Requirements: - The program should access addresses and postal codes for all countries. - It should be able to find and replace incorrect or misspelled postal codes based on provided addresses. - The input will be an Excel file containing customer data, including name, address, postal code, phone number, and email. - The program should output a corrected version of the input file. Ideal Skills: - Proficient in Windows program development. - Experienced in creating GUI and CLI. - Familiar with API integration. - Knowledgeable in handling Excel files in programming. Please note, I'm open to proposals for implementing this via a b...
...programs: I have become proficient in using programs such as Microsoft Word to formulate documents, Excel to innovate data and accounts, and Outlook to innovate email and appointments. - Accuracy and speed: The ability to transfer information with high accuracy and amazing speed, including the number and reason. - Dealing with data: I learned how to analyze data in ways that make it easier for users to access basic information. - Effective communication: Designing work environments that require effective communication with different departments and teams, which leads to improving my management and coordination skills. As a result, I believe that my experience in information sources enables me to excel in the field, and I am always improving skills and learning new tech...
We are seeking someone to develop an AI-driven ...user and performance feedback. 7. Compliance and Ethical Considerations: - Ensure adherence to all relevant investment regulations and compliance requirements. - Implement mechanisms to minimize biases in decision-making. Technical Requirements - Utilization of natural language processing (NLP) for understanding and generating human-like text. - Integration with financial data uploaded in excel - Scalability to accommodate additional features or a growing dataset. - Please provide an estimated timeline for project completion, including key milestones. - Include budget for the project, breaking down costs related to development, testing, and any additional resources. - Recommendations for development methodologies and tools t...
I'm looking for a meticulous data entry professional to assist in creating a new database. The project will involve: - Entering mixed data (both text and numerical) from various digital files, such as PDFs and Word documents, into Excel - Ensuring accuracy and consistency to build a reliable database Ideal candidates should be proficient in Excel, familiar with data entry best practices, and able to handle mixed data types with ease and precision. Experience working with digital files and creating databases is a plus. Your attention to detail will be crucial in making this project a success.
Hello! I came across your request for an Excel expert skilled in dashboard creation and automation, and I’d love to assist you. With extensive experience in Excel, I specialize in creating professional dashboards, streamlining data processes, and implementing automation to make workflows efficient. I thrive on problem-solving and can handle tasks from scratch to ensure the final output meets your exact needs. Let me know how I can contribute to your project and discuss any specific requirements you have. Looking forward to collaborating with you. Best regards, Nilesh Diwane
I need assistance with a data entry project involving mixed data types. The data is currently stored in online databases and needs to be accurately entered into an Excel spreadsheet. Ideal Skills: - Proficient in data entry - Experience with Excel - Attention to detail to ensure data accuracy Please note that the data types are mixed, so you should be comfortable handling both text and numerical data. Approximately 10,000 entries will need to be done at the earliest from individual 10,000 individual PDF files.
I'm looking for a freelancer to assist with data entry into a spreadsheet. The data is primarily numerical and will be sourced from scanned documents. Ideal skills and experience include: - Proficiency in Excel and other spreadsheet software - Keen attention to detail to ensure accurate data entry - Experience working with numerical data - Ability to handle and process scanned documents - Good time management skills to meet project deadlines.
...This project extends beyond basic property/tenant management, incorporating advanced financial accounting, invoicing, document management, automated notifications, staff/vendor management, analytics, data import/export, and robust security measures. Initially, we’ll focus on a web-based solution using React (front-end) and Node.js + PostgreSQL (back-end). We also plan to future-proof the system for possible expansions to desktop and mobile platforms. If you have experience building complex, secure, and scalable SaaS/web apps, we’d love to see your proposal! Key Features & Modules 1. Property & Unit Management • Track properties, define units (rent amount, occupancy status). • Link units to tenants, show vacancy vs. occupied, manage lease ...
I need a UAT tracker created in Microsoft Excel based on provided user test scripts. The tracker should include a Summary Dashboard and categorize test scripts by module. Key Requirements: - Create a UAT tracker and Reporting Tool in Microsoft Excel. - Include a Summary Dashboard. - Categorize test scripts by module. Ideal Skills: - Proficient in Microsoft Excel. - Experience with User Acceptance Testing (UAT). - Ability to create comprehensive dashboards.
...perform **web scraping** for a specific project. Here are the details: 1. Scrape data from [website name: stats perform/URL: ]. 2. Extract the following information: - [Specify the data fields you need, e.g., Seasons, Matchday, Results, Match Summary, Opta Points, Match Details, Venue, Attendance, Referee, date, Goal Assist, Cards, Cross ,Foul won, Foul conceded, Goal/Own Goal, Interception ,Offside, Pass, Penalty (Won, Conceded and Taken), Shot, Shot on target, Shot off target, Tackle, Save, Penalty Save] 3. The data should be delivered in [desired format, Excel, CSV]. 4. Ensure the script is reusable for future updates and scraping. 5. Follow best practices for web scraping
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
I need assistance updating 10 to 50 Word documents based on information from an Excel sheet. Ideal skills and experience for the job includes: - Proficient in Microsoft Word - Good attention to detail - Ability to understand and follow instructions from an Excel sheet. Please note that the specific updates required are currently unspecified.
...all inter-account transfers are accounted for without duplication. Provide a detailed ledger of categorized transactions for easy reference. Output Requirements: An Excel file with clearly labeled sheets for raw data, matched transfers, unmatched transactions, and categorized summaries. A summary report highlighting key insights and any discrepancies. Skills Required: Advanced proficiency in Excel (including formulas, pivot tables, and lookups). Experience in financial data analysis and reconciliation. Strong attention to detail and ability to work with confidential information. Deliverables: A consolidated and reconciled Excel workbook. A summary report with key findings and recommendations. Additional Information: I will provide the raw transaction data from al...
I'm in need of an Excel expert to assist with various financial tasks. This includes: - Creating budget spreadsheets - Analyzing staffing costs - Generating financial reports I will also require some custom Excel formulas to be created. The level of automation needed is basic, primarily using standard formulas. Ideal candidates for this project should have: - Extensive experience with Excel - Proficiency in creating budget spreadsheets and analyzing financial data - Ability to create custom Excel formulas - Basic understanding of automation using Excel formulas
I have a 30-page document containing text and numbers that needs to be converted into a basic Excel table. The table should be structured with rows and columns, following predefined headers from the document itself. Ideal Skills: - Proficient in Excel - Experienced in OCR technology - Attention to detail - Ability to follow specific instructions Please note, the document will likely present some challenges for OCR due to its complexity. Therefore, a freelancer with strong problem-solving skills and patience will be highly valued.
Description: I am looking for an experienced web scraper to extract product reviews and general product data for Alpine Baby Muffy and Kids Muffy hearing protection earmuffs. Project Requirements: 1. Data Extraction: Target Websites: E-commerce platforms (Amazon, eBay, Walmart, official retailers, review sites, etc.) Primary Focus: Extracting and categorizing customer reviews into: Positive remarks (what customers like) Negative remarks (what customers dislike) Additional Data Points: Product name Price Availability (in stock/out of stock) Retailer name & website URL Product specifications Customer ratings (e.g., average rating, number of reviews) 2. Data Processing & Output: Output the review remarks in a structured format (CSV, Excel, or JSON) Categorize review f...
...into an Excel spreadsheet. You'll be dealing with: - Data Fields: Name, Address, Email Your tasks will include: - Data Entry: Inputting the specified data fields into Microsoft Excel - Data Cleaning: Ensuring the data is accurate and free from errors - Data Validation: Adhering to unique data validation rules as instructed Ideal skills and experience for the job: - Proficiency in Microsoft Excel - Experience in data entry and data cleaning - Attention to detail for data accuracy - Ability to meet deadlines - Familiarity with data validation rules Please be prepared to adhere to: - Expected Format: Data must be entered in Excel - Accuracy Standards: High level of accuracy is required - Deadlines: Timely completion of the project - Specific Software: ...
Please show ...create a dashboard for visualizing user analytics in a comprehensive and engaging way. Key Requirements: - Use of React framework to build a responsive and interactive dashboard, Visualization of data through charts and graphs. - Select, upload excel in UI and work all Excel Formulas like Lookups, Aggregates, Database Tables, to display tabular and tiles, widgets - Integration of user demographic and usage pattern data into the dashboard. Requirement is in Two pages, I will share with those you have already worked on the React Dashboards with Excel Integrations. Ideal Skills: - Proven experience in React development, preferably with dashboard creation. - Strong understanding of user analytics and data visualization techniques. - Ability to design in...
...*************************************** Project description : This is an intensive, manual work project that will take at least 4 hours of dedicated Excel skills Please proceed with reading further, only if you are willing to work hard and devote time to complete the task correctly. It CANNOT be automated or run via a script. It CANNOT be outsourced via code. It cannot be "done using AI" . Please do not waste your valuable time trying to do either. The task: There are Some handwritten notes with approximately 1000 records. These are student data for a school in India. Your task is to neatly organise and write the data into an Excel worksheet. You will create 1 separate worksheet for each class, e.g., : 1. Nursery Section A 2. Nursery Section B 3. Clas...
I'm looking for a freelancer who can help me scrape text content from a specific website and deliver it in an Excel spreadsheet. Ideal Skills and Experience: - Proficiency in web scraping tools and techniques - Experience with data organization in Excel - Attention to detail to ensure all relevant text content is captured Please note, the specific sections of the website to be scraped have not yet been determined, so flexibility and adaptability will be key.
I am a data analyst in need of assistance with creating a sales report in MS Excel. Ideal skills for this project: - Expertise in MS Excel - Strong data analysis skills - Experience in sales report creation Looking forward to your bids.
I'm in need of assistance with document creation and editing in Microsoft Word, specifically for creating and editing reports. The ideal candidate should have a strong proficiency in Microsoft Office applications, particularly Word, Excel, and PowerPoint. Key Responsibilities: - Assist in the creation and editing of reports - Incorporate images and tables into the reports Ideal Skills: - Proficiency in Microsoft Word for document creation and editing - Experience in creating and editing reports - Ability to incorporate images and tables into documents - Strong attention to detail - Excellent communication skills
I'm looking for a web-based system that detects sports betting arbitrage and positive EV opportunities (both pre-match and live) across all sports and every betting market, on the betting sites I am attaching in an Excel sheet. The layout should be similar to that of , see picture attached. I have 647€ in my freelancer account, that is my maximum budget for this project. I have a Linux VPS server subscription, the system should run on that server. Key Features: - Web-based platform: The system should be accessible and fully functional on the web. - Comprehensive sports coverage: The system must cover every sport, not just football, basketball, and tennis. - All betting markets: The system should be able to identify opportunities in every betting mark...
Extraer la información de archivo pdf y pasar la información a excel
...Develop and deliver comprehensive reports and interactive dashboards. Data Sources: The dashboard will need to pull data from a variety of sources, including: - Excel files - Tenica - HubSpot - BCI - PDF - CRM Database - Workflow - POAP/Project on a page/XL Integration Requirements: The following data sources need to be integrated into the Power BI dashboard: - Excel files - HubSpot - CRM Database Skills and Experience: - Proven experience with Power BI is a must. - Data visualization and analysis skills are crucial. - Prior experience integrating various data sources into Power BI is highly preferred. - Proficiency in handling Excel files, HubSpot, and CRM databases. - Strong understanding of finance and sales data will be an added advantage...
I need a 600-page pdf written in Microsoft Excel for record-keeping, specifically for inventory data. The document must include: - Item names and quantities No formulas or complex Excel functions are required. This project is ideal for freelancers with excellent attention to detail and experience in data entry and inventory management.
I'm in need of a reliable and efficient data scraper who can pull order details from my Aliexpress account into an Excel file. The scraper should allow me to manually set a date range for the data I want to extract. -Data Requirements: I will provide a template for the data. - Frequency of Task: I would like the scraper to be user-friendly enough so that I can set a start and end date for future data scraping tasks each time I run the scrapper. Ideal skills for this project include experience with web scraping, familiarity with Aliexpress, and proficiency in Excel. A good understanding of data handling and the ability to create a user-friendly interface will be an added advantage. I have attached below a sample of output file
I'm in need of a transferring my logo to a design file along with a corresponding business card. Ideal skills and experience: - Proficient in graphic design software such as Adobe Illustrator or Photoshop - Strong portfolio demonstrating modern and minimalist design - Experience in creating professional business card layouts - Ability to work with a two-tone color scheme - Good understanding of branding and visual identity Business Card Details: - Should include my name, the logo, and my contact information. Please ensure that the logo and business card design are cohesive and reflect a modern, minimalist aesthetic.
I need a VBA script for Microsoft Word that will help me remove highlights from bullets and the space after in bulleted paragraph lists. The script should be manually executable by clicking a button. Ideal skills and experience for the job: - Proficiency in VBA (Visual Basic for Applications) - Strong understanding of Microsoft Word functionality - Prior experience creating Word scripts - Ability to write clear, user-friendly code Please note: The specific version of Microsoft Word this script will be used on has not been determined yet, so the script should be compatible with Microsoft Word 2016, 2019, and 365.
My Excel sheet requires some urgent formatting adjustments to properly calculate and display the gross profit (GP) of items. Key Issues: - Formatting problems predominantly in the cells and tables Necessary Skills: - Advanced Excel expertise - Experience with data validation and conditional formatting - Attention to detail to ensure accurate GP calculations Your role will be to troubleshoot and rectify the formatting issues to ensure the sheet operates correctly and efficiently. Your expertise will allow for the implementation of necessary data validation and conditional formatting to improve the functionality of the sheet.
I need a straightforward travel calculator focused solely on air travel. This tool should be built in Excel and utilize a simple user form with concealed tables that house the necessary data sets. Key Features: - The calculator should handle only air travel. - It should factor in flight distance and also calculate frequent flyer points based on the journey. - The user input form needs to encompass departure and arrival locations, class of service, and booking class. Ideal Skills: - Proficiency in Excel, particularly in creating interactive user forms and concealed data tables. - Understanding of air travel metrics and frequent flyer point systems. - Ability to create a user-friendly, simple yet effective travel calculator.
I'm experiencing issues with my Excel. The Copy/Cut/Paste functions are disabled, and I need someone to troubleshoot and assist me with these functions. Ideal skills for this job would include: - Expert knowledge of Microsoft Excel - Troubleshooting skills - Data entry experience Please help me get my Excel functioning properly again. Thank you!
I'm looking for a freelancer to assist with data entry from spreadsheets into Microsoft Excel. The data is mixed, consisting of both text and numerical values. Ideal Skills and Experience: - Proficient in Microsoft Excel - Attention to detail - Experience with data entry from spreadsheets - Ability to handle mixed types of data (text and numerical)
I have several transactions that need to be compiled into a billing statement. You will receive: - Transaction details in an Excel/CSV format - A template to follow for the billing statement Your task: - Convert the transactions into a Word and PDF billing statement using the provided template - Include all details I provide, such as client details, billing period summary, and payment instructions Ideal skills: - Proficient in Excel - Experienced in Word and PDF document creation - Attention to detail to ensure all supplied information is accurately included