Macro excel workbook standalone 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.

lojnjg gyguuuuuuuu gg jbjiiihhtft kiyoio

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.

File Attached

Offline typing job,data entry job

i have the excel file you need to analyse the data and I want to you create advanced PowerPoint presentation presentation it need to be present to the big forums, primarily aimed to the top management. The presentation should reflect a professional and corporate style, with clear, concise content and well-structured slides. Ideal Skills and Experience: - Proficiency in PowerPoint - Experience in designing corporate presentations - Excellent understanding of corporate language and presentation etiquette - Ability to condense complex information into clear, digestible content - Creative approach to maintaining viewer engagement within a professional context.

I need assistance in fixing and enhancing my Excel reports that are generated daily, weekly, monthly, and yearly. 1. Please fix the Stock Performance tab with Top 20 & Bottom 20. Its never worked when 2 or more companies have the same % gain/loss. 2. Commodities & Chart_All_Commodities, I changed the commodity on a few of them including Antimony, Germanium, Gallium, Platinum & Niobium. This seems to work on the Commodities tab, but I have to manually update the Chart_All_Commodites Tab, please fix this. 3. Please add 5 new Blank Commodities & Project Location Areas so it allows me to add specific ones in that field and it automically updates to the Chart_All_Commodities & Chart_All_Project Location Area too 4. Can you add a filter by Market Cap for the who...

I have over 5000 documents, primarily in PDF format, that require document processing. I need a python script that can sift through these documents to extract allergens and nutrition information, and then compile this data into separate CSV files. Key Requirements: - The documents include not just standard PDFs, but also Excel and Word files. Some of these are scanned PDFs that contain both images and text. - The script needs to be able to interpret and extract relevant information from all of these formats. - The analysis needs to be performed on documents written in English. Ideal Skills: - Proficiency in scripting languages such as Python. - Experience with data extraction and analysis from various document formats. - Familiarity with handling and interpreting scanned documents...

I'm looking for an Excel expert to create a comprehensive Mess Management Excel sheet. Requirements: - Tracking of student Mess fees - Fee calculation and tracking functionalities Ideal Skills and Experience: - Proficiency in Excel - Experience in creating expense tracking systems - Ability to incorporate complex fee calculations Please include examples of similar projects you've completed in your bid.

I'm looking for a proficient Excel expert with strong macro programming skills to create a comprehensive Excel sheet for processing data from my securities trading reports and FX market data. This is for the purpose of tax filing. I just update the FX page and the trade data and it produces the pnl sheet for me. I’ve attached the sheet with the required output. I need a macro to automate this sheet for me. Key Requirements: - The Excel sheet must be able to process various elements from my trading reports, including trade dates and times, transaction amounts, and securities identification. - The sheet will also need to incorporate data from FX market feeds. Ideal Skills: - Advanced Excel skills - Strong experience with mac...

I'm seeking an experienced Excel specialist to create a software-based Gantt chart for me. This chart should incorporate task dependencies, progress tracking, and resource allocation capabilities. Key Requirements: - Proficiency in Excel with a strong understanding of its advanced features. - Experience in creating interactive, software-based Gantt charts within Excel. - Ability to incorporate task dependencies, progress tracking, and resource allocation into the Gantt chart. Ideal Skills: - Advanced Excel skills - Project management software experience - Strong attention to detail - Excellent communication skills

I am in need of a skilled Excel professional who can perform comprehensive financial analysis on my personal finance data. Key Responsibilities: - Analyze my personal finance data using Excel - Provide insights on key financial metrics - Build template for tracking personal finance Ideal Skills: - Proficient in Excel with a strong understanding of data analysis techniques - Experience with Finance formula like : Present Value, Future value, formats - Able to present complex data in a clear and concise manner

I'm looking for a freelancer who can assist me with my sales data. The tasks primarily involve data entry, data cleaning, and data analysis. The dataset is relatively small, with less than 1,000 rows. Ideal skills for this project: - Proficient in Microsoft Excel - Experience in data entry - Strong data cleaning skills - Capable of performing data analysis Please bid if you have the required skills and experience. Thank you!

