Excel vba openoffice basic 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...
Usealla isolla yrityksellä on käytössään Suomessa eräänlainen heidän alansa ERP-paketti, joka on koodattu Visual Basicillä. Tarvitsisimme VB-osaajaa ylläpitämään ohjelmistossa mahdollisesti tehtäviä muutostöitä. Tekniikka lyhyesti: • Visual Basic -koodia noin 280-290 000 riviä • Integraatio taloushallintoon ja palkan maksuun • raporttipuolella n. 50 000 riviä • Crystal Reports • Microsoftin SQL Server -kanta Työmäärät vaihtelee, mutta keskimäärin 1-2 päivää/viikko. Välillä hiljaista.
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.
...elementor pro:n päälle tehty sivusto. Haluan sivustolle esim woocommercella tehdyn tuotekatalogin, jossa erottelen uudet veneet omaksi välilehdekseen, ja käytetyt omaan. Haluan itse pystyä päivittämään sivustoa, olen itse rakentanut nykyisen sivun, mutta kaupan integroimista ulkoasuineen en hallitse. UPDATE: I have a website , I have built it with wordpress 5 and elementor pro. I have basic knowledge about installing and maintaining the website but need help integrating woocommerce and building simple product catalog. For example this website of my competitor has quite simple catalog for used (brokerage) and new boats: Also this one is something I have been looking for: They have also a simple configurator
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.
2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.
I'm currently working on an Excel sheet for performance analysis and I need assistance with writing the SUMIF formula. Key Requirements: - Assist with writing the SUMIF formula for my Excel sheet (vlookup, countif, and other formulas are not needed for this project) - Ensure the formula fits within the context of performance analysis Ideal Freelancer: - Experienced in Excel and in particular, writing SUMIF functions - Knowledge of performance analysis or related fields is a plus
I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me resolve these issues promptly.
I'm in need of an AutoCAD expert to help me create some basic architectural drawings. The level of detail required is simple - I need the fundamental layout and structure of a building illustrated. Key Responsibilities: - Create clear, concise architectural drawings using AutoCAD. - Ensure the drawings accurately reflect the basic layout and structure of the building. Skills and Experience: - Proficiency in AutoCAD. - Experience in creating architectural drawings is ideal. - Strong attention to detail. - Ability to work efficiently and meet deadlines.
...It doesn't need to be very detailed. Drawings with dimensions will be provided, as some machines are customized and have different dimensions (but same shape). If successful, we will follow with more work to do the interior design of our new lab using the aforementioned machines. Requirements: - Interior Design Modeling experience - Level of Detailing: I'm looking for moderate detail with some basic textures, giving a realistic feel to the model. - Experience: Prior experience in interior design modeling is a must - Communication: A clear and open line of communication is crucial. I will give you a rough idea of what I'm looking for, but I'm open to suggestions and iterations. If you're passionate about interior design, proficient in Sketchup, and hav...
I require a 3D diagram based on a structural floor plan for a metal work project. This diagram will be used for construction planning, so it needs to be detailed and accurate, reflecting the specific requirements outlined in the provided drawing. Key requirements include: - 3D visualization of the structural layout - Conversion of the floor plan to a 3D model - Inclusion of basic labels and dimensions The final output is expected in SKP format, for easy integration with our existing systems. Ideal candidates for this project should have experience in: - 3D modeling, specifically for construction planning - Proficiency with SketchUp - Ability to translate 2D drawings to 3D models with accuracy - Familiarity with metal work projects would be an advantage. Your role in this proj...
I'm looking for an experienced front end developer to make some adaptations and fix some bugs on my WordPress site. Key Requirements: - Extensive experience w...WordPress site. Key Requirements: - Extensive experience with WordPress and PHP - Proficient in adapting websites to plugins - Skilled in diagnosing and fixing Front end bugs like layout issues, responsive design problems, and CSS styles(Need to fix issue with content formatting in blog) - Prior experience with MeawApps AI Engine Plugin (the main issue is the chatbot is visible on WP website with basic Theme, but with my installed chatbot is not visible at all) For your application, please focus on your relevant experience. I'm looking for a professional who can swiftly implement these changes with minimal dis...
I am seeking a skilled YouTube video editor with strong basic editing capabilities and specific knowledge in audio editing. I want the videos will exactly like this sample: and also thumbnails along with videos there is 7 video in week and please let me know about your charge for every video Please mention your every video fees in your proposal. please send me your artworks for youtube video or audio visualizer
...Responsibilities: - Translate my ideas into visually appealing and humorous designs for T-shirts - Create innovative and quirky designs with an insider IT perspective - Collaborate with me to ensure that the designs appeal to our target audience and align with our brand image Experience & Skills: - Proven experience in graphic design and expertise on design software and technologies. (Only Basic understanding of IT) - Strong aesthetic skills with the ability to combine various colors, fonts, and layouts - Understanding of the IT industry, its jargon, and unique humor will be a plus - Ability to take constructive feedback and turn it into a better design - Excellent communication skills are a must. This is an exciting opportunity to leverage your design expertise for a fu...
I am in search of a talented 3D animator who can bring my manufacturing machine to life in a technical, yet simplified, animation. Your task will be to create a low-detail model, focusing on basic shapes and forms, rather than getting caught up in the nuts and bolts. Experience in a similar field will be seen favorably. Key responsibilities and required skills include: - Creating and animating a 3D model of a manufacturing machine - Maintaining technical authenticity in the animation - Accuracy in representing basic shapes and forms - Proficiency in 3D animation programs - Effective communication skills While a comprehensive understanding of manufacturing machines is not necessary, an illustrative comprehension of mechanical elements would be highly beneficial. Let's b...
I need a quick and concise service review. The task is simple and should only take five minutes of your time. Key Requirements: - The review should be focused on the service specifically, without the need for comparing it against similar services. - I am looking for a moderate level of detail. While I don't need an in-depth analysis, I do want more than just a basic overview. Ideal Skills and Experience: - Experience in writing reviews, particularly service reviews. - Ability to provide a succinct yet informative assessment. - Attention to detail and the ability to adhere to a brief. Your review will be invaluable for me, helping me to gauge the quality of the service.
I need help with typing up PDF files. The finished documents should be delivered as PDF files. The project involves: - Typing content from PDF files into a new document - Ensuring the typed content maintains proper structure and spelling - Basic formatting to make sure the text is readable and well-organized Skills and experience needed: - Proficient in typing and data entry - Familiarity with PDFs and basic formatting - Attention to detail to ensure accurate transcription - Ability to deliver the final documents in PDF format.
I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can help me streamline my data management processes and turn this data into comprehensib...
I'm looking for a skilled Excel professional to help me create a custom inventory dashboard. Key Requirements: - The dashboard should focus on inventory management, specifically, visualizing product stock levels. - The data should be arranged in an intuitive manner that allows for quick and easy inventory tracking. Ideal Skills & Experience: - Strong proficiency in Excel, particularly in creating visually appealing and user-friendly dashboards. - Experience in inventory management, with an understanding of product stock levels and their relevance. - Attention to detail as accuracy in data representation is crucial for this project. - Good communication skills and a proactive attitude to ensure the project's success. Please note that due to the nature of this...
I'm in need of a proficient Excel expert who has a solid understanding of Excel macros and compatibility issues with Excel for Mac 2018 or later. The project involves assessing and modifying an existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior experience with Excel for Mac compatibility issues - Strong un...
I'm in need of an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projected in one place as a dashboard.
I'm looking for a skilled Excel professional to clean a text-based dataset for me. The dataset is not massive, but it's quite messy. The data cleaning task is relatively straightforward and basic. You'll have to perform operations such as removing duplicates and adjusting formats. Ideal Skills and Experience: - Proficiency in Excel: You should be comfortable working with large datasets in Excel, including applying formulas and functions. - Data Cleaning Expertise: Prior experience in cleaning text data is a major plus. - Attention to Detail: The devil is in the details; I need someone who won't overlook small nuances in the data set. Once the data is cleaned, I'll need you to carry out some basic analysis on it. This will inv...
I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Excel skills in a practical, real-world setting.
Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.
Develop macro-enabled Excel file to handle CSV
I'm in need of a professional who can convert a PDF document to Excel format. The PDF contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience in converting PDF documents with mixed content to Excel while maintaining layout integr...
...streaming on Kwai. The streams are to be public and will primarily focus on entertainment content. Live content: casual games. During the live broadcast, introduce the game you are playing to the audience. Live broadcast platform: Kwai platform Live time: Live broadcast time: 7:00-10:00 in the evening local time in Brazil, two hours of continuous broadcast every day. Rest: 4 days off a month. Basic requirements： computer equipment and Internet in Portuguese (and preferably in English) and cheerful the face live Job salary: Fixed part: 2 hours of live broadcast every day, 10 US dollars per hour. If you are willing to broadcast for a third hour, the hourly wage for the third hour is $5. Commission part: During the live broadcast, you will get a commission
I need assistance in copying text content from my smartphone and pasting it into the appropriate place. Key Requirements: - Copying text from my smartphone- The ...essential. - Paste into the appropriate location- The text will need to be pasted into the correct place, whether it be a website, document, or elsewhere. Time Expectation: - I am looking for someone who can assist me part-time. This means the job doesn't need to be completed all at once. A longer-term arrangement is possible if the collaboration is successful. Ideal Skills: - Understanding of basic phone functions - Strong attention to detail - Ability to follow instructions accurately If you are interested, please provide a brief overview of your relevant experience as well as a summary of how you would appr...
...extracted table is ready for analysis. Please note that no additional data preprocessing is required, just fixing the current code. --- name "iXBRL" , inside folder contain multiple html file(hundreds to thousands), each html file contain multiple tables(vary from 15-35, depend on each html file). Python to extract specific table and vertically stack them together to create an Excel file.(first column add html filename.) inside html file is encoded in chinese, so must use chinese to view it. table name/string partially e.g. "現金流量表" or "被投資公司名稱" or "資金貸與他人"or "轉投資大陸地區" or other name(later can be change). extract table based on table names/string. the table may not be there(depend on the html). If so just skip or single row ...
...field. - Strong communication and interpersonal skills, with the ability to build rapport and engage with International clients. - Excellent research skills, with the ability to efficiently gather and analyze information from various sources. - Self-motivated and proactive, with the ability to work independently and as part of a team. - Testimonial and past work screenshots and client feedbacks - Basic understanding of social media platforms and digital marketing concepts is a plus. - *Benefits:* - Hands-on experience in lead generation and digital marketing within a dynamic agency environment. - Mentorship and guidance from experienced professionals in the field. - Opportunity to contribute to real client projects and campaigns. - A % commission on each closed client - Potent...
If you have a creative mindset, a strong understand of social media platforms and a drive to excel in the fast-paced world of digital marketing, we want to to hear from you. Joint us and take your carrer to the next level. A business owner seeking to boost online visibility, I need an experienced digital marketer whose key focus lies in social media marketing. Although the user preferences for specific platforms weren't provided, proficiency in all the common platforms such as Facebook, Instagram, and Twitter is highly beneficial. My business caters to both B2B and B2C markets, so it's crucial that you know how to effectively tailor campaigns for these distinctive audiences. Desired skills and experience: - This is performance based project - Must communication skills...
Ho bisogno di un programma che mi permetta di aggiornare disponibilità e prezzo di vendita dei prodotti presenti nello store shopify partendo da un file excel/csv che viene generato automaticamente ogni x ore e viene esportato dal getionale su cartella FTP
I am looking for an architect to design my house starting from very basic, I have only the dimension of my plot (I have drawn a very rough sketch of my plot and attached it below). Now you have to design complete house starting from zero. I need complete design of my house, starting from zero. First of all I need floor plans for both floors (Sizes of bed rooms, washrooms, kitchen, drawing room etc everything), then I need 3D rendering of all including front elevation, at the end I need a complete 3D video of complete house design. (There must be a proper ventilation system in complete house including all rooms, baths, kitchen etc). My plot size is 1750 Square feet Dimensions are 35*50. its a corner plot. ---->>> Requirements for ground floor: 2 bed rooms with attached ...
I have a project that requires purely text data entry. I have a set of handwritten notes which need to be entered into a spreadsheet. Key Requirements: - The data is text-based, and it's crucial that the freelancer can transcribe this accurately and efficiently. - Proficiency in using spreadsheet software like Excel or Google Sheets is a must. Ideal Skills: - Fast and accurate typing skills - Proficient in using spreadsheet software - Experience with data entry, especially from handwritten sources
Music Video Production Pre Production: Location scouting Production: 2x Locations Post Production: Basic edits with music. Price : US$2000 Payment milestones $500 to be paid as a token for confirmation. $750 to be paid on the shoot day. $750 to be paid upon confirming final draft. Please note, final video without watermark will be uploaded only upon receiving full payment.
We're seeking a detail-...across France. • Utilize various online resources, including: o Search engines (Google, Bing, etc.) o Social media platforms (Facebook, Instagram, LinkedIn) o Industry directories and publications (list specific resources if known) o Business databases (mention specific databases if known) • Gather and verify contact information (name, email, phone number) for each lead. • Compile lead data into a Excel format . Qualifications: • French reading and understanding - ONLY • Excellent research and data collection skills. • Proficiency in using online search tools and social media platforms. • Strong attention to detail and accuracy. • Ability to work independently and manage time effectively. • Familiarity with...
I need an Excel tool that can sort data by category and provide users with an interactive experience. I'm looking for an experienced Excel developer who can create a user-friendly, yet advanced, Excel tool. The tool should have the following features: - **Filtering**: The tool should allow users to filter data by category. This is a crucial aspect of the tool's functionality, as the data will be organized by this field. - **Interactive Buttons**: I would like the tool to have buttons that allow users to sort data. When a button is clicked, the data should rearrange itself based on the selected category. For example, when a user clicks on the button related to 'Category A', all data entries related to 'Category A' should be displayed. -...
From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.
I'm in search of a proficient writer with a strong grasp of mass transfer operations, specifically in the context of humidity measurements and cooling towers. The reports I need should cover both these subjects and offer an overview with basic principles. Key Responsibilities: - Crafting comprehensive reports on humidity measurements and cooling towers - Ensuring that the content is structured, informative, and provides an overview of the topics - Incorporating fundamental principles of mass transfer operations in the reports Ideal Skills & Experience: - Proven experience in mass transfer operations, distillation, absorption, and extraction - Strong research skills and the ability to present complex concepts in a clear and concise manner - Previous work on humidity measur...
I'm seeking a freelance professional to handle computer-related tasks including data entry, spreadsheet creation, word processing and software applications assistance. Requirements: - Proficiency in Windows, MacOS, or Linux operating systems - Experience with various software applications, including Microsoft Office, Adobe Creative Suite, and OpenOffice/LibreOffice - Ability to handle tasks in a timely manner This project is ideal for someone with a strong computer background and excellent attention to detail. Please apply if you meet these qualifications.
I am looking for a qualified videographer to assist in creatin...video is to provide an overview of our academy, highlighting our features, facilities, and achievements. - Videography: I would specifically like the use of drone footage to ensure a comprehensive capture of the academy. - Creativity: The video should creatively convey our academy’s vision and offerings. - Skills and Tools: Applicants must have experience with drone videography. - Knowledge: A basic understanding of sports and facilities is desirable. Prospective candidates should have a compelling portfolio of similar promo videos, ideally showcasing wide-scale locations such as sports academies or campuses. The freelancers' creativity in using drone footage to highlight key features will be a key compo...
...calendar, setting up meetings, and handling basic bookkeeping. - Conducting Research: I need someone who can gather information for me on topics that I provide. - Assisting with Customer Support: You will need to handle customer inquiries and provide basic support. Communication is key for this role, so I need someone who is comfortable with various communication channels. I expect you to be responsive to emails, phone calls, and instant messages. Ideal Skills and Experience: - Proven experience as a virtual assistant or in a relevant role - Excellent organizational and time management skills - Strong communication skills, both written and verbal - Proficient in using Microsoft Office and Google Suite - Ability to handle customer inquiries and provide basic suppor...
I'm looking for a professional who can help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple format for my tables, in line with a minimalist style. Ideal Freelancer: - Proficient in Excel, with a deep understanding of formula creation. - Experienced in table formatting and design, with a flair for minimalism. - Able to deliver high-quality, error-free work in a timely manner.
