Excel vba commands 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.

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.

Offline typing job,data entry job

Financial Statements based on Excel template and Data - you product financial Statement with filled out excel based on data given We need an expert Freelancer to enter basic financials data to attached financial Projection in Excel and produce a profit loss statement based on this Excel attached and the data of company projected Revenues and expenses Simple if you have done it before You will send us back the filled out excel with sheet tabs including the Financial Planning Tab and Profit Loss. Budget is $200 - $300 +/- Very Simple just summarize and detail the data correctly any questions or data you need for this ( not given in attachments in zip ) we will give you You need to put all Hungarian Forint Currency Do the conversion from Euro as shown i...

I am looking for an experienced freelancer who will assist with copying data from my Microsoft Word and Excel documents. The copied data will then be pasted into Google Sheets. Key tasks include: - Copying data accurately from existing Word and Excel documents - Pasting the data into a new Google Sheets document - Organizing the data in a clear, readable format Ideal skills and experience: - Proficiency with Excel and Google Sheets - Demonstrated experience in data entry - High level of accuracy and attention to detail.

Seeking a freelancer with expertise in Excel and PowerPoint for a project involving more than 5 Excel files. The task at hand is to assist with presentation design. Skills and Experience required: - Proficiency in Excel and PowerPoint - Strong design skills - Experience with handling multiple Excel files - Attention to detail and ability to create visually appealing presentations

I need a professional with a significant background in data management, who can assist me in streaming entire worksheets live from my desktop Excel file to my Google Sheets. The core requirement is to: - Stream the entirety of my existing Excel worksheet data into Google Sheets instantaneously and update it in real-time. The ideal freelancer should: - Be experienced in data integration across various platforms. - Possess comprehensive expertise in both Excel and Google Sheets. - Have a past track record of successfully completed data streaming related projects. - Be able to implement a solution for real-time data update.

I'm seeking a versatile individual to assist in constructing the digital framework for a groundbreaking think tank. The ideal candidate will excel in the following areas: - Website Development: You will be responsible for constructing a user-friendly platform that encompasses discussion forums, document sharing, and other essential features. - Forum Features: You'll need to design and implement efficient user profiles, thread categorization, and effective comment moderation. - Document Sharing: The platform should support the sharing and collaboration of research papers and reports. Experience or skills in the following areas are highly valuable: - Intelligence analysis and investigative journalism - Data analytics and project management - Mental health and spiritual m...

...based on scam score thresholds to notify users of potential threats. Documentation: Provide comprehensive documentation for installation, configuration, and usage of the plugin. Testing and Quality Assurance: Conduct thorough testing to ensure functionality, reliability, and security. Required Skills and Qualifications Splunk Development: Proven experience in developing Splunk apps and custom SPL commands. API Integration: Experience with RESTful API integration and handling JSON data. Frontend Development: Skills in HTML, CSS, and JavaScript for UI design within Splunk. Cybersecurity Knowledge: Understanding of cybersecurity and threat analysis. Problem Solving: Ability to troubleshoot and resolve issues during development. Communication: Strong communication skills for clear do...

...Telegram bot that interacts with the community. The bot will primarily distribute tasks and that can be completed by the community members. Key Features: - Task Distribution: The bot must be able to distribute tasks to the community members. The tasks can vary and can be adjusted on the backend. - User Interface: The interaction should be through buttons and menu options, not text or voice commands. - Reward System: The bot should also provide rewards for the completion of tasks. -Referral System - Raffle Draw System The ideal freelancer for this project should have experience in: - Telegram bot development - UI/UX design for chatbots - Implementing reward systems in software - Task automation and distribution via bots Please note that the bot will be used by the community...

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

I am looking for a detail-oriented professional who can assist in copying and pasting data for my business, BD Company. Required tasks: - Copy data provided in Excel sheets. Ideal Skills: - Proficient in Microsoft Excel - High attention to detail - Strong data entry skills Apply only BD interested person.