I need help with creating a detailed report from my Excel file. The report should be structured with sections and include pie charts. Additionally, it should contain a comparative analysis. Ideal Skills and Experience: - Proficiency in Excel - Data Analysis - Report Writing - Chart Creation

I need an experienced freelancer who can convert my .xlsx Excel sheet into Avery format address labels. Ideal Skills: - Proficient in Microsoft Excel - Familiar with Avery label layout templates - Attention to detail for accuracy

...leverage the potential of NLP and Large Language Models in extracting intelligent insights by linking large datasets, including reports, documents, images, and videos, available with the Client. The solution should operate on standalone hardware without internet connectivity and support a cloud architecture for at least 1000 concurrent users. The architecture must address Big Data's Velocity, Volume, Value, Variety, and Veracity while ensuring security compliance. (a) Model will be trained on large amount of variety of data such as documents, handwritten text, excel sheets, power point PPTs, word documents, BRs, equipment manuals, IR images, reports, letters, faxes, flow diagrams, charts, block diagrams, videos, training books, medical reports (all variants of medi...

I need help with capturing data from a website. The data is displayed in a table format below a chart for a particular facility. I want to capture monthly data for all time periods for all facilities on the website. Key Details: - The data is easily selectable and copyable. - I want the final data saved to an Excel spreadsheet. - If possible, I would like the use of a VBA macro for ease of use. Ideal skills for this project include: - Proficiency in Excel, particularly with creating and using macros. - Experience with data extraction from websites. - Attention to detail to ensure all data is accurately captured. Budget is $50

I'm looking to scrape 10000 restaurant websites in Australia to analyze their payment gateways. The primary purpose of this task is to conduct competitor analysis. I also need to gather the contact information from these sites. The ideal freelancer for this task should be skille...should be skilled in web scraping, data analysis, and have a keen eye for detail. Requirements: - Extensive experience in web scraping - Proven track record in data analysis - Ability to gather and organize contact information - Skills in competitor analysis - Attention to detail The scraped data should be provided in Excel format. Please ensure that the payment gateway details are included as part of the contact information. Please organize the scraped data in an Excel file format that you ...

I'm seeking a freelancer to design an Excel reporting template to track our membership enrollments. The template will primarily handle registration data, specifically focusing on membership sign-ups. Key Features: - Automated Calculations: The template should perform relevant computations automatically. - Visual Charts and Graphs: The template must convert data into easy-to-understand visual representations. - Data Filtering and Sorting: The template needs to facilitate easy sorting and filtering of data. Ideal Skills: - Proficiency in Excel, particularly in creating complex templates. - Experience with data visualization - Strong understanding of membership enrollment processes. With this project, I hope to simplify our reporting process and enhance our data interpre...

...and company communications. Skills and Qualifications * Good communication and writing skills, with the ability to convey information clearly and concisely. * Proven experience in mortgage advising, banking, or a related sales /operations environment. * Strong organizational skills with meticulous attention to detail. * Proficiency in using CRM software and office applications (e.g., MS Office, Excel). * Bachelor’s degree in Finance, Business Administration, or a related field. * Strong networking and relationship-building skills...

I'm looking for an experienced iOS developer to create a mobile app similar to M-cals. The primary feature of this app should be a comprehensive Calorie Tracker. Key Requirements: - Development of an iOS app with a focus on usability and intuitive design. - Implementation of a robust and accurate calorie tracking system. - No need for third-party integrations; the app will be standalone. Ideal Skills and Experience: - Proven track record in iOS app development. - Experience in creating health and fitness apps. - Strong understanding of calorie tracking systems. Your expertise in creating user-friendly, functional apps will greatly contribute to the success of this project.

Dashboard Creation We are seeking a highly skilled and experienced Excel Expert to create professional and visually appealing KPI Dashboards in Excel. The ideal candidate should have extensive knowledge of advanced Excel functionalities and a strong ability to translate data into actionable insights. Proficiency in Google Sheets is a plus. Key Responsibilities: Design and develop customized KPI Dashboards in Microsoft Excel based on business requirements. Collaborate with stakeholders to identify key performance indicators and define dashboard objectives. Use advanced Excel formulas, functions, and tools (e.g., VLOOKUP, INDEX-MATCH, SUMIFS, Pivot Tables, etc.) to process, analyze, and visualize data effectively. Create dynamic and interactive dashboards ...

