Ating excel 2003 macro 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.
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.
I'm seeking an expert in MS Power Automate, well-versed in implementing unique flows using different AI Chat APIs - particularly Chat GPT API and Cohere AI API. The primary task is to create a power flow capable of running batches of prompts effectively. Key expectations are: - Expertis...implementing unique flows using different AI Chat APIs - particularly Chat GPT API and Cohere AI API. The primary task is to create a power flow capable of running batches of prompts effectively. Key expectations are: - Expertise in MS Power Automate, API integration, and AI-oriented applications. - Background in working with Chat GPT API and Cohere AI API. - Ability to deliver results on a web excel sheet. Please note that an understanding of additional AI Chat APIs is highly valuable fo...
The purpose of this project is to create a detailed, technical drawing using SolidWorks 2022. The emphasis of the project is documentation of plastic parts, both on a macro and micro-level. Key Requirements: - Able to generate technical drawings that include overall dimensions, shapes, specific features, and tolerances of plastic parts. - SolidWorks 2022 ONLY!! - Extensive experience and understanding in documentation of manufacturing processes and components - Expertise in rendering intricate details of plastic parts - Must be able to abide by all requirements for precision-driven, technical documentation - Detailed and clear communication The ideal candidate will have a background in mechanical engineering or a related field, as well as experience in creating detailed, techni...
I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.
We're looking for a competent native English writer or editor to help us improve English language usage in a big batch of Excel-related tutorials. No testing of tutorials has to be done as the technical aspect of the articles is fine but they've been put together by non-native speakers. Starting with revising a trial article (paid).
I have an Excel sheet that requires daily data analysis using statistical methods. Key requirements: - Daily updates: The data in the Excel sheet will need to be analyzed using statistical methods and techniques on a daily basis. - Statistical Analysis: The main focus of the analysis will be on statistical methods. You'll be required to utilize various statistical tools to interpret the data and provide insights.
I have several thousands PDFs that need to be read, interpreted and transcribed into a supplied spreadsheet format. It is important that you: 1) Have an existing team to help with a task that is estimated to take 2 weeks 2) Proficiency in PDF to Excel transcription 3) Ability to complete the task efficiently Applicants based in India only.
I have three separate Excel documents that need to be merged into a single, optimized sheet. In this new file, we should only pull specific data columns including Defect ID, Defect Type, Date Opened, Priority, Description, Reproduction Steps, Actual Result, Date Closed, Assigned To, and Comments. These columns must be combined while maintaining clarity and structure. After this task, a dynamic dashboard that displays the current state of the project is required. This dashboard should offer a variety of visualizations. We are particularly interested in bar charts, pie charts, and line charts to present the data in a clear and digestible manner. Ideal candidates for this project are those with: - In-depth expertise in Excel data management - Experience in creating dynamic das...
I am looking for a detail-oriented professional to assist me in transcribing text data from Word Documents into an Excel sheet in alphabetical order. Specifically, you will be: - Handling text data from Word Documents - Accurately typing this data into an Excel sheet - Organizing this data alphabetically to aid in easy referencing Experience with data entry and a strong grasp of Microsoft Word and Excel is mandatory. I expect high attention to detail to ensure accuracy in data transcription and organization. Please submit your proposals detailing your relevant experience.
Hi Jay - been a long time since we interacted. But I want to let you know that we still use the excel file that you created for us way back in 2017. Its been our main stay. I have another Excel file which requires formula to effect colour change in cells under various conditions. Knowing you, it might be just a 10 or 15minute assignment. Would you be able to help. Thanks. Vish
I am looking for a skillful freelancer who can assist me in converting an Excel spreadsheet into a daily calendar schedule like this: Key Requirements: - You must have a firm understanding of Excel and calendar scheduling. - You must be capable of adjusting the Excel data to fit into a daily calendar layout. All data will be uploaded by an excel spreadsheet or .csv file
...specifically GST and TDS filing for my 11-20 clients. - Responsibilities: - Filing GST returns - Filing TDS returns - Periodic accounting in tally for selected clients - Income tax return filing - Coordinating with clients on monthly basis for the documents The majority of my clients have less than 70 transactions per month and I use tally software, thus a good grasp of tally software and excel is necessary to handle the above tasks. - Skills and Experience: - Gst return filing experience - Proficient in tally software - Experience with handling multiple clients simultaneously - Knowledge of GST and TDS filing systems appeciated. This is an ongoing project and I am looking for a dedicated and reliable partner in this area as this will be an ongoing and lon...
I'm in need of an Excel expert who can help me perform basic arithmetic operations for financial calculations. The purpose of the sheet is to analyze simple financial data, so you should have a good understanding of basic financial concepts. Key requirements: - Perform basic arithmetic operations in Excel for financial data. - Create standard tables and charts to present the analyzed data in a clear and comprehensible manner. The ideal freelancer for this job will: - Have a strong background in Excel, particularly in handling financial data. - Be able to create visual representations of data using standard tables and charts. - Be able to efficiently and accurately perform basic arithmetic operations in Excel.
Join our dynamic team as a Real Estate Agent where communication skills meet unwavering motivation and a drive for success! We're seeking experienced individuals with a knack for leadership, a commitment to ethi...redefine excellence in real estate! - Uploading photos and descriptions of properties - Sorting listings by location and price - Providing regular updates on availability - Scheduling site visits for potential customers - Providing customer support to potential buyers For the lead generation aspect, you'll be targeting first-time home buyers, investors, rental property seekers, and end users. To excel in this role, you should have experience in real estate sales and understanding of different audience segments. Excellent communication skills and a proactive app...
I'm in need of a professional data entry specialist to assist with entering numerical data into an Excel spreadsheet. The aim of this task is to organize the data in a clear, tabular format that can be easily read and interpreted. Skills & Experience: - Proficient in Excel - Strong attention to detail - Experience with numerical data entry The project demands precision in inputting the data, so only those who display meticulous attention to detail will be considered. An understanding of how to organize data in a tabular format is crucial. Please ensure you have relevant examples of similar tasks in your portfolio. Deliverables: - An Excel sheet filled with the provided numerical data, organized in a tabular format.
I am in need of an Excel professional with an intermediate level of proficiency to assist with various tasks on my project. The specifics of these tasks are open for discussion, therefore a degree of flexibility and adaptability is required. You should ideally have proven experience with data analysis, spreadsheet automation, and formula creation despite the fact these haven't been specified outright. An overview of your past relevant projects included in your bid would be highly appreciated. Convince me with your technical prowess and past success stories.
...hands-on research, which means you'll be conducting in-person visits to retail outlets and other relevant venues. So, local knowledge and a good grasp of the Bahrain's retail landscape are necessary. I need insights, not just data, so your ability to interpret and analyse the information you find is critical. Deliverables: Comprehensive report for each country with all the requested information. Excel sheet or Google Sheets document with detailed data. Duration: The project is expected to be completed within 1 week. Please propose a timeline for this project. How long do you estimate it would take to compete the entire project...
I need a proficient individual to assist with data entry into an Excel sheet. The data to be entered is purely textual, derived from printed documents and requires no complicated formatting. Key Responsibilities: - Transfer text data from printed documents to Excel - Ensure accuracy of data entered - Follow simple formatting guidelines Ideal Skills and Experience: - Proficiency in Microsoft Excel - Attention to detail - Experience with data entry - Fast typing speed - Experience working with printed documents This project is ideal for freelancers with a knack for accuracy and speed in data entry, particularly in Microsoft Excel. It involves simple one-word entries and familiarity with printed documents is advantageous.
NETCheck es una compañía especializada en consultoría y soluciones tecnológicas en entornos SAP, Microsoft, Open Source, Big Data, Ciberseguridad, BI e Inteligencia Artificial. Somos Microsoft Partner, con certificaciones: Gold en DevOps, Data Platform, Application Development y Application Integration, y certificación Silver en Cloud Platform. Desde el 2003 somos Service Partner de SAP . A lo largo de 22 años, hemos desarrollado proyectos para más de 100 compañías, tanto del sector público como del sector privado, en más de 15 países, incorporando en nuestros proyectos las mejores prácticas del sector. ¿Qué te ofrecemos? • Incorporación a una compañ&iacut...
...homeowners and businesses. The ideal candidate would be proficient in market research with experience in the specific industry, customer profiling, and an understanding of energy appliances. Knowledge of the local market is crucial. Your insights will shape our market strategy, so accuracy and attention to detail are paramount. Deliverables: Comprehensive report with all the requested information. Excel sheet or Google Sheets document with detailed data. Duration: The project is expected to be completed within 1 week. Please propose a timeline for this project. How long do you estimate it would take to compete the entire project....
Necesitaria el código para integrar en mi web de un formulario que los clientes puedan rellenar y me vuelque los datos a un excel de google, o a varios pdfs
I am in need of an expert in Excel data entry. The objective of this project is specifically for data entry purposes. The task involves keying in customer information into Excel. Familiarity with this type of data is a big bonus. Attention to detail, fast typing speed, and meticulousness are skills that are necessary to successfully complete the task. Additionally, extraction of specific information will be required. More specifically, identifying trends within a given period from the input data. Therefore, a keen eye for detail and an analytical mind are crucial for this job. In conclusion, if you have experience handling customer information, know your way around Excel, have a knack for finding patterns among data, and can type fast, I am looking forward to work...
We have an excel with macro script which converts a PDF (FFE 1a, 2a, 3a) to EXCEL (FFE) that allows us to be able to read all information we need. Unfortunately it is not working due to some changes in PDF (FFE 1b, 2b, 3b) as an extra page in the front has been added, so we are looking to hire someone that can fix this issue, so that excel can ignore this extra page.
I have an Excel sheet that needs to be filled with a combination of text and numbers. The sheet is not too large, falling within the 10-50 rows and columns range. I would also like the data to have a specific formatting, including the use of particular fonts and colors. Key Points: - The task mainly involves typing text and numbers into an Excel sheet. - The sheet consists of 10-50 rows and columns. - The final output requires specific formatting with designated fonts and colors. Ideal Skills and Experience: - Proficiency in Excel and data input. - Understanding of basic design principles for formatting. - Attention to detail to ensure correct typing and formatting. - Able to follow specific instructions for fonts and colors. Candidates with experience in similar d...
...received use this as a trigger to check if a new email is in another outlook 365 folder, if there is, save the attached excel file as a csv and rename the csv file the date of the email in YYYYMMDD format and save to a folder in onedrive for business. On successful completion send an email confirming success. >If there is no new email in the other outlook 365 folder, email our info@ email address notifying that it is not present. Repeat the checking process 2 days later until successful Flow 2: If a new email is received use this as a trigger to check if a new email is in another outlook 365 folder, if there is, unzip the attachment using a password, save the attached excel file as a csv and rename the csv files the date of the email in YYYYMMDD format and save to a f...
I need assistance with entering data into an Excel sheet. Ideal Skills: - Proficiency in Excel - Meticulous attention to detail - Fast, accurate typing skills - Experience with data entry and data organization Please note, the specific data format will be provided.
I have a project that involves typing text and numbers into an Excel sheet. - **Data Type**: The data is a mix of text and numbers. It's nothing overly complex - just straightforward typing. - **Sheet Size**: It's a medium-sized spreadsheet, containing 10-50 rows and columns. - **Formatting**: I don't need fancy formatting. Just simple data typing. Ideal candidates for this project would: - **Experience**: Demonstrated experience with data entry tasks in Excel. - **Accurate Typing**: Attention to detail is crucial, as the data is critical. - **Efficiency**: Completing the task in a timely manner is important for this project. Looking forward to working with you!
I need someone to create an external link in my Excel file to a PowerPoint presentation. The data in the Excel file will be updated daily. Requirements: - Creation of an external link from Excel to PowerPoint - Daily updates to the Excel file - No automatic updating of PPT needed. Manual updates are fine Ideal Freelancer: - Proficient with both Excel and PowerPoint - Experienced in creating external links - Comfortable with daily updates - Ability to follow instructions precisely.
Analizar Tabla de calculo de probabilidades de internet. Hacer lo necesario para comprender los calculos internos y poder replicarlos es un libro de excel. El trabajo comprende la hoja de Excel y la explicación de los calculos implicitos.
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 interfaces for Excel.
...that can convert PDF voter lists into Excel in a text format. Here's a breakdown of what I'm looking for: - Conversion Style: I'd like the tool to convert the PDF voter list by combining all columns into a single table. This will make it easier for me to work with the data in Excel. - Error Detection: It's important to me that the tool can automatically detect and correct errors in the text. Nevertheless, I also want to have the ability to manually review and correct the text to ensure its accuracy. - Language: In this case, the tool only needs to handle English language texts. You don't need to worry about incorporating multi-language support. Ideal Skills and Experience: - Proficiency in PDF extraction and conversion tools - Strong knowledge ...
I have a significant amount of text that needs to be typed into Excel quickly. The data is in a simple text format, no complex formatting required. Key requirements: - Proficient in Excel and typing - Attention to detail - Ability to work under tight deadlines The data is straightforward text and requires no specific formatting or analysis. The ideal freelancer will be skilled in data entry and be able to commit to a quick turnaround time.
I need assistance with ex...need assistance with extracting data from PDF files into Excel. The task involves: 1. Converting PDF to Excel: Use Adobe Pro to convert tabular data from PDFs into Excel. You can use cracked version to do this. 2. Formatting: The existing tables mostly match the required format but will need adjustments a. Remove unnecessary columns and rows and map the right column names. b. Convert hierarchical data to a flat format. There are 200 PDF files (10 of which have been already done but you can verify them as well), each averaging 4-5 pages (many files have 1-2 pages but there are some with more than 20 pages, averaging to around 4-5 pages per pdf) Here is a google doc that contains references of the pdfs and the expected excel...
I'm in need of assistance with certain advanced functionality in Excel. My project heavily depends on modifying complex Excel files and requires a specialist with a strong grip on: - Formulas and functions: Ability to apply and manipulate these is critical. - Statistical Functions: Will be used extensively, so expertise in this subset is necessary. - Lookup & Reference Functions: Another function set that the project necessitates. I'm looking for someone with remarkable ability to use these features to streamline data analysis and visualization. The completion timeline for this project is within the next month. Proven proficiency in Excel and the capacity to adhere to the given timeline is mandatory.
I need an online store data extraction specialist to pull key information (product name, price, and barcode number) from a particular online store. - The extracted data should be delivered in an Excel spreadsheet. - This is a one-time task; there is no need for continuous extraction. It's essential that you're proficient in web scraping techniques, able to navigate through the store's pages, and extract the right data accurately. Experience with online store data extraction is preferable. Please indicate any relevant past projects in your bid. Looking forward to working with a pro who can deliver quality results efficiently.
I'm looking for a freelancer to help with the data entry of a combination of text and numerical data into an Excel sheet. The data will be provided in digital text files. Key Requirements: - Proficiency in Excel and data entry - Attention to detail - Ability to accurately enter both text and numerical data Experience in similar projects will be an added advantage. Please include any relevant samples or references in your bid.
I need an Excel expert to perform a specific data analysis task for me. - The job involves conducting an analysis where two cells are fed values from 1-100. - The task is to find the highest value in a third cell, based on the values of the first two cells. - The values in the two initial cells should be generated using a combination of user input and random generation. Ideal skills and experience for this job include: - Proficiency in advanced Excel functions, particularly those related to data analysis and cell value calculations. - Experience with probability, permutation, and combination would be a plus. - A strong understanding of statistical analysis and data interpretation. This project would be perfect for someone who is detail-oriented, skilled in Excel, a...
As discussed, bird netting calculator editable pdf & xls conversion with formulas from excel, next button and submit.
...Vision API with their TEXT_DETECTION. More detail information from google on text extraction on remote image: The task involves extracting numeric digits using Google's TEXT_DETECTION feature from JPEG images hosted on a cloud server.: - Image URLs are provided in an Excel file (sample attached), with over 200 URLs. - The extracted numeric digits need to be added to the same Excel file in columns next to each corresponding image URL. We require only the digits with a length between 4 to 8 digits. Other text information is not needed. Google Vision API supports offline asynchronous batch image annotation for all features. The Google Vision API supports offline asynchronous batch image annotation for all features. https://cloud
...to generate QR codes within an Excel document. The QR codes will be primarily used for URLs. The Attached Document Need Text Data from "Sheet Data" Column A into B2 Need Text Data from "Sheet Data" Cloumn B into A11 as a QR Code Need Text Data from "Sheet Data" Cloumn C into G1 as QR Code The data will be manually pasted into "Sheet Data" I need this for 50 Sheets Pages to ignore Coverpage, Inside and Page Breaks Key Requirements: - Ability to generate QR codes in Excel: The end product should be an Excel script or add-in that can create QR codes based on the URLs provided. - Implementation of standard QR codes: Custom designs are not required. The focus is on generating functional, standard QR codes. - Ease of use: The...
I am looking for an expert to guide me through my upcoming SHL Numerical Reasoning Assessment. The current level of my understanding falls under the 'intermediate' category. I specifically need to strengthen my Problem Solving abilities before my deadline on April 17th. Ideal skills and experie...'intermediate' category. I specifically need to strengthen my Problem Solving abilities before my deadline on April 17th. Ideal skills and experience for this task would be: - Strong knowledge and experience in SHL assessments, especially Numerical Reasoning - Excellent in teaching Problem Solving strategies - Proven track record of coaching intermediate level candidates Your guiding hand will help me excel in this assessment. Please submit your bid if these requir...