I am looking for a developer who can design a data uploader for my website. The primary purpose of this tool is to allow me to upload different types of files such as Excel spreadsheets, CSV files and Text files into my website's backend. Key Requirements: - Support for multiple file types: The uploader should be able to accept a variety of file formats, including Excel spreadsheets, CSV files, and Text files. - Basic Data Validation: Before the data is uploaded, I need this tool to perform basic data validation. This would involve checking for field completeness to ensure that all necessary fields are populated before the upload is allowed. Ideal Skills and Experience: - Proficiency in web development: The ideal candidate should have a strong background in web develo...

I'm looking for an google sheets / excel guru who can construct an advanced drop-down lookup system for my entire sheet. This system should include multiple variables that will inform the price from the database. Currently looking up values manually in a series of tables, tables may need reformatting to allow for efficient searching Key skills and experience: - Proficient in MS Excel Advanced Functions - Experience with both numerical and text data - Knowledge of creating drop-down lookups for entire sheets The final product should streamline our decision-making process by providing agile, accurate prices based on the selected variables. Your comprehensive understanding and application of numerical and text data within an Excel environment will be key to the s...

I'm seeking a meticulous data entry professional who can convert physical documents filled with text data into an Excel spreadsheet. Key Requirements: - Conversion of physical text data documents into an Excel spreadsheet - High level of accuracy and attention to detail to ensure the data is entered correctly - Ability to maintain data confidentiality - Must be able to meet deadlines Ideal Skills: - Proficient in data entry and managing data using Excel - Excellent attention to detail to ensure the accuracy of the entered data - Previous experience in handling sensitive or confidential information - Ability to meet deadlines and ensure timely delivery of the project - Strong communication skills to provide updates on the progress of the project

I require a VBA Developer well-versed in automating repetitive tasks in Microsoft Excel. Your primary task is to automate my existing work functions to increase efficiency. Key Responsibilities: * Understand the current Excel operations and identify scope for improvement. * Develop VBA codes to automate basic standard operations. * Test the robustness and accuracy of the automation. * Combining 2 files into 1 pdf. 1st file is pdf and 2nd is excel(with selected sheets, and selected columns within sheets) Desired Skills & Experience: * Proficient in VBA, specifically for Microsoft Excel. * Experience in automating repetitive tasks. * Sharp problem-solving and debugging skills.

Seeking a proficient Excel VBA developer to aid in the centralization and automation of tasks in Excel 2010. Project requirements include: - Expertise in Excel latest version - Strong understanding of EXCEL VBA for automation purposes. Please note, specific tasks and functions to be automated in VBA have yet to be defined. Flexibility and broad knowledge in different Excel functions will be considered an asset.

I am looking for a professional with strong data entry skills to assist in transferring text data from digital documents into an excel sheet. The successful candidate should possess: - Reliable accuracy in typing - Fast typing speed (numeric keypad advantageous) - Proficiency in Excel (VLOOKUP, SUMIFS, Pivot Tables, etc.) - Able to interpret written information swiftly - Excellent attention to detail for proofreading entered data. This task will require someone with experience in handling large volumes of data entry, with absolute prioritization on maintaining the integrity and accuracy of the inputted data. Any previous involvement in similar projects handling text data is highly desirable. Understanding of and/or a background in just managing digital document data will...

Necesito un excel simplificado y parametrizado (formulado) para comparar si vale la pena comprar o alquilar una propiedad, según gastos y costo de oportunidad.

I need someone with specialized skills in password recovery to restore a forgotten password for an Microsoft Excel worksheet. This task requires a professional password hacker. I require one spreadsheet opened and password recovered and removed. Skills and Experience required: • Proficiency in programming languages, particularly those relevant to password recovery. • Expertise in methods of password recovery for Microsoft Excel worksheet xlsx files. • Strong ethics - the information on this spreadsheet must stay confidential. • Can deliver results within 7 days. • Will pay on successful confirmed completion only.

I require a proficient freelancer to design a distinctive Excel file that will be used for web form completion. Once the Excel file is uploaded, the system should automatically read and fill the corresponding fields. These may be a composition of dropdowns, text or checkboxes with comprehensive validation, such as numbers-only constraints, email format requirements, date format validation, dropdown list checks, value ranges among others. Ideal Skills: -Qualified in Excel -Understanding of data validation Experience: -Web development -Scripting in Excel -Web form design -Experience designing similar projects Please note that while the specific dropdown fields were not detailed, anticipate flexibility and adaptability in the code to conform to possible changes...