Macro and VLOOKUP assist

...some work done. Getting a new CRM . I need insightly crm setup. I need the crm connected to my website. The CRM is insightly crm. 1. I use 3 types of categories in the CRM. Leads, Pipeline, and Customers. 2. Perfexcrm is installed on aws i need it removed. 3. Leads and Pipelines are in the same type. 4. Customers business name. Managers come and go, so Business names. 5. I have my own provided excel sheet, items in my leads and customers. 6. I have built a form for new leads. I need it to import all new leads I enter with phone form. 7. I need for all new customers to be added to customers not leads from website. 8. I need a to setup tabs, to send commands to your system. Like grade of each lead or send emails. Or other commands. 9. Need to setup templets for emails for ...

I'm looking for a professional who can design a template for certificates for business communications. The ideal candidate should have expertise in Microsoft Word and Excel, particularly in mail merge functions. Key Requirements: - Design a professional certificate template with space for date and signature. - Assistance with mail merge from Excel to Word. - Ensure dates are formatted correctly into UK format. I have some knowledge on how to do this but I'm currently having difficulty getting the dates into the correct format. Your expertise and assistance would be greatly appreciated.

...year-over-year growth). Expected Deliverables: Updated spreadsheets with automated calculations, summaries, and visualizations. Easy-to-use graphs and charts for ongoing analysis. A dashboard (if feasible) to provide at-a-glance insights into class performance. Documentation or a brief walkthrough of the updates to ensure the system is user-friendly and sustainable. Skills Required: Advanced proficiency in Excel (or Google Sheets) with expertise in: Pivot tables Graphs and charts Conditional formatting Formulas for automation Experience with creating interactive dashboards (optional but preferred). Ability to analyze data and recommend actionable insights. Ideal Candidate: The ideal freelancer is detail-oriented, has strong problem-solving skills, and can translate raw data into ...

I need an Electrical Contractor or equivalent experienced in 3 phase, commericial electrical work as well as 24v occupancy sensor work and in-conduit wiring to generate an extremely detailed electrical take-off from blueprints which I will provide in PDF format. I need the result to be an excel spreadsheet with columns for "Item" "Quantity" "Description" "Location" etc. It needs to include the lengths of conduit by type/size as well as wire as well every box, conduit elbo, panel, service entrance item, light, switch, etc. The take-off needs to formatted as such that I can send it to various electrical supply houses for material pricing. Take-off is ONLY needed for electrical sheets, E001, E101, E211, E212, E221, E222, E231, E511, E601 ...

I'm seeking a skilled professional to convert my Tableau workbooks into PowerBI. The primary focus of this workbook is for comprehensive financial reporting. Key Requirements: - The PowerBI version must include interactive dashboards, automated data refresh and custom visualizations - Experience working with cloud data warehouses is essential as this is the primary data source for the workbook. - Prior experience in creating financial reporting dashboards in PowerBI is a plus. Ideal Skills: - Proficiency in Tableau and PowerBI - Expertise in designing interactive dashboards - Familiarity with cloud data warehouse - Ability to create custom visualizations - Knowledge in financial reporting. Engagement will come in two parts: 1) initial conversation with client to have...

I'm in need of an Excel list containing at least 5,000 UK-based healthcare and wellness companies, specifically hospitals and clinics, fitness centers and gyms, as well as wellness spas and retreats. Key Requirements: - The list should include the business name and address for each company - The data should be delivered in .xlsx format Ideal Skills and Experience: - Proficient in data mining and Excel - Previous experience in compiling business lists - Understanding of the healthcare and wellness sector is a plus.

I'm looking for a Virtual Assistant to help me with an important task involving my sales leads. Key Responsibilities: - Gather and compile all provided Excel files containing sales leads into a single, comprehensive Excel sheet. - Organize the leads in alphabetical order from A-Z. - Identify duplicate entries and highlight them in yellow for easy identification. Duplicates can be same address, or company name, or phone number etc. - Ensure that the final document is clean, organized, and easy to read. Ideal Skills: - Proficient in Microsoft Excel or similar spreadsheet software. - Detail-oriented to ensure duplicates are marked accurately and the final document is neat. - Good organizational skills to compile and sort the leads effectively. Please note, ...

