Export excel data 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.
2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.
I have an Excel billing sheet and need a new Excel document that connects with it. The purpose of this document is to pull a few fields from the billing sheet and present them in a form layout. Key requirements: - The new Excel should pull the following fields from the billing sheet: - Invoice Number - Client Name - Total Amount Due - Date of Service - Service Code Ideal skills for the job include: - Proficient in Excel - Experience with designing forms in Excel - Knowledge of linking data between Excel sheets.
As discussed basically want it to look like an excel sheet, all the scanner names lined up at the top and have the stocks come down under each. and scanner in this order Multi Scanner, Breakout High, Daily High, Volume Inc. , % to change gainer, Intra Day Rise, Hug 9 EMA, HODspike, 2minSpike2. Have scanners update every 2-3 min.
I'm seeking a data analyst skilled in TTR (Turnaround Time) evaluation, specifically focusing on trends over time. Key Requirements: - Analyze historical TTR data to identify trends over time. - Utilize provided Excel/CSV files for the analysis. - Present findings in a clear and understandable manner. Ideal Skills: - Proficient in data analysis and statistics. - Experience with TTR analysis. - Able to work with Excel/CSV data files.
I need a data analyst to evaluate an Excel spreadsheet containing project data. The analysis should cover run rates, forecast dates, and schedule adherence on a weekly basis. Ideal Skills: - Proficient in Excel - Experienced in data analysis - Able to interpret project metrics No set rules for this analysis; it is simply a test to assess your ability to perform basic data analysis.
I'm Mandeep Kaur, a 25-year-old seeking help with data entry tasks. You will be primarily tasked with: - Excel data entry - Assisting with filling out application forms Skills & Experience: - Proficient in Excel - Detail-oriented and able to accurately fill out forms - Previous experience with data entry preferred Looking forward to your bids!
...videos. Core Features: - User registration via email, phone and website - A categorized template library for banners and videos - User-friendly customization options (add text/images, change size/color/position) - Fixed footer for brand details (phone, email, website) - An Admin panel to upload/manage templates - Google AdMob integration for ads before download - Option for users to download/export their customized designs Tech Requirements: - Frontend: React Native - Backend: Node.js with Firebase/MongoDB - Media processing: Libraries for image/video editing - Ads: Google AdMob Deliverables: A polished, functional app with an admin panel and clean, well-documented code. Additional Features: - Push notifications as a platform-specific feature - A diverse template library inc...
we need a Data architect with following requirements for 2-3 months assignment( 1 position ) Required Skills & Experience Required Profile 7+ years of experience on Database warehouse / lake house programming Experience in implementing at least 2 end-to-end data warehouse / data lake projects Experience in implementing at least 1 Azure Data warehouse / lake house project end-to-end Converted business requirements to concept / technical specification Worked along with source system experts in finalizing ETL and analytics design Support data modeler developer in design and development of ETLs Creation of activity plan as per the agreed concept with timelines Technical Expertise: Strong experience with Microsoft Azure components, including Azure Dat...
I'm looking for a web-based scri...traffic, jamesdomains, etc.) - Import domain name revenue for cost comparison - Add domain name costs per extension (e.g., .com, .net, .xyz, etc.) to monitor yearly costs of each portfolio - Export files per portfolio, as well as a global export - Backup daily and send via email The script should use a simple Username & Password authentication method. The ideal freelancer for this project should have prior experience in domain management and web script development. Knowledge of domain valuation and renewal processes is a plus. The script should allow for import/export in CSV and Excel formats. I'm open to additional features you may suggest based on your expertise. Please only apply if you are serio...
...vocabulary-building board game for kids (same as Scrabble game - image attached). The logo should reflect the educational and fun nature of the game, appealing to both children and their parents. Requirements: Game Name: The logo must prominently feature Vocabble. Slogan: Include a slogan like below: "Play, Learn, Master English" "Building Brighter Minds!" "Unlock the Power of Words!" "Play, Learn, Excel!" ..... or you can suggest one. Design Style: Clean, modern, and colorful, appealing to families. Avoid overly complex elements. Format: Deliver in vector format (illustrator/corel draw format )and high-resolution PNG/JPEG for print and digital use. Need source file with all the fonts and elements. If you have any questions, pls dm ...
...creating a custom web application with a primary focus on data analytics and reporting. Key Responsibilities: - Develop a robust custom web application - Implement user management features - Integrate data analytics and reporting functionalities - Ensure seamless integration with various data sources Ideal Skills: - Proficiency in Laravel and Vue - Extensive experience in REST API development - Strong background in data analytics and reporting - Skilled in working with databases (e.g., MySQL, MongoDB) and APIs (e.g., REST, GraphQL) The project will involve integrating with multiple data sources, including databases and APIs. Experience with external data sources such as CSV and Excel will also be beneficial. Your ability to handle com...
...transform multiple Excel sheets into an interactive Power Apps platform for various users. The project also includes the creation of a comprehensive dashboard. Key Requirements: - Transforming Excel sheets into a user-friendly Power Apps - Developing a dashboard tracking performance metrics, operational statistics, and assisting with actions and decisions Dashboard Visualizations: - Bar charts and line graphs - Pie charts and donut charts - Tables and matrices - Conditional formatted tables Additional Considerations: - Power App must support multiple clients in an Active Directory format Ideal Skills and Experience: - Proficiency in Power BI and Power Apps - Experience in creating interactive dashboards - Knowledge of Active Directory configurations - Ability to visua...
I'm in need of a Python script that can extract numerical data from an Excel/CSV file. The ideal freelancer for this project should: - Have extensive experience with Python, particularly in data extraction. - Be proficient with handling Excel and CSV files. - Be able to write clean, efficient code. Please note, the data will be purely numerical. The script will need to be able to handle large datasets with ease.
Objetivo del Proyecto Desarrollar una solución automatizada en Python que procese archivos Excel mensuales con múltiples tablas no estructuradas, extrayendo y organizando la información en un formato estructurado y agregando control temporal a los datos. Alcance del Proyecto Desarrollo completo del script en Python usando Jupyter Notebook Documentación del código Manual de usuario para la ejecución del script Requisitos Técnicos Tecnologías Requeridas Python 3.8+ Pandas Openpyxl/XlsxWriter Jupyter Notebook Funcionalidades Principales Procesamiento de Archivos Lectura de archivos Excel (.xlsx) Capacidad de procesar múltiples hojas Manejo de archivos de gran tamaño Control de errores y validaciones ...
Build quote template as below - 1. Polish quote template 2. Macro to create new tab 3. Macro to add new slot in existing quote 4. PDF generation with Inclusion and Exclusion List 5. Push quote info to CRM (if API exists)
I need to create 1 or 2 shortcut keys with macros in Excel for automating the formatting and reporting of my data. Ideal skills for this job: - Proficiency in Excel - Experience in creating and implementing macros - Ability to automate tasks efficiently
Hi, we need the attached PDF document to be translated from Italian to German, destination: Switzerland. We don't have the OCR for this, but I send you both the Word editable document of the first part, and the Excel that contains the following part (table). Please, use the Word and the Excel documents to create one only final document, like the PDF. I kindly ask you to add [unleserliche Unterschrift] wherever a signature appears. We don't have any specific deadline for that.
...assist with various bookkeeping tasks. Key Responsibilities: - Recording transactions: Timely and accurately inputting all financial data - Reconciling accounts: Ensuring all accounts are balanced and discrepancies are addressed - Generating financial reports: Preparing clear and concise financial statements - Budgeting: Assisting in the preparation of budgets - Auditing: Conducting internal audits to ensure financial accuracy - Forecasting: Providing financial forecasts to aid in strategic planning - Invoicing: Preparing and sending out invoices - Project bookkeeping: Keeping track of finances for specific projects - Must know QuickBooks, NetSuite and Excel Ideal Candidates Should Have: - Extensive experience in bookkeeping - Proficiency in using accounting software - ...
Email Marketing Project Details Objective: Send two email campaigns to 5,000 current sports bettors with accounts who have not yet made a deposit. Project Overview: Target Audience: 5,000 recipients. Data provided in Excel format (includes recipient email addresses and other necessary details). Email Content: Email 1: Includes a dynamic, clickable banner and text for sports bettors. (both provided by me. Naturally I want your input). Email 2: Sent three days after the first email, includes new text aimed at casino and slots players (provided by me). Sending Details: Emails should be sent from a professional-looking sender name such as: "Mike Spencer – Your V.I.P. Host". The sender email address must be configured to forward any replies directly to my email. T...
I need an existing Excel spreadsheet, which tracks employee data, to be transformed into a secure, user-friendly system. Key Requirements: - The system should provide view-only access to certain users, while others can edit designated sections. - It should automate calculations and formulas, as well as validate data entries to ensure accuracy. Ideal Skills: - Proficient in Excel with experience in spreadsheet security and access control. - Capable of creating automated systems within Excel. - Previous experience with HR-related spreadsheets is a plus.
...website. The ideal candidate should have substantial experience in developing multiple combo offer pages like Buy1-Get1,Buy2-Get2 & Buy3-Get3 pages, gift card pages, gift pages, coupon pages(from admin pabel), OTP verification, Abandoned cart notification, order notification and payment gateway integration Note 99.9% website has to be managed through Dashboard, like editing pricing, bulk import,export,bulk move with-in pages, bulk edit, bulk delete, Hide category, in page pages or multiple pages, Edit in one page or multiple pages, though coded the website has to act plug and play Ecommerce Website USP - We give return gifts to customers based on Invoice size- hence the designs is detailed accordingly You need to first ensure that Gift cards with 16 digit or 12 digit secur...
...un portal de empleo leader pero queremos procesar los datos de esos candidatos desde diferentes pragramas de mailing para lo cual necesitamos extraer algunos campos básicos de esa web a la que nos tenemos que logear, ir a la oferta en concreta, al listado de candidatos y de ahi extraer esos datos básicos del candidato (por ejemplo nombre, email, teléfono, experiencia, etc) y pasarlos todos a un excel. Actualmente lo estoy intentando hacer yo a través primero de Selenium y ahora con ParseHub, pero no soy experto en esas herramientas y me da siempre problemas ademas que el portal de empleo tiene sus controles para evitar este tipo de acciones e imagino que hay que tener los trucos o el conocimiento determinados para solventas estas cuestiones como los ca...
In my company the arrival of the inventory to the warehouse is recorded manually in the attached excel file, in the tab "ARRIVO PRODOTTI". Each product is assigned a specific row. For each row the following columns are filled in: ARTICOLO (item code) DESCRIZIONE (item description) DATA PREVISTA (estimated availability date) I° REVISIONE DATA (first revised availability date) II° REVISIONE DATA (second revised availability date) III° REVISIONE DATA (third revised availability date) QTY (quantity) STATO (status) I would need a button for each row, next to the column STATO. The button, powered by a macro, when pushed should trigger an email to be sent to a list of internal recipients, with subject and text filled in with ...
...organization of electricity and water bill data (PDF format) into a specific Excel structure. We will provide sample bills AND a detailed mockup of the desired final output format. This ensures your solution directly addresses our exact needs. Data Points (extracted from PDFs): Company Name Flat/Shop Number Account Number Disconnection Notices (flag/status) Electricity, Water Consumption Municipality Period Start Date, End Date Previous Balance, Total Amount Due Key Requirements & Deliverables: Automated Extraction & Formatting: Develop a Power Query workflow to: Pull data points reliably from PDFs according to the provided format guide . Structure the extracted data...
I'm seeking genuine wholesalers interested in buying fresh farm leafy greens from Sri Lanka for export to countries such as Bhutan, Nepal, Myanmar, and Maldives. Key Requirements: - Target Buyers: Exclusively wholesalers, who are capable of purchasing in bulk. - Quality Standards: The vegetables must meet the standards of fresh farm produce. Ideal Freelancer Skills: - Extensive network with vegetable wholesalers - Experience in the vegetable export industry - Ability to verify quality and freshness of produce - Strong communication and negotiation skills
I'm looking for a WordPress professional to assist with the installation and configuration of SEO and OTP plugins on my site. 1. I want to add data by one person or by team or upload contacts in bulk, I want to have the facility to get contacts approval? When a new listing is added in my website a. From link posting advertisement- , the advertiser should get whats app or mail or SMS for confirming or declining the advertisement. or b. Upload bulk listings available in excel file containing listings data from admin panel using plugin wpallimport plugin, all numbers should get whats app or mail or SMS for confirming or declining the advertisement. 2. Need to disable the mail id as mandatory field and would like to have
I'm looking for an expert who can gather 5000 verified email IDs of researchers in the fields of agri-business, food, and retai...for an expert who can gather 5000 verified email IDs of researchers in the fields of agri-business, food, and retail from global sources, particularly focusing on academic journals, google scholar, and university directories. The email list should be delivered in an Excel spreadsheet. Key Requirements: - Expertise in data collection and verification - Familiarity with academic journals and university directories - Proficiency in creating and delivering data in Excel Ideal Skills and Experience: - Previous experience in similar data collection projects - Strong attention to detail for email verification - Excellent unders...
I'm in need of professional Excel templates tailored for the construction industry. These will be specifically for quotations and invoices. Key Requirements: - The templates must include: - Client details and project scope - A breakdown of material and labor costs - Payment terms and due dates - The templates should be visually appealing and aligned with our brand: - Incorporating our company logo and branding colors - Special layout and design elements Ideal Skills and Experience: - Proficient in Microsoft Excel with a strong understanding of template design - Previous experience in the construction industry is a plus - Graphic design skills to ensure a professional and appealing layout - Attention to detail to ensure all necessary information is included
Excel Spreadsheet & Invoice Creation Assistance Excel Spreadsheet & Invoice Creation Assistance
Copywriting, pdf, data entry, excel, word
I need someone to convert my 28 page bank statement from PDF to Excel. - You will need to extract all details from the bank statement. - The data should be formatted into a standard table format on Excel. - No further data processing is required after extraction. Ideal candidates will have: - Experience in data entry and PDF to Excel conversion - Attention to detail to ensure all information is accurately captured. check sample
I need assistance with managing hospital paperwork and invoicing using Microsoft Excel. Requirements: - Managing patient records and billing/invoices in Excel - Utilizing an existing template for patient records - Following a specific format for billing and invoices Ideal Skills: - Proficient in Microsoft Excel - Detail-oriented with ability to follow specific formats and templates - Experience with hospital paperwork and invoicing preferred.
Want to recreate this spreadsheet to add another section, a sixth one called Operations Also want to add our company logo
...customer portal. It will have 30 pages with different functions and all pages should be responsive. Pages will include but won’t be limited to: Business portal/CRM - Registration. - Settings (with business info.) - Login. - Events (where businesses can see all there events) - Create an event. - Edit event. - Create a menu. - Event summary and food order. - Individual food order. - Exports to excel - Food orders(sorted by course and table). - seating management Customer portal - Register. - Login. - Register and create an event. - Login and create an event. - Customer profile page. - Future events. - Past events. - Event details - Info page. - Event details - Food orders. - Guest food order - single page. - Food menu. - Guest list. - Add an admin. - seating manage...
...- Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result with my budget, Not your Expectation If you accept my term apply this task: Budget:Rs 900 I will give good review, if you complete my budget, Dont expect more money, Money will paid after complete the job successfully, dont waste your time and bid If you have exp...
I'm looking for a talented food photographer and videographer to create engaging content for my social media platforms. The shoot will include a variety of shots, from close-ups of the food to action shots of the cooking process. Key Requirements: - Capture of different types of shots including close-up/macro shots, plated dishes, and action shots (cooking in process) - Use of a neutral and natural style of photography - Ability to create content that will appeal to a social media audience Ideal Skills and Experience: - Prior experience in food photography and videography - Strong understanding of social media content creation - Ability to shoot and edit high-quality visual content
I need a macro or script for my Google Sheets and Excel to automate data entry. Specifically, I want it to automatically pull bold information from a specified source into designated columns, as demonstrated in a provided video. Ideal Skills: - Proficient in creating macros in Excel and scripts in Google Sheets. - Strong understanding of data entry processes. - Able to follow visual instructions precisely. Please note, the exact source of the bold information will be provided in the video.
...will automate the process of downloading quotations from shipping lines and airlines, displaying the data in a user-friendly format, and allowing for edits to create customer quotations. Key features of the web app include: - Advanced data processing: The app needs to handle complex tasks such as data extraction, transformation, formatting, and validation. - Manual upload function: This should allow users to upload rate templates from shipping lines via Excel or CSV files. - Format standardization: The app should assist in converting inconsistent rate formats from different shipping lines into a specific Excel template before upload. - Compatibility: The app needs to process and convert Excel, CSV, and PDF files. User roles: - The app will ha...
I'm looking for a data analyst who can help me assess the performance of various projects based on Excel spreadsheet data. Your primary focus will be determining actual run rates, based on project entries and forecast dates, as well as identifying whether projects are ahead or behind schedule. Additionally, I would like you to provide both a written report and visual aids (charts and graphs) as part of your deliverables. Ideally, you should have a strong background in data analysis and visualization, with a good understanding of Excel. Experience with project performance analysis would be a plus. Please note that there are no set rules for this analysis; it is simply a test to assess your ability to perform basic data analysis.
I'm looking for a freelancer to source and add leads to an excel sheet based on specific criteria. Key Responsibilities: - Use LinkedIn to source leads based on current Job Title and Company Name - Include Name, Job Title, Company Name, and Email in the Excel sheet - Ensure that the leads apply to the industry and job function Ideal Skills and Experience: - Proficient in using LinkedIn/ search for lead generation - Detail-oriented with strong data entry skills - Familiarity with different levels of job titles within companies - Excellent communication and organizational skills - Proven experience in lead sourcing would be a plus The leads should involve the highest-level manager for that particular company within Drug Supply-Sourcing. The job titles and company...