...an intuitive application. This app is intended to utilize LangChain and OpenAI's language model in categorizing PDF files into different groups; namely invoices, HR-contracts, or MOUs and then under go different ways for each document catagory: A. in case of invoice: - extract the data inside invoice (invoice number, date, buyer name, total amount sold, and total due amount) and save them in an Excel file. B. In case of HR-contract: - simply move the file from the existing location to the HR-contract folder. C. In case of MOU: - simply move the MOU from the existing location to the MOU folder. Details: - Your responsibility is to build a desktop application that processes and accurately categorizes data from complete PDF files. - You are required to utilize LangChain for...

I require a proficient Excel expert with strong skills in data analysis and organization. The primary tasks you will handle include: - Analyzing business-related data - Organizing the analyzed data in an easy-to-understand format The purpose of these tasks is to help streamline business reporting processes. You must be adept at dissecting large volumes of data and summarizing key points to help inform business decisions. The final deliverable should be a standard Excel file that details the organized and analysed data. Relevant skills needed include data analysis, Excel proficiency, and a keen understanding of business data interpretation.

I'm seeking a computer science tutor to guide me through QuickBooks and Excel. - Topics include QuickBooks, Excel, data structures, algorithms and programming languages. - Primarily need help with data entry and organization in QuickBooks and Excel. - Additionally, assistance with Formulas and Functions in Excel is required. Ideal candidate should have: - Proficiency in QuickBooks, Excel and knowledge of data structures and algorithms. - Strong background in programming languages. - Experience in tutoring or teaching will be a plus. Please note that the volume of entries or rows of data is minimal, less than 100. Looking forward to your proposals!

Are you looking to master SQL, Excel, or Python? Look no further! With years of experience in data analysis and programming, I offer comprehensive tutoring services tailored to your learning needs. **What I Offer:** 1. **SQL Mastery:** From basic queries to advanced database management, I'll guide you through understanding SQL syntax, optimizing queries, and database design. 2. **Excel Expertise:** Whether you're a beginner or looking to enhance your Excel skills, I'll cover everything from formulas and functions to data visualization and automation. 3. **Python Proficiency:** Dive into the world of Python programming with personalized lessons covering fundamental concepts, data manipulation, scripting, and more. **Why Choose Me?** - **Tailored App...

I'm looking for a capable designer who can create a modern style title card for a jukebox. Key Requirements: - The design must be modern in style - The final deliverable should be in a word or excel format to allow for editing Content: - The title card should include the song title and artist in the right portion - A photo element should also be incorporated for visual appeal in the left portion. I'd like a card similar to the one you see here. It's exactly 18cm wide x 12cm high. However, the photo portion should be smaller, as the text does not contain the Artist, which I need. I have attached some examples here. Photos # 4 5 and 6 are from my actual machine. I need to edit and make 100 of these. There should be 22 columns on the right side for the Numbe...

...not essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Windows OS - Experience in handling multiple databases with SQL - Strong troubleshooting skills I currently manage over 11 databases via Microsoft SQL Server Management Studio, and my system operates on Windows. You would be working an 8hr paid day i...

I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs

As a beginner level MySQL user, I am seeking someone to sit with me (virtually) for approximately 2-3 hours to aid me in running certain MySQL commands with some provided databases. Beyond this, I need assistance in creating a new database from scratch. The session will be conducted via Zoom, and it's vital that you have the requisite MySQL software and databases already installed on your own device. My needs during the call include: - Writing MySQL commands - Understanding MySQL commands - Creating a fresh MySQL database Ideal freelancer for this task would have a strong command of MySQL and proven experience in teaching or tutoring, as well as excellent communication skills in English.