I'...vertical line on the chart to identify a particular price bar. When I place a vertical line on the chart, I want the script to extract the following information and send it to an Excel sheet: 1. The date of the price bar 2. The time of the price bar 3. The price (it should consider the high price of the bar if I use a green vertical line, or the low price of the bar if I use a red vertical line) The exact specifications of the project, including the precise format for the data, can be found in the attached document. Key requirements: - Expertise in TradingView and its scripting language - Proficiency in Excel and data formatting - Attention to detail Placing a bid on this project confirms that you have read and understood all the details in the attached docume...

I'm looking for a skilled data manager to assist in consolidating financial data. Key Responsibilities: - Extract financial data from multiple Excel financial statements - Compile the data into a single Excel sheet Ideal Candidate: - Proficient in Excel - Experience with financial data - Detail-oriented and able to ensure data accuracy

Seeking a full-time member to ...48 hrs/week. If we find during that period that you are a good fit for the role, this could become a long-term position. Our budget for the job is $2/hr USD. Requirements -- Available Mon - Sat, 9am - 7pm NYC time -- Great visual eye -- Attention to detail -- Fluent in English -- Great communication (verbal and written) -- Patience -- Experience with Google Docs, Google Calendar, & Microsoft Excel preferred -- Content writing experience is a plus. -- Newsletter management is a plus. Roles & Responsibilities -- Quality check photos and provide feedback to photo editor. -- Schedule photography appointments with clients and photographers. -- Respond to customer inquiries via email promptly. -- Send lead generation messages. -- Online resear...

I'm in need of an Excel spreadsheet designed to meticulously track my sales team's performance, both weekly and monthly, as well as year-to-date (YTD). The primary focus will be on sales performance metrics. Key Requirements: - The spreadsheet needs to be capable of tracking various sales performance metrics - It should be able to capture data on a weekly, monthly, and year-to-date basis - It should be user-friendly and easy to update Ideal Skills and Experience: - Proficiency in Microsoft Excel - Experience in designing sales tracking spreadsheets - Understanding of sales performance metrics - Ability to create user-friendly and easy-to-navigate spreadsheets I appreciate your bids and look forward to working with a professional who can help me with this project...

I'm looking for a financial tracking solution that automatically links and consolidates my expenses from my credit cards and bank accounts in both Argentina and the USA into a single Excel sheet or similar. Key Requirements: - Automatic linkage of all my checking, credit card and savings accounts. - Consolidation of expenses into a clear, comprehensible format. - Support for specific banks from Argentina and the USA. Ideal Skills and Experience: - Proficient in financial software and Excel. - Experience with linking bank accounts and credit cards for expense tracking. - Knowledge of specific Argentine and USA banks. - Ability to present data in a comprehensible format.

I'm looking for a professional Excel expert who can help me format a spreadsheet containing contact details into a user-friendly, easily sorted and searchable data reference guide. This is a single spreadsheet with 15 columns within 11 headings and about 13 rows of data entry. Specific formatting and ease of search and sort are key. Ideal Skills and Experience: - Proficient in Excel with advanced formatting skills - Experience in creating searchable databases - Strong attention to detail - Ability to understand and implement a specific project vision

I'm looking for an expert in Smart Sheets with experience in healthcare quality systems. The project involves building sheets, reports and dashboards that track operational metrics within a cloud-based quality managemen...reports - Strong understanding of operational metrics in healthcare The ideal candidate should have a keen eye for detail and a strong background in data analysis, as well as the ability to present complex data in a clear and concise manner. I am looking for someone who can deliver high-quality work on time and can communicate effectively throughout the project. We need to date a mesh inputs from Excel Given security issues and access issues the bill will have to be done with me in real time sharing screens. I’m looking for someone to help walk me thr...

