Excel vba macro charts 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.
I've got a PDF with simple table data. I need this data to be organized into an Excel spreadsheet. Key Requirements: - Extract simple table data from a PDF and neatly organize it into an Excel spreadsheet - Ensure the data is accurately transcribed without any errors - Maintain the table format in the Excel file Ideal Freelancer: - Proficient in data entry, particularly in transcribing table data - Experience with PDF and Excel - Attention to detail to prevent errors - Efficient and quick turnaround would be appreciated.
I'm in need of a proficient data entry professional who will enter customer data into Excel spreadsheets. Key Responsibilities: - Transfer customer data accurately into Excel - Double-check data for mistakes or inconsistencies - Maintain confidentiality of customer data Ideal skills and experience: - Proficiency in Excel - Attention to detail - Experience with data entry tasks - Strong understanding of handling sensitive customer data.
I am seeking a proficient freelancer who can effectively extract data from six graphs (line and area) and reproduce the graph in Excel. Please review the attached Excel file for grahps (3 of them are already processed as an example). Ideal Skills & Experience: - Demonstrated ability in data extraction - Excel competence - A keen eye for detail Freelancers should include examples of their past work for consideration. Your bid should be reflective of your skills and experience. I am looking forward to viewing your proposals. Please make them as detailed as possible.
I urgently require a professional to help me with an operations job. The specific tasks and software knowledge required are undefined as I am currently uncertain of my specific needs. Ideal Skills and Experience: - Experience in diverse operations tasks like data entry, order tracking, and document organization - Proficiency in using a range of software like Microsoft Excel, inventory management systems, and quality control software. A willingness to adapt and the ability to quickly pick up new tasks would be extremely beneficial for this role.
I have a significant amount of physical documents that need to be transferred accurately into an Excel spreadsheet. I plan to mail these documents to you on a regular basis for entry. Your responsibilities will include: - Accurately entering the data from the physical documents into an Excel spreadsheet - Ensuring that the data is error-free - Organizing the data in a clear and logical manner - Maintaining confidentiality and security of the documents The ideal candidate will have: - Proven experience in data entry, preferably from physical documents - Excellent attention to detail - Proficiency in Excel - Good organizational skills - Ability to maintain confidentiality Looking for a reliable and meticulous person for this ongoing project.
I am in need of a meticulous freelancer who can regularly update my inventory Excel file on a daily basis. This involves updating product names, quantities, and prices consistently, ensuring the most current information is readily available. The task doesn't stop with data updating. Once the inventory is updated daily, I also require in-depth and detailed reporting. From the plentiful data points, I am particularly interested in gaining insights on the following: - Identifying the most popular products. - Spotting products nearing depletion. - Highlighting our highest earning products. The successful freelancer should have exceptional Excel skills, with a knack for detailed work and a clear understanding of inventory tracking. Prior experience in inventory management...
I need an Excel spreadsheet designed for a project I'm working on that involves calculating the necessary Newton meters for a waterwheel and Newton meters of the hanging weights shafts, all while rotating. The front page of this spreadsheet will be dedicated to receiving calculation inputs. These will include: - Waterwheel dimensions: This involves measurements of the waterwheel, such as diameter, mass, etc. - Water flow rate: The rate at which water will be flowing onto the waterwheel. - Weight dimensions: Measurements of the weights that will be hung from the shaft. - Newton meters at the paddle: The unit of measurement for the Newton meters required at the waterwheel paddle. The ideal freelancer for this project should have: - Proficiency in Excel and d...
I'm looking to develop a Microsoft Access database to manage and print cage cards for laboratory mice from an existing Excel file. The Excel includes columns like Cage ID, Strain, Sex, Age, Mouse ID, and Notes, among others. Each card should group mice by their Cage ID and include relevant details such as Strain, Mouse ID, Sex, and Requirements:Database Development: Create a database from the Excel Card Design: Design printable cards with the listed Functionality: Enable direct printing from Interface: Simple UI for selecting and printing cage provide a quote and timeline for this project, along with any similar work you've done.
I'm looking for a Virtual Assistant with experience to find leads of night life connects on Instagram. Ultimately looking for people in night life who are connected with wealthy clients. And therefore they nig...looking for people in night life who are connected with wealthy clients. And therefore they nightlife people can serve as my affiliates and later help sell my social media services for commission. Key Responsibilities: - Find mini partners (affiliates) in nightlife: vip hosts, promoters, club managers club partner companies, etc. - Inputing the above prospects info (names and emails) on a google excel sheet Skills and Experience: - Critical Thinking - Proficiency in using Instagram for business research - Experience in lead generation - Bonus: Experience in the nig...
...to assist me in uploading my custom-made Excel Add-in to the Microsoft App Store. This involves making the Add-in available in Microsoft Office Excel's Add-ins. Key responsibilities include: - Uploading the Add-in to the Microsoft App Store: The candidate is expected to have experience with the Microsoft App Store's guidelines and processes. This includes preparing the necessary documentation, setting up the listing, and ensuring compliance with the platform's rules. - Making the Add-in available in Microsoft Office Excel: The candidate should be familiar with the process of making Add-ins available and accessible within Excel. This involves configuring the Add-in to be easily discoverable by users and ensuring a seamless integration into the Exce...
I need someone to help me set up an Eventbrite event page with a unique feature - reserve seating with a detailed venue chart. The venue has a seating capacity of 100 - 500 people and I would like the seating c...The venue has a seating capacity of 100 - 500 people and I would like the seating chart to be very detailed, including all rows and seat numbers. It's important that the freelancer is familiar with Eventbrite and can help me implement this specific feature. The ideal candidate should have: - Experience in setting up and editing Eventbrite events - The ability to create detailed venue seating charts - Strong attention to detail and accuracy Looking forward to working with someone who can bring my vision to life and ensure a smooth and professional experience for my e...
I'm looking for a Virtual Assistant with experience in lead generation for Instagram. However, I'm including in this post a training video so you under...acquiring valuable IG usernames and since my reps charge me a lot the only ones who can afford it is rich people. It also just so happens everyone who works in night life knows... rich people. :) Key Responsibilities: - Find mini partners (affiliates) in nightlife: vip hosts, promoters, club managers club partner companies, etc. - Inputing the above prospects info (names and emails) on a google excel sheet Skills and Experience: - Critical Thinking - Proficiency in using Instagram for business research - Experience in lead generation - Bonus: Experience in the nightlife industry Here's the video to watch:
As one aiming to maximize my productivity, I'm in need of a proficient data entry professional who can assist in data transcription, processing, and validation. This task revolves around: - Handling a medium scale data volume, approximately between 100-1000 records. - Processing data I have currently stored in an Excel Spreadsheet. Freelancers with the following skills are ideal for this job: - Expertise in Excel and data entry practices. - Experience in data validation. - Strong attention to detail. Your primary responsibility would be to ensure the accuracy and usefulness of my data efficiently. Your proficiency and speed are key to the success of this project.
I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current ...
I need a freelancer able to work effectively on PDF copy typing. The task would additionally require incorporating moderately complex tables and charts from the PDF into the typed document. Specific tasks include: - Copy typing from the PDF document - Inserting moderately complex tables and charts Ideal skills for this job: - Proficiency in PDF editing tools - Strong skills in data representation - Attention to detail Please provide examples of past work that involved similar tasks.
I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current ...
I'm looking for a designer who can make one single lead-generation landing page for a website of mine. The main goal of the website landing page is to collect contact information from potential customers. from an ad campaign on click of CTA button, this landing page has to come up. I will prefer the generated leads to get accumulated on an excel sheet if its possible. I WILLNOT RESPOND BACK TO people who bid blindly by sending their portfolios.
I'm in need of a meticulous individual with strong attention to detail for a medium-scale data entry project. This particular project will involve: - Transferring and managing approximately 1,000 to 10,000 entries into Excel - Utilizing basic Excel skills such as sorting and creating simple formulas Experience in similar data entry projects and proficiency in Excel, particularly in the functions mentioned above, is a must. Budget, deadlines, and other specifics will be discussed further during negotiation. Your ability to deliver accurate and rapid results without supervision will be key to the success of this job.
I have a one-time project that involves converting a PDF file with tables into an Excel spreadsheet. The main purpose of this conversion is to extract specific information from the tables. Key Requirements: - Convert a PDF file containing tables into an Excel spreadsheet - Extract specific information from the tables Ideal Skills and Experience: - Proficiency in Python - Experience with PDF to Excel conversion - Ability to extract information from tables If you have the skills and experience I'm looking for, please submit your proposal.
I'm looking for an expert who can build an interactive excel tracker tailored for Sales, Marketing, and Finance departments. In addition, I need a 30-60-90 days plan template to help with our digital transformation process. Key Responsibilities: - Develop an interactive excel tracker for Sales, Marketing, and Finance departments - Create a 30-60-90 days plan template for our digital transformation - Ensure the tracker is user-friendly and the plan is adaptable to our specific needs Ideal Skills & Experience: - Proven expertise in developing interactive excel trackers - Background in digital transformation is a strong plus - Strong understanding of Sales, Marketing, and Finance processes - Familiarity with creating strategic 30-60-90 days plans - Excellent c...
I require a skilled and detail-oriented freelancer to assist me in organizing electronic cor...to the case. - Data Input: The extracted messages should be input into a spreadsheet and organized by topic/subject. - Spreadsheet Creation: The spreadsheet should include the following fields: Date, Message Content, and Attachments and also print and file all correspondence in date order etc. Ideal Skills and Experience: - Experience in data entry and organization. - Proficiency in using Excel/Spreadsheet software. - Familiarity with legal terminology and document handling (an added advantage). - Excellent attention to detail and organizational skills. More details will be provided to the selected freelancer. Please provide examples of similar projects you've completed in...
I am in urgent need of a professional well versed with Excel Operations to help typify a vast array of data into an Excel sheet. The data includes: - Text - Dates - Numbers A key part of this project involves adhering to specific formatting requirements, which include: - The application of currency formatting - Utilizing bold or italic text when necessary - Highlighting certain cells This is a time-sensitive project that requires immediate attention, therefore the ideal candidate should be able to commence work ASAP. Your experience with Excel, data entry, and attention to detail will be highly beneficial in executing this project.
I'm looking for a freelancer who can download pictures from an excel list that will be provided (see 2 attachments). Following are the specific project requirements: We need those pictures in 2 separate folders (f.e. zip or rar file), one for each excel list. All pictures must be saved with Superaction excel file Pictures must be saved with their code. f.e. (code is in column A). If in Column F there are more than 1 pictures, then save 2nd, 3rd etc. pictures like: , adiddv0318_4.jpg... Always in Column F (URL's for download), pictures without _a, _b... are the main picture (therefore must be saved like ). Pictures with _a, b.. etc. must be save as 2nd, 3rd ... (, ). If in Column F there is no picture without _a
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current ...
I have a one-time project that involves converting a PDF file with tables into an Excel spreadsheet. The main purpose of this conversion is to extract specific information from the tables. Key Requirements: - Convert a PDF file containing tables into an Excel spreadsheet - Extract specific information from the tables Ideal Skills and Experience: - Proficiency in Python - Experience with PDF to Excel conversion - Ability to extract information from tables If you have the skills and experience I'm looking for, please submit your proposal.
I am looking for a professional with expertise in data entry a...conversion of my text-based PDFs into a spreadsheet format. Accuracy is essential in this task. Ideal Skills: • Proficiency in data entry • Experience with converting PDFs to excel or similar formats • Meticulous attention to detail ensuring 100% accuracy Responsibilities: • Convert text-based data from PDFs to spreadsheets error-free • Maintain record consistency, structure, and format during conversion • Verify the converted data for accuracy The successful candidate will have ample experience with data entry and PDF conversion, boasting a track record of impeccable accuracy. Knowledge of spreadsheet software like Excel is a must. Each transaction listed on one line, a templ...
I am in need of an individual to assist in extracting email addresses of all child care centers and compiling them into an Excel spreadsheet. Key project details: - Purpose: The extracted email addresses will be used as part of a contact database. - Usage: The contact database will primarily be used to offer services or products to these child care centers. Ideal skills and experience: - Proficient in data extraction and Excel spreadsheet handling. - Ethical data practices - the extraction must be legal and compliant with GDPR and any other relevant regulations. - Previous experience in email extraction or database creation would be a definite plus. This project will require a keen attention to detail and the ability to ensure accuracy in the data extracted.
I need a freelancer to scrape text data from a PDF and output it into separate cells by paragraph in an Excel document. Key Requirements: - Extract and convert text data from a PDF into a structured Excel file. - Each paragraph should be in a separate cell in the Excel sheet. Ideal Skills and Experience: - Proficiency in PDF scraping and Excel data entry. - Attention to detail to ensure accurate data transfer. - Understanding of text formatting to ensure the data is organized accordingly in the Excel sheet.
I'm in need of a top-notch data entry freelancer who can accurately input data into Microsoft Excel. Working primarily with text and numeric data, the project simply requires a keen eye for detail, a high level of accuracy, and exceptional Excel skills. It's crucial to note that there will be minimal data cleansing involved - the data should just be entered as it is. This job will suit someone who: * Has proven experience in data entry * Is proficient in using Microsoft Excel * Office365 online documents editing * Can ensure accuracy with minimal supervision * Extreme organised * Perfect English written and spoken.
I need assistance with EXCEL- Working with Multiple Worksheets and Workbooks The task is quite urgent, so I need someone who can start right away and complete the project in a timely manner.
I need assistance transferring data between Excel sheets Key requirements: - Data transfer: I'm unsure if this needs to be a manual or automatic process. I'm open to suggestions that will make the process efficient and error-free. - Randomising 'Task Types': This column needs to be randomized each time data is transferred. The 'Task Types' should be selected from a specific range of values. Ideal skills for this job: - Proficiency in Excel )
I need an Excel expert to review and make suggestions for how they would improve a register workbook which I have already created for tracking Quality System Document and Record Control. The register is a template which my quality systems consulting customers use to track procedures, policies, and work instructions, as well as active and archived records. I expect the expert to have a strong understanding of Excel, formulas, functions, and design of excel workbooks so that they look professionally made and are also easy to use (and perhaps also customise if required). The final product should look professional and offer an effortless way to track quality system document controls as well as support the managers and users of the system. Proficiency in Excel and ba...
I need a web-based application that can automate the swapping of tags with data from an Excel sheet. Key Requirements: - The application should be accessible online and be compatible with major browsers. - It should provide an interface where I can upload an Excel sheet with the necessary data. - The application must be able to recognize specific tags in a template and replace them with corresponding data from the Excel sheet. - should work with PDF , Word document - Document / Arrangement Formatting MUST be maintained - Able to export into doc or pdf Experience and Skills Required: - Proficiency in web development, particularly in creating online applications. - Strong experience in working with Excel files and data extraction. - Knowledge of automation techn...
We are currently seeking a highly skilled Senior Web Designer to join our team on a freelance basis, with a potential pathway to full-time employment. Ideal candidates will hav...Key Requirements: Proven experience in designing sophisticated websites at a senior level. Expert knowledge of UX/UI principles, responsive design, and current web technologies. Ability to collaborate closely with our development team to ensure seamless implementation of designs. Strong communication skills and a proven track record of meeting deadlines. This role is suited for individuals who excel in a dynamic, fast-paced setting and are open to transitioning from freelance to a full-time role. We are excited to offer this opportunity to tackle engaging challenges and advance at the cutting edge of web t...
I am seeking an experienced photo editor who can help elevate my personal photos. The tasks required include: - Basic retouching to improve overall image quality. - Background removal to highlight the photo's main subject matter. - Lighting adjustment to amplify the mood of the image. Knowledge of JPEG format is necessary as all images come in this format. ...Knowledge of JPEG format is necessary as all images come in this format. Ideal candidates will have a keen eye for detail and the ability to enhance images in a tasteful manner. A sensitivity to personal photography and an understanding of image composition will also be highly regarded. The aim here is to ensure every image conveys the story beautifully. If this sounds like a project you'd excel in, I would lo...
I'm in need of a professional's help to create static line graphs in Microsoft Excel for scientific data presentations. Ideal Skills and Experience: - Proficiency in using Microsoft Excel to create line graphs - Experience with scientific data visualization - Understanding of best practices in graph creation Additional notes: - The data for the graphs will be provided to you - The graphs are expected to be clear, accurate and visually appealing - Familiarity with scientific terminology is a plus, but not strictly required.
...YouTube Shorts Scriptwriter in the Tech Niche. 1) Skilled Writer + 2) Technology Enthusiast. [Long-Term, Per-Project Pay] We are launching a new YouTube channel dedicated to exploring emerging and interesting technologies. Our goal is to stand out with content that captivates and educates by delving into the latest interesting technological advancements and innovations - from AI products, VR, to macro level tech changes. This role is perfect for someone who is deeply passionate about technology, stays abreast of tech trends, and possesses a witty and engaging writing style. You are always on twitter, product hunt, etc… and you get excited about cutting-edge developments. You will be paid on a per-project basis. Responsibilities: * Write engaging, informative, and creativ...
Seeking a skilled and experienced Data Analyst to sift through unspecified data sources. As the data type, desired insights, and current storage system have not been specified, I am looking for someone highly flexible and adept at handling all types of data, formats, and analysis needs. Ideal Skills and Experience: * Proficiency with Excel, database, BigQuery, JSON, and CSV file formats * Experience working with sales data, financial data, and customer data * Ability to identify sales trends, perform customer segmentation, and analyze profitability Please note that the specifics will be provided upon project commencement. We look forward to hearing from data analysts who can adapt to different data types and uncover valuable insights.
I'm working with an existing Excel spreadsheet that contains date data. I need help with sorting and filtering these dates. PROBLEM: I have different data set (mm/dd/yyyy and dd/mm/yyyy) in the same column exchanging every 100rows or so...data set is about 70000rows I dont want a solution I want you to teach me how to resolve this because this is something ill do for some time now and i need to know how i can do it by myself. Key Requirements: - Sorting and filtering the dates in the spreadsheet effectively. - Ensuring the sorted and filtered data can be used for additional calculations within the same spreadsheet. Ideal Skills and Experience: - Advanced proficiency in Excel, with a strong understanding of date functions. - Previous experience working with large data...
