Complex excel vba 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.
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 looking for a skilled professional to help with organizing my personal finances for the past year. Key Requirement...Spreadsheet records for data classification Additional Details: - I'm interested in obtaining both monthly summaries and a comprehensive yearly report summarizing my financial activities for the past year. Ideal Skillset: - Proficiency in financial analysis and classification - Experience in personal finance management - Ability to work with large data sets - Strong spreadsheet skills, particularly in Excel - Ability to provide detailed and organized reports I'm aiming for a freelancer who can provide me with a clear and insightful overview of my spending and income patterns over the past year, and who can deliver this information in a timely...
I'm in need of a skilled developer to create a web-based accounting app mimicking functionalities of excel for my business. Key Features: - Accounting functionality: This app must allow me to insert product details and their price, record the amount they were sold for, and at each day's end, it must generate a profit and loss table. - Inventory tracking: The application should effectively manage my inventory, keeping a track of products, their quantities, and changes over time. - Customer Database: The app should store customer information in an organized and easily accessible manner. - Invoice Generation: It should also have the capability to generate invoices for customers. Design Aesthetics: The preferred design is minimalistic. It must be clean, clear and user-frien...
... advanced level PowerPoint course material on value management. - Ensure the content is engaging and provides practical, applicable tips and techniques. Ideal Skills: - Strong understanding and experience in value management. - Proficiency in creating engaging and informative PowerPoint presentations. - Familiarity with providing advanced level content. - Good communication skills to distill complex concepts into easily understandable tips. The government entity receiving the training operates in the GCC region in environmental management but delegates may also be coming from other non-environmental focus areas. The material you would develop should be able to cover teaching for two days (7 hours per day) with activities for the 15 delegates. All references should be added wit...
I'm in need of a skilled professional to create a comprehensive taxi booking application for iOS, Android, and Web (browser-based) platforms. The application should feature GPS Tracking, Payment integration, and Rating/Reviews. Furthermore, the application sho...Driver Tracking: This feature is essential for ensuring the safety and security of our customers. It allows our users to track the driver's location in real-time, giving them peace of mind during their journey. Ideal candidates for this project should have a proven track record of developing similar applications, be familiar with GPS Tracking, Payment Integration Systems, and be able to integrate complex algorithms for Ride Sharing and Fare Estimation. Your creativity in designing a user-friendly interface will be...
I'm seeking a skilled professional to develop a Solidworks macro for specific tasks. Mainly, it's intended to import data from Excel to Solidworks, and automate several repetitive processes. Data to be incorporated from Excel will be primarily: - Dimensions and measurements - Material properties - Configuration properties part number convention The successful candidate should have prior experience working with Solidworks and Excel VBA, understanding how to adeptly make these two platforms talk to each other in an efficient and error-free manner. This project is required within a month. If you're able to work within this timeframe, and have the necessary skills, I would love to hear from you. I have an Excel sheet to automate PN a...
I'm looking for a professional who can help me present detailed nutritional values of foods in a visually appealing and easy-to-understand format, specifically through the use of cha...is accessible and clear to individuals in the fitness community - Familiarity with the needs and interests of fitness enthusiasts would be a distinct advantage Ideal skills for this project include: - Proficiency in nutrition, with a focus on fitness and sports nutrition - Data visualization expertise, particularly in the context of food and nutrition - Strong communication skills to translate complex information into an easily digestible format - Prior experience in creating content for fitness audiences. Please provide examples of your previous work that demonstrate your ability to meet thes...
I'm currently looking for a skilled and experienced developer for backend CMS development. Key responsibilities: - Develop a Content Management System using PHP, Laravel, MySQL, and Python. - Design, implement and maintain pyth...Management System using PHP, Laravel, MySQL, and Python. - Design, implement and maintain python-based backend application. Essential Skills: - Proficient in PHP, Laravel, MySQL, Python. - Extensive experience in backend development. - Knowledge in CMS development and implementation. - Strong understanding of data structures and algorithms. Your analysis skills will also be put to good use to solve complex problems in this role. As an experienced backend CMS developer, you can expect to work closely with me to deliver a robust, performant, and s...
I'm in need of a seasoned WordPress developer to create an extensive business website for me. The site will have at least 15 pages, and should include several special features...that visitors can use to reach out to us, helping to streamline our communication with potential customers. - Appointment Booking: An embedded system that allows users to schedule appointments or consultations online. - Membership Registration: A feature that lets users sign up for member-exclusive content or benefits. For this project, I'd prefer someone with demonstrable experience in creating complex WordPress sites and integrating these specific functionalities. Your portfolio should showcase similar projects. Excellent communication skills and the ability to offer insights for improvement are...
As a shareholder, I need to voice opposition against three motions seeking a takeover of an 'abandoned' Over-The-Counter (OTC) company. - As a first step, we've sought legal counsel to contest the takeover. It's crucial to partner with someone who understands navigating complex legalities surrounding company acquisitions. - We hold a significant number of shares and votes to counter all the prevailing motions. I'd love to collaborate with an experienced professional who could help guide the voting strategy and ensure we maximize our chances of success. Skills and Expertise: - Expertise in company mergers and acquisitions - Knowledge of legal issues around company takeovers - Experience in board meetings and shareholder voting.
I'm seeking a professional with exceptional data management and customer after-sales support skills. The selected candidate will be expected to perform the following... Data Entry Tasks: - Data cleaning and organization. - Creating and managing spreadsheets. - Conducting data verification and quality control on all data sets. After-Sales Support: - Managing product troubleshooting. - Overseeing and tracking customer orders. - Handling customer returns and exchanges. Tools Utilized: - Excel for data handling. - Communication via WhatsApp and Facebook for customer support services. The ideal candidate should be proficient in Excel and comfortable using social media platforms such as WhatsApp and Facebook. Previous experience in data entry and customer support roles a...
I'm a beginner in corporate finance and I'm looking for a skilled and patient tutor who can help me understand various concepts and topics in the field. Key Responsibilities: - Assist in understanding and analyzing financial statements - Teach the basics of capital budgeting and its methodologies - Explain and sim...Assist in understanding and analyzing financial statements - Teach the basics of capital budgeting and its methodologies - Explain and simplify risk management concepts Ideal Candidate: - Skilled in corporate finance with a strong grasp of financial statements, capital budgeting, and risk management - Experienced in tutoring or teaching, especially with beginners - Patient, good at explaining complex concepts in a simple way - Comfortable with online tutoring...
I need to upgrade my existing Google Chrome extension from manifest v2 to manifest v3. - The current extension is running on Google Chrome. - The main goal of the upgrade is to enhance the extension's performance. Ideal Candidate: - Profici...system where you can install Node.js, npm, and any other tools needed for continuing React development. All development, including future updates, will take place on this server. I want to ensure I can run "npm run build" without any errors because sometimes I may want to add or edit links, fix ISO codes, etc... small stuff on the Chrome extension myself and build the production version. For more complex tasks, you will continue development on this same server. This way, I can create an image and easily deploy it whenever futu...
...reliable network. 3. Configuration: Implement VLANs and IP address segmentation for network efficiency and security. Additional Recommendations: - Design the network using Packet Tracer and ensure it meets all requirements. - Consider real-world scenarios and solutions to demonstrate your capability to provide the best service. - Explore additional details online to enhance your configuration for complex networks if desired. The design will be based on the complexity and optimal networking service provided....
I am in need of a talented graphic designer who can create a minimalistic, modern graphic to explain the functionality of our product to business executives. Key Requirements: - The graphic should be minimalistic and modern in style, focusing on clarity and simplicity. -...explanations - Strong understanding of business communication and the ability to create designs that resonate with business executives - Exceptional proficiency in graphic design tools and software - Prior experience in designing graphics for a non-technical audience would be a plus If you have a keen eye for design, a good understanding of product functionality, and have the ability to distill complex concepts into simple graphics, I'd love to hear from you. Please provide samples of similar work you'...
I'm in need of a professional who can handle CAD data files specifically from software like Geomagic, NX, etc. The task at hand is moderate to minor retouching focusing on: - Correcting missing or overlapping geometry - Fixing misaligned surfaces The ideal freelancer must be adept in precise alteration work without changing the overall structure of the model. The ability to understand complex geometries is key and should have proficient knowledge in Geomagic and NX software for effective results. The project demands a meticulous eye for detail and superior CAD software skills.
I have multiple Excel spreadsheets containing contact information, and I need them consolidated based on a unique index number. The task involves the following: - Data consolidation: Retrieve name and email information from several Excel sheets using a base index number from a primary data file. - Automation: I need this consolidation to be automated instead of manual intervention. - Performance Optimization: Currently using Xlookup for the merging process, but it's slow due to the file size. I'm open to suggestions for more efficient alternatives. Skills and Experience: - Advanced Excel skills: The freelancer should be proficient in Excel and have experience working with large data sets. - VBA Scripting: Ability to write and implement V...
...could be causing a conflict that halts the loading process. - *Api calling*: The API calling function might not be working correctly on Safari. **The Ideal Candidate:** - **Strong React JS Experience:** You should be well-versed in React JS and its compatibility with different browsers, especially Safari for iOS. - **Debugging Expertise:** Proficiency in debugging and identifying issues within complex web applications. - **Experience with Third-Party Plugins:** A good understanding of how to deal with third-party plugins and their potential conflicts. - **Knowledge of API Integration:** Capable of troubleshooting issues related to API calls. Your role will be to consult with me and potentially provide guidance on resolving the issue. Your expertise in React JS and iOS browser...
We are currently looking to add several Virtual Assistants (VA) to our team who can assist us with various tasks, including social media posts, research, data entry, and more. We are seeking individuals with a strong background in data entry, Google Drive/Sheets, and similar responsibilities, as outlined in our LinkedIn ...Key qualifications and requirements for the role: - Proficient in data entry and experienced with Google Drive/Sheets. - Demonstrated reliability and consistency in previous roles or projects. - Strong attention to detail and organizational skills. - Ability to meet deadlines and perform consistently in an ongoing work environment. If you believe you possess the necessary skills and qualities to excel as a Virtual Assistant with our company, we would love to hear...
I am urgently in search of a skilled and very affordable divorce lawye in Michigan USA r, preferably with international experience. The nature of my case is fairly complex as it involves dealing with international matters, which is why it's crucial that the professional has a deep understanding and practical knowledge of international legal procedures. Key Requirements: - Expertise in international divorce laws - Proven experience in drafting divorce agreements - Strong capability to represent clients in court - Ability to start on the project ASAP. Your prompt response would be highly appreciated as I am looking for immediate assistance. Please, also indicate your previous experience handling similar cases.
I'm looking for an experienced data analyst to conduct a network meta-analysis on the effectiveness of pain management techniques within orthopaedics. Requirements: - Extensive experience with meta-analysis and statistical methodologies - Background in medical research, ideally within orthopedics - Ability to interpret complex data and present findings clearly Task will include: - Comprehensive study of existing research and data - Comparing differing pain management techniques - Identifying and addressing any potential knowledge gaps Your final deliverable should clearly indicate which pain management techniques yield the most effective results within orthopedics.
I need an article that focuses on Cyber Security interview questions aimed at Hiring Managers. The article should have a balance of timeless principles and current trends in Cyber Security. The ideal candidate should: - Understand the specific requirements of Hiring Managers - Be knowledgeable in Cyber Security principles and trends - Hav...Security interview questions aimed at Hiring Managers. The article should have a balance of timeless principles and current trends in Cyber Security. The ideal candidate should: - Understand the specific requirements of Hiring Managers - Be knowledgeable in Cyber Security principles and trends - Have experience in writing educational content, preferably in the IT field - Be able to simplify complex concepts into an understandable format for...
As discussed I have delivered the excel workbook. Thanks!
...the password for an Excel Workbook. It was prepared by an employee who has since left the firm. Note that I am not seeking to have someone recreate this Workbook without the password, but to have the password itself. There are several videos on YouTube about this, but I've had no luck: I've attached the spreadsheet if you want to try. The first person to provide the password will get paid. Just let me know if have it, I'll hire you, and you supply it. PLEASE DO NOT ACCEPT THE PROJECT UNLESS YOU HAVE THE PASSWORD FROM THE ATTACHED SHEET. Key Project Requirements: - Password Recovery: The primary task is to recover the password for an Excel Workbook. Ideal Skills and Experience: - Expertise in Excel Password Recovery - Flexibility
I'm in need of a professional who can build a tool that can extract data from LinkedIn. The data I'm interested in includes: - Contact information (email address, phone number, etc.) - Profile information (name, job title, etc.) - Connection network (connections, mutual connections, etc.) I'd like the extracted data to be conveniently structured in a CSV (Excel spreadsheet) format. The primary use of the extracted LinkedIn data will be for lead generation. The ideal candidate for this project should have: - Expertise in web scraping and data mining, particularly with LinkedIn - Proficiency in data handling and structural organization - Proven experience with developing tools for lead generation - Strong communication skills and a good understanding of client nee...
I'm in search of a PHP Developer with a proven track record of developing comprehensive ERP Solutions for the con...tracking resources. Specific Requirements for Cost Estimation: - Integrated Cost Database: The system should have a vast and well-organized cost database. - Calculation Formulas: It should accommodate complex estimation formulas. - Reporting and Analytics: The ability to generate detailed reports and analytics is crucial. Ideal Candidate: - Should have a strong background in PHP development. - Extensive experience in developing ERP solutions, particularly for construction. - Knowledge of project management and cost estimation methodologies. - Ability to think critically and solve complex problems. - Good communication skills and ability to work in a coll...
...include: - Data analysis and visualization: I require someone who can understand the dataset thoroughly and present insights in a visually appealing manner. - Formulas and functions calculations: You should be able to create complex formulas and functions to derive the necessary insights from the data. Ideal candidates should possess the following skills and experience: - Proven track record in data analysis and visualization using Google Sheets. - Strong expertise in working with large datasets (1000+ rows) within Google Sheets. - Proficiency in creating and implementing complex formulas and functions within Google Sheets for accurate analysis. - Excellent understanding of data analysis techniques and best practices. Please note, though this is a one-time analysis, the...
I'm looking for a versatile Excel professional. Key Requirements: - Restrict Sheet Access and Hide for specific users - Changes made in the master sheet should be automatically displayed on specific sheet. - When a change is made on the master sheet, the cell should automatically be highlighted in red color. and also reflected in the specific sheet. I am looking for a good english professional . Automatic bidders will be blocked . If you are here type in salut at your beggining of the bid.
Looking for an experienced graphic designer with a knack for transforming emotional narratives into compelling streetwear designs. The project requires a vibrantly colored, graffiti-inspired design centered around the painful story of ...Aspects: - Use bright and lively colors for the design - Incorporate imagery that effectively portrays a mother taking her child back from the streets with design cues that suggest the gritty reality of street life. Skills & Experience: - Expertise in creating graffiti-inspired designs - Strong understanding of color work in design, particularly vibrant palettes. - Proven ability to communicate complex narratives through visuals. I need a designer who can inject emotion and story into their work, creating more than just a design - a piece of...
Tengo un software de facturación al que se le pueden importar facturas en lote subiendo un Excel con un formato concreto de filas y columnas para que sea capaz de reconocerlo y generar las facturas de forma correcta. Necesito poder hacer esto de forma automática, es decir, teniendo un archivo de origen xls en un formato, poder extraer los datos para montar otro archivo xls con el formato que necesita el software de facturación para leerlo correctamente.
I'm looking for an experienced WordPress developer, who can provide a comprehensive training for our de...of the training: - Explanation of WordPress architecture and functionality - Hands-on sessions covering Theme and Plugin development - Insights into customization and optimization best practices - Additional tips and tricks for effective WordPress development Ideal candidates should have: - Extensive and proven experience in WordPress development - Strong teaching skills and ability to explain complex concepts in simple terms - Patience to work with a beginner and explain from the ground up - Ability to provide practical examples and assignments - Good communication skills and professional attitude. Your role will be crucial in shaping our developer's skills and conf...
We are an Ecommerce company dealing with variety products and we are looking for a...Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain Write text for the posts Edit Pictures and videos in Canva or Capcut The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications and sales skills Can work on Excel Have sufficient experience in Social Media Ads and ...
Data entry work from home part Tim e
I'm in need of a talented graphic designer to create a captivating motion graphic animation that will serve as educational content. Key Points: - The primary goal of this project is to create a visually appealing piece that conveys complex information in a simple and engaging manner. - The animation should be specifically designed for educational purposes, meaning that clarity and ease of understanding are top priorities. Ideal Skills: - Proficiency in motion graphics and specifically, designing motion graphic animations. - A strong understanding of educational content design - ensuring that information is not only presented visually but also aids in comprehension. - Ability to create visually appealing and engaging animations that can hold the attention of the viewer. - Ex...
...Falls. I'm looking for an experienced scriptwriter to write a script for a hypothetical Season 3 and 4. Key Details: - Tone: I want the new seasons to maintain the mysterious vibe that the show is known for. I'm not looking for a complete tone shift. - Audience: The script should be tailored towards a teenage audience. It should be sophisticated enough to keep older viewers engaged, but not too complex for its target demographic. - Characters: While I'd like to introduce some new characters, they should be minor. The focus should be on the existing characters, their development, and the continued exploration of the show's existing mysteries. Skills & Experience: - Proven experience in scriptwriting, particularly for mystery or teen-focused content. - A ...
I'm seeking a proficient professional who can handle our company's local and national government tender submissions. Key Responsibilities: - Filling out application forms: You'll be responsible for ensuring all necessary fields are accurately and completely filled. - Preparing...paperwork in a clear and concise manner. Industry Specifics: - The tenders primarily relate to the paint industry, so any prior experience in this sector would be a significant advantage. Ideal Qualifications: - Background in tender filling, particularly in the public sector. - Strong understanding of the paint industry would be highly beneficial. - Detail-oriented and capable of working with complex documentation. Please get in touch if you believe you have the required expertise and ...
...references marked in the article from trusted office furniture sources such as Office Furniture Inc or Madison Liquidators - Article length 1200 to 1500 words - Optimize SEO by utilizing the top keywords for the subject matter. The ideal writer for this project will have: - Excellent research skills to gather and present information in an engaging manner. - Strong writing ability that can simplify complex concepts for a general audience. - A keen understanding of the factors that make different computer desks appealing to different users. - The ability to present this information clearly and concisely. The target audience for this article is general, meaning it should be written in a way that is accessible to a wide range of readers. A balance of informative content and readabi...
...and data visualization services. • The illustration will require graphical presentations, that can add to the depth of our discussions, keeping the discussions engaging and insightful. Therefore, proficiency in creating effective graphical presentations is paramount. • For data visualization, we are primarily looking into audience demographics. This would mean processing and understanding complex demographic data and presenting it in a visually engaging and clear manner. This aspect of the job demands experience in data analysis and a keen eye for aesthetics. The ideal candidate would be a full-stack designer, who is well-versed in both illustrative art and data representation. To succeed, keen attention to detail, creativity in graphical presentations, and profic...
You need to build a power app for a business process of onboarding, offboarding customers. There is a data...customers. There is a database of the customers with specific users db that has access and approve a checklist. We need it on a sharepoint portal and emails are automated for every action. It is a simple process of adding a user, give them a checklist, customer completes all actions, there is an internal admin who confirms the checklist and there is a progress to track. Will provide a dummy of excel sheet, expect 3-5 screens across onboarding, offboarding, admin and customer login. Ideal Skills: - Proficiency in Power Apps, Microsoft Power Automate. - Expereince in MS dataverse, power platform - Ability to grasp business processes and convert them into efficient digital ...
I'm seeking an expert in Excel macros with an advanced understanding of VBA to accomplish several tasks for my project: - Automate data entry processes. - Generate comprehensive reports. - Perform complex calculations. Key skills you should have: - An advanced understanding and experience of Microsoft Excel. - Proficiency in developing and implementing Excel Macros. - Advanced VBA coding skills. To be considered for this project, please include the following in your application: - Detailed project proposals, illustrating how you plan to achieve the tasks outlined above. Please note, this project is demanding and requires a high level of familiarity with Excel and VBA to be executed efficiently and effectively.