I need a comprehensive Smartsheet dashboard for monitoring daily hospital operations. This dashboard should cater to all units in the hospital, inc...ideal candidate will have experience with Smartsheet and data visualization tools like Tableau. Key requirements include: - Integrating various data sources: Excel/CSV files, Online Smartsheet forms, and a Database - Creating dynamic views for different operations teams - Designing the dashboard for ease of use and comprehension Skills and experience needed: - expert Proficiency in Smartsheet - Experience with data manipulation and visualization - Ability to design user-friendly dashboards - Understanding of hospital operations would be a plus I want the dashboad in smartsheet to be similar to to the dashboard we are using in ex...

I need an Excel expert to elevate my sales data spreadsheet into a high-end, professional looking document, perfect for data presentation. Key Requirements: - Extensive experience with Excel and data visualization. - Ability to incorporate company branding seamlessly into the spreadsheet. - Understanding of the principles of professional, high-quality design. Important Elements: - Integrate company logo and color scheme. - Create a visually appealing layout that enhances data presentation. Ideal Skills: - Excel - Data Visualization - Graphic Design in Excel - Branding Please note, this project is not about altering the underlying data, but about making the spreadsheet visually impressive and suitable for professional use.

...create a comprehensive Excel spreadsheet template with macros, active control options, and bar charts for my company, Measurement Solutions, Inc., an industrial distributor specializing in measurement equipment. This template will be used for quoting custom gages. The project will involve: - Creating macros to automate calculations, generate custom quotes, and handle data validation and cleanup. - Designing the template to input various types of data including customer information, product specifications, pricing details, and delivery information. - Incorporating bar charts for price/time comparisons. Ideal skills for this job include: - Advanced Excel expertise, particularly in creating and implementing macros. - Experience with data validation and cleanup in Excel...

Puede usar chatgpt sin abusar. De ello Descripción del proyecto: Tengo un documento en Word que estoy convirtiendo en un Ebook, pero necesita varias mejoras para que quede profesional. Las tareas que necesito que realices son las siguientes: Correcciones: Ortografía y gramática. Redacción y estilo para mejorar la claridad y presentación. Estructura general del texto. Índice: Crear un índice nuevo. El índice debe incluir solo las especialidades y las enfermedades en orden alfabético, sin repetir la especialidad encima de cada enfermedad. Enumeración: Las enfermedades están actualmente enumeradas, pero el formato no es estético. Necesito que cada enfermedad tenga una enumeración clara, organizada y...

...dealing specifically with store or warehouse properties. The data must be organized in an Excel spreadsheet with the following columns: - Company - Phone - Email - Website - Address Accuracy and precision are paramount. The details must be correctly and meticulously recorded. The data should be sourced primarily from online directories, although any reliable source will be considered. The final step of the project will involve verifying the gathered information to ensure its correctness and reliability. Ideal skills for this job include: - Proficient in data collection and analysis - Excellent attention to detail - Familiarity with online directories and verification processes - Proficient in Excel I'm looking for a professional who can deliver a comprehensive,...

I have a picture of an Excel template that I need replicated. The template primarily consists of tables and is primarily text-based. I also need specific text formatting including bold and italics, as well as colored text. Ideal skills for this project: - Proficiency in Microsoft Excel - Attention to detail for accurate replication - Ability to format text according to specifications

Hello, We are developing a standalone module to analyze product specifications using OpenAI API. This module should allow users to upload specification documents via a simple "Upload" button, extract predefined parameters, and provide them as outputs in a clear format. This module will operate independently but should also integrate seamlessly into our existing .NET Framework and MVC5 based product selection software. Scope of Work: File Upload Functionality: Develop a UI element (e.g., an "Upload" button) to accept specification documents in PDF, Word, or plain text formats. Specification Analysis: Use OpenAI API to extract key parameters such as airflow, energy efficiency, and other technical details from the uploaded documents. Result Output: Display the e...

...requirements are as follows: - Data Count: I'm looking for a dataset that contains between 50,000 to 100,000 customer records. - Specific Details: The data should primarily include contact information. Other customer details such as purchase history or demographic information are not required. - Delivery Format: The contact information should be delivered in an Excel format. Ideal skills for this project include data mining, Excel proficiency, and experience using Apollo's data extraction tools. Please provide a realistic timeline for data extraction and any prior experience you have with similar projects. Hi, I’m looking to gather data from Apollo with the following criteria: Company Type: B2C companies Headcount: Maximum of 500 employees Engagement: C...