I am in need of an excellently crafted web form that can carry out addition calculations. The main purpose of this form is to accurately calculate the cost of chosen servi...system should be able to add up the costs of selected services. - Data entry: Your form would need to support product selection-based data entries. - User interface: the form should be easy to navigate, with clear instructions for inputting service choices. Ideal Candidate: - Proven experience in designing excel forms with integrated calculation logic. - Ability to design a user friendly interface. - Eye for detail, as the calculator must produce very accurate results. - Strong knowledge of Excel features and data calculation techniques. - Excellent communication skills to understand requirements and del...

I'm seeking a proficient Excel expert who can assist me with enhancing my current study time tracker. I need the following features to be incorporated: - Auto-calculation of total study hours: I'd like for this to be automatically summed up based on the inputs provided. - Auto-calculation of average study hours per day: This should also be done automatically, providing me with a clear view of my daily commitment. - Study hours per subject: I require a part of the spreadsheet to allocate study hours to specific topics that I am learning. The spreadsheet will be utilized for tracking my study progress across different subjects. It should allow for easy input of study hours and materials covered. I will provide the current version of the spreadsheet to the chosen freelan...

I have an Excel spreadsheet containing a list of data, from which I need specific email addresses extracted and organized. Key requirements: - Extract email addresses: You'll need to go through the spreadsheet and locate email addresses contained within the data. - Excel Organization: The extracted email addresses should be neatly and accurately organized in the Excel spreadsheet. Each email should be placed in a separate cell. Ideal Skills: - Proficient in Excel: Ability to efficiently navigate and manipulate data in Excel. - Data mining and extraction: Skilled in identifying and extracting specific data from larger datasets. - Attention to detail: Accurate organization of email addresses is crucial. - Time management: Ability to work efficiently ...

I have a requirement to develop a bespoke Microsoft Excel spreadsheet to calculate sales commissions. Let me share the specifics: - The variables: I want this spreadsheet to take into account the Sales Volume, the Profit, and the Commission Percentage while computing sales commissions. - Calculation specifics: Commission should be determined according to a custom formula that considers the Commission Percentage. - Data input: The spreadsheet should be easy to use, allowing me to manually input the data for calculation. The ideal freelancer for this project would be someone well-acquainted with the mechanics of Microsoft Excel and its formulas. Relevant experience in the field of sales calculations would be an asset. I am trusting that this tool will enhance efficient dete...

I have a substantial Excel spreadsheet that requires competent attention. I'm on the lookout for someone who's proficient in: - Data entry - Data cleaning Your role will primarily involve entering various types of data that's currently on an Excel spreadsheet. Despite the data being available, it's in a raw unclean format that needs some cleaning. The ideal freelancer is someone who's used to working with Excel and recognizing inconsistencies, errors, and redundancies. Additionally, anyone versed in: - Proficient in Excel usage - Strong attention to detail - Experience in data cleaning - Strong data entry skills would be extremely helpful in achieving the goals of this project.

I need a proficient Excel specialist to develop a spreadsheet that will calculate gross pay based on clock in and clock out times. Some work-shifts will start on one calendar day and not clock out until the next calendar day (example- clock in May 1 at 3:30pm - clock out May 2 at 12:30am). It should also factor in specific overtime rules for the workplace, including: - Weekly overtime after 40 hours. -All hours on any given workday shall be paid at the straight time rate of pay unless forty (40) hours have already been worked at straight time. No matter the length of route: example- a driver's bid/scheduled route may be 10.8 hours, as long as the employee does not work any additional hours other than those bid/scheduled, they will be compensated at straight time rate of pay unl...

I'm in need of a meticulous professional to clean a mixed set of data contained in an Excel file. I am specifically struggling with duplicate values and missing entries. To effectively accomplish this: - You should possess excellent skills in data analysis and data management. - Previous experience with Excel-based data cleaning is preferable. - Profound knowledge of dealing with duplicate entries and filling in missing data is required. - A keen eye for detail and ability to spot and correct errors is essential. In summary, my ideal candidate would be someone with significant experience in data cleaning, particularly with mixed data in Excel files. It would be a bonus if you've previously resolved issues related to duplication and missing entries in da...

I'm looking for a skilled data analyst to help me with a comprehensive statistica...comprehensive statistical analysis of a survey I conducted with roughly 100 participants. Key Requirements: - Proficiency in Descriptive, Inferential, and Correlation data analysis techniques - Experience in interpreting survey data to identify trends and patterns - Ability to test hypotheses and make inferences - Knowledge of how to determine relationships between variables - Excellent skills in Excel and/or other statistical software or python for data manipulation and analysis Ideal Candidates: - A data analyst with a proven track record of handling survey data - Someone who can derive meaningful insights from the data - Excellent communication skills to explain the results in a clear and...

I have an Excel file that is corrupted and won't open. The latest version has over 5000 columns which I need retrieved. I have a previous version of the Excel file with over 4500 columns. The Excel file was last saved on a USB and I am using Excel 2016. I do have a backup copy of the corrupted file. Key Tasks: - Recover the latest version of the Excel file with over 5000 columns. - Integrate the data from the previous version (4500 columns) into the latest version. - Ensure all data is intact and functional. Skills and Experience: - Expertise in data recovery and Excel. - Proficiency in Excel 2016. - Attention to detail and thoroughness to ensure that all 5000+ columns of data are successfully retrieved and integrated. Please bid wit...

...a knowledgeable Excel VBA specialist, with a background in data manipulation and analysis, to create a custom macro for my spreadsheet. - The macro's primary function is to automate the creation of new rows based on certain numeric values, namely the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ideal freelancer should have solid experience in creating advanced Excel VBA macros, and a strong und...

...experienced MS Access developer to assist with my form development tasks. The ideal candidate is proficient in VBA (Visual Basic for Applications) coding and has the ability to design and implement forms based on my specifications. Key Responsibilities: - Designing and developing database structures based on my project requirements - Implementing VBA code for basic functionalities such as form submissions and data entry automation - Creating forms in MS Access based on a specific design I have in mind - Ensuring the database and forms meet quality standards and are user-friendly Ideal Skills and Experience: - Proven experience in database design and development using MS Access - Proficiency in VBA coding, particularly for basic functionalities - Previous experienc...

I'm in need of an Excel expert who can help me compile a detailed file for the merger of PVR and INOX. The document should contain two main sections: - Financial Data: - I require you to list the revenue, expenses, and profit/loss figures. These should be clearly presented in a way that allows easy comparison. - Merger Details: - You will also need to include specific merger details. This includes the merger date, the terms of the merger, and the name of the merged company. The ideal candidate for this project is an experienced Excel user, with a proven track record in data analysis and a keen eye for detail. You should be comfortable working with financial data and able to present complex information in a clear and insightful manner. Experience in mergers...

I am interested in creating an Excel VBA macro that will allow me to import PDF invoices into line items and parse them. The objective of this project is to streamline the process of invoice data entry by automating the extraction of key information from incoming PDF invoices, namely Invoice number, Vendor name, Pricelist, and Detail. The successful freelancer for this project should have: - Demonstrated experience in creating VBA macros for Excel - A strong understanding of PDF parsing and data importation - Knowledge of accounting principles is a plus The imported data should ideally be formatted in Excel as: - Each PDF invoice should be translated into a single row - The extracted information should be available in separate columns for each piece of ...

I'm in need of an experienced data entry specialist who is proficient with Excel and has a good attention to detail. The project is small scale, requiring less than 100 entries of numeric and text data to be input accurately. Requirements: - Skilled in data entry - Experience with Excel - Attention to detail - Efficient work pace The ideal candidate would have ample time to complete the project quickly. Make sure the entered data has to have no errors and is accurate since the output will be used for further analysis. Final format: Data should be delivered in an organized Excel spreadsheet.

...IF YOU CANNOT WRITE EXCEL MACRO TO SCRAPE THE DATA. PYTHON SCRAPPER DON'T NEED I'm in need of a VBA developer who can help in creating a small code for scraping contact details from a specific website. The task involves creating a button in an Excel file that triggers the scraping process and saves the extracted data back into the same Excel file. Note : Project budget is only 6k because it will take max 2-3 hour for experience developer Key Requirements: - Scrape contact details from - Specifically, scrape Owner Name & Address - Implement a function where a user clicking a button triggers the scraping process - Save the extracted data back into the same Excel file Ideal Skills & Experience: - Proficient in VBA programmi...