Vba report automation 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ä. MUTTA, j...
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.
I need an automation program that can handle my textual data entry and processing tasks.
... what they can do is just view NSC module, use the search, filter, or print(if available) features, also, please instruct us how to create this specific users. - Co-ordinator in project/Task can also edit the project/task/so/sales/quotation / purchase order and all custom modules we created - Additional five Project list reports, just use the existing one and change the fields, add one combine report and one button or dropdown list then generate that. - Task, one click to update or add, create buttons in the task, then each button can copy the certain fields data from project to the certain fields in task? For example, click button one can copy project name and dates fields to task project name and dates, click button two can copy ETA and ETD from project to task ETA and ETD, cli...
I am looking for an expert in Doorbird system to help maximize the efficiency of my home unit, focusing specifically on:...Access control: - Enable the system to control multiple doors and garage openers - Allow to lock/unlock remotely - Add a keypad entry system for a streamlined user experience. Automation: - Automize processes where possible for ease of use Ideal Skills: - Extensive knowledge in Doorbird systems - Experience in automating security systems - Expertise in integrating varying access control systems, particularly with keypad entry systems and magnetic locks Your will help me document the current setup, explore technologies and products to purchase, make a plan incl. wire diagrams. Proven experience with home automation (doorbird a1018, doorbird D2101)...
We are looking to develop a web-based application using Zoho Creator that allows users to scan QR codes of individual products and barcodes of outer cartons for inventory management purposes. The application will generate reports based on the scanned data, providing insights into the frequency of scans for each unique QR code. Sure, here's a detailed project requirement draft for you...the frequency of scans for each QR code. 4. Reporting: - The application will generate reports that display: - Total count of scans for each unique QR code. - Frequency of scans for each unique QR code over a specified time period. - Summary statistics such as average scan frequency, highest scanned QR codes, etc. Any other app apart from zoho creator also can be done. Need repo...
I am in need of expertise for transforming a 40-page draft report into a sleek and modern Word template. Task should be completed by Sunday night. Key details include: - Providing a clean, minimalist design for a professional finish. - Incorporating images and logos which I will supply. - Employing specific fonts that we plan to provide. Ideal freelancers will have a keen eye for modern and minimalist design, especially in formal reports. Express proficiency in working with Microsoft Word and ability to meet strict deadline is essential. Previous experience in similar projects is highly appreciated.
I'm seeking an adept developer for designing an automation focused Telegram bot. The main purpose of this bot is task automation, and primarily, it should be equipped with the functionality of responding to user inquiries. Key requirements and tasks include: - Construction of bot with the ability to automate responses to user inquiries. - Integration of a reliable system for the bot to search through a database for pertinent answers. The ideal freelancer would possess the following skills and experience: - Strong expertise in creating task automation bots for Telegram. - A sound understanding of databases and utilising them effectively to deliver appropriate responses to inquiries. - Ability to deliver an efficient, responsive and accurate bot. Your practical ...
I'm in need of someone skilled in PDF file structures who can determine if a particular PDF has undergone editing, and to identify the edited segments. To help successfully complete this task, you should: - Have in-depth experience navigating the structure of PDF files. - Capably discern changes or alterations made to a PDF. - Provide a report indicating any modifications, where they occurred. When applying, please exclusively focus on detailing your experience with manipulating PDF file structures. Past projects involving this will be highly advantageous. Ideally, you will have worked on similar projects, where the goal was to detect alterations in the document. Looking forward to a seamless collaboration.
I am looking to embark on a project that requires expertise in telecommunications, specifically in designing point to point communication systems like simplex, duplex, using radio as the communication type. To see this project to its fruition, I will need a professional who can design a communication link with various parameters. Thereafter, we'll need to carry out Link-le...efficiency - Implementation complexity - Implications on system design For the duplex system, the metrics for evaluation would be: - Error performance - Power efficiency - Bandwidth efficiency Your role in this project will not only involve the design and simulations but also an analysis of the obtained results. Frames your bid with these factors in mind. Deliverables will be MATLAB files, a report and ...
I need to connect ElevenLabs' text-to-speech API to another tool through Zapier. So far, Elevenlabs' response has been a binary. Instead, I need the audio URL so that the second app I want to connect with Elevenlabs can use the URL in an automation. To participate in this project, you'll need to create your own free accounts for both services. The participant will need to deliver a complete solution that, if possible, doesn't involve hosting the content in a third-party service. To participate, please start your message with "Bonjour". This way, I'll know you've read this instructions. If you need clarification, pleaset let me know.
...challenges in my operations. This advanced technology will aid in requesting more specific information for document retrieval, task completion, and progress updates that are currently barriers. Key Features and Responsibilities: - Construct an AI system that can precisely request added details - The AI tool should nurutre informations mainly for document retrieval, tasks execution, and progress report. - Should work effectively with email platforms as the primary communication tool. Ideal Experience: - Proven experience in AI and machine learning technology - Familiarity with corporate communication systems - Experience in integrating AI with Email services. This project aims at enhancing efficiency and productivity through clear and effective communication. Please provide exa...
I urgently need a skilled Electronics Engineer who is proficient in working with Cadence Virtuoso. Your tasks will include: - Designing a simple circuit - Capturing the schematic of the circuit - Creating a PCB layout of the circuit - Writing a comprehensive report on the completed tasks Due to the urgency of this project, I would prefer someone who can get started as soon as possible. Ideal Skills: - Expertise in Electronics Engineering - Proficiency in circuit design - Solid experience with schematic capture - Strong skills in PCB layout - Experience in Cadence Virtuoso - Ability to write clear and comprehensive reports I look forward to receiving your bids and working with you on this project.
Looking for an expert in Oracle Integration Cloud to assist with my tasks in application integration and process automation. The integration should compare two files on the FTP, and send an email to the recipients. - In-depth understanding of Oracle Integration Cloud - Strong knowledge in Application integration - Process automation skill set - Ability to advise on best integration strategies
I need a professional freelancer to design an HTML form for my website. This form must have: - Text fields for basic information collection - Dropdown menus for selection options - Capture creation The form should be designed with user-friendly, visually appealing elements. Your role will al...ensure that the user completes all the required fields in the correct format. - Integrating an email script that will automatically send a reply to the submitter. This is an essential feature for my project. Ideal Skills and Experience: - Proficiency in HTML and CSS for form design - Experience in creating and implementing form validation - Knowledge of backend scripting languages for email automation - Understanding of user experience best practices - Experience with automatic email rep...
...project is to simulate a water pipe network and subsequently identify potential leaks using pressure drop analysis. The simulation should be able to model the flow and pressure properties of a complex network of pipes. Key tasks: - Setting up the pipe network simulation using Python - Conducting pressure drop analysis for leak detection - Providing an intermediate level of detail in the analysis report - this should include the locations and estimated sizes of the potential leaks Ideal candidates for this project should have: - Proven experience in Python programming - Understanding of hydraulic systems and pipe networks - Experience with pressure drop analysis - Proficient in creating detailed and informative reports Please note that the primary objective of this project is ...
I'm looking to automate a process in my manufacturing setup. This involves controlling a servo and timer to carry out specific tasks. Key Responsibilities: - Develop a system...servo and timer to carry out specific tasks. Key Responsibilities: - Develop a system that uses a combination of a servo and timer to automate a particular process in my manufacturing facility. - Ensure the system is able to operate efficiently and with high precision. Ideal Skills: - Proven experience in automation projects, particularly in a manufacturing setting. - Proficiency in programming and working with servos and timers. - Strong problem-solving skills to optimize the automation process. Note: I'm unsure about which platform would be the best for this project. I'm open to ...
I need an expert in SQL Server Report Builder 3.0 to help rejuvenate some lab reports. I require some amendments to be made to the current reports I have. Key Tasks: - Altering the way data is presented within the reports - Incorporating new fields to the current reports In the end, I need the same data results but with improved visibility and understanding. Ideal Skills: - Appropriate familiarity with SQL Server Report Builder 3.0 - Strong grasp of data visualization principles - Detail-oriented and precise to ensure report data remains accurate. Individuals that can deliver these changes precisely and quickly are highly preferred.
I'm seeking a skilled HubSpot professional to provide me with training. Although I'm a beginner, I'm eager to get up to speed on Marketing and Sales Hubs. My primary goals for using HubSpot are to enhance our lead generation, customer relationship management, and sales pipeline management. Key Requirements: - Strong experience with HubSpot, specifically Mark...Marketing and Sales Hubs. - Prior training experience, especially with beginners. - Ability to tailor the training to my goals. Your responsibility will be to provide clear, engaging, and actionable instruction to help me utilize Hubspot effectively. You should be patient, good at explaining complex concepts simply, and able to adapt to my pace and learning style. A background in marketing automation and CRM...
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
This is a one day project. I will provide a spead sheet to be formatted in excel. Debits and credits will be separated and sumed that easy 24 months are involved the files email for additional information.
...talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements without disrupting existing functionalities. Key Featu...
I require assistance with building financial reports specifically targeting balance sheets within SAGE Intacct. The perfect freelancer for this project would possess the following skills and experience: - Deep understanding of SAGE Intacct software, - Proficiency in designing fin...require assistance with building financial reports specifically targeting balance sheets within SAGE Intacct. The perfect freelancer for this project would possess the following skills and experience: - Deep understanding of SAGE Intacct software, - Proficiency in designing financial reports, - Solid knowledge in standard balance sheets creation. The final product should be a standard balance sheet report that can integrate seamlessly into my workflow. Individuals with keen attention to detail are highly ...
...for a specific use case. Given the possibilities, requirements from you as a project manager might include: - Comprehensive understanding of AWS services - Experience in deploying AWS infrastructure - Strong analytical and report writing skills Developing an AWS solution without a specific service focus means the freelancer must have a holistic grasp of AWS. They should be able to discern when to use EC2 instances versus AWS Lambda, or when to leverage the storage capabilities of S3, for instance. Finally, the freelancer must be able to succinctly summarize and report on the developed solution, explaining its design, purpose, benefits, and potential areas of improvement. Please note that more detailed information is needed for a comprehensive freelancer proposal. Thi...
***MUST HOLD PE LICENSE IN WISCONSIN, USA*** In this project, I'm looking for a Professional Engineer based in Wisconsin to perform a field evaluation of several luminaires for installation in a home remodel. Key Responsibilities: - Identify changes necessary to make luminaires comply with safety requirements. - Evaluate final version, write a report explaining that they comply with safety requirements, write up any installation instructions for mounting, and apply PE stamp. Necessary Skills and Experience: - Certified Professional Engineer status in Wisconsin. - Understanding of electrical safety standards relating to luminaires. In summary, your task is to assist me in ensuring that the luminaires in question meet the necessary safety criteria in the WI electrical code.
I am looking for an experienced researcher to compile a detailed report on American citizens. The report should be comprehensive, with a particular focus on criminal and fraudulent activities. Key deliverables: - An in-depth analysis of criminal activities within the American populace - A detailed examination of fraud and general misconduct rates The ideal candidate for this job should have: - Proven experience in conducting research and compiling reports on societal issues - A strong understanding of criminal and fraudulent activities - Excellent analytical and writing skills Please note, the focus of this report is on the criminal and fraudulent aspects of American citizens.
I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. ...errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 DayA shifts, 1 HfdayA shift and 2 middle shifts, i want a report table showing me this for all the employees. i also want to be able to edit the fields and tables if required at a later stage. FOR AN EXCEL EXP...
I'm uncertain whether my Windows system already has Python installed. I require assistance to get it up on my system, if it isn't already there. Primarily, I am looking for someone to help configure a Python script that will carry out automatic reservations on a specific website. This role will ideally suite someone with: - Proficiency in Python scripting - Strong understanding of automation using Python - Experience in setting up Python on the Windows platform - Knowledge of web interaction through code, in particular, reservation processes. here is the link to the script and its dependencies. I will need to work with you on zoom live to do this. I have node.js on windows
...for a specific use case. Given the possibilities, requirements from you as a project manager might include: - Comprehensive understanding of AWS services - Experience in deploying AWS infrastructure - Strong analytical and report writing skills Developing an AWS solution without a specific service focus means the freelancer must have a holistic grasp of AWS. They should be able to discern when to use EC2 instances versus AWS Lambda, or when to leverage the storage capabilities of S3, for instance. Finally, the freelancer must be able to succinctly summarize and report on the developed solution, explaining its design, purpose, benefits, and potential areas of improvement. Please note that more detailed information is needed for a comprehensive freelancer proposal. Thi...
We are seeking a motivated and enthusiastic SEO Intern to join our team. This is an excellent opportunity for someone who is passionate ...and eager to gain hands-on experience in search engine optimization. Responsibilities: Assist in keyword research and analysis to identify new opportunities for content optimization Help optimize website content, including writing meta tags, meta descriptions, and optimizing on-page elements Support link building efforts by researching and identifying potential link opportunities Monitor and report on website performance using tools such as Google Analytics and Google Search Console Stay up-to-date with the latest trends and best practices in SEO and digital marketing Collaborate with team members on various SEO initiatives and projects Qualifi...
I'm looking for a skilled software developer to create a Windows application that focuses on generating data reports from a SQL database. Key Requirements: - The application must be compatible with the Windows platform - The main functionality of the application should be the generation of data reports. - The repo...generating data reports from a SQL database. Key Requirements: - The application must be compatible with the Windows platform - The main functionality of the application should be the generation of data reports. - The reports should be sourced from SQL database. Ideal Skills and Experience: - Proficiency in Windows application development - Strong knowledge and experience with SQL database and report generation - Previous experience with data reporting software w...
I'm seeking a Laravel developer w...user inquiries. Hence, you should be well-versed in both Laravel and Dialogflow to achieve this automation efficiently. - You'll need to set up a Dialogflow account and project from scratch as I haven't done this yet. Your experience in Dialogflow will be instrumental in ensuring that the setup is seamless and optimized for my application's needs. Ideal Skills: - Proficiency in Laravel 7 or 8 - Extensive experience in Dialogflow, including setting up accounts and projects - Strong understanding of automation and how DialogFlow can be leveraged to optimize user inquiries I'm looking for a proactive and skilled developer who can efficiently handle this integration and ensure that the automation of responses ...
...personal use. Key Requirements: - This is a personal project, not for a business, and the primary goal is to automate the task of securing a visa appointment. The Bot: - The bot should be able to navigate a visa appointment booking system, select the appropriate options, and secure an appointment on my behalf. Skills and Experience: - Proficiency in bot programming and automation is crucial. - Experience with task automation and appointment booking is a plus. - Understanding of web scraping and navigation is a requirement. - Attention to detail is important to ensure the bot selects the correct options during the appointment booking process. Please get in touch if you have prior experience with building similar bots or automations, particularly in the context of...
I'm seeking a seasoned developer well-versed in C# and Selenium to create a bot to facilitate automation on Facebook Marketplace. The bot that I'm envisioning would need to perform the following tasks: - Can use multiple accounts, log into several accounts to enter automatic Facebook marketplace listings or Facebook group posts, logged in accounts are saved and can be opened without re-entering the password - Autopost Facebook Marketplace Create Product Title, product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to Faceboo...
Excel Automation of my project and data visualization
I'm seeking a statistic analyst with a strong R background to help me analyze a questionnaire survey. The results of the analysis will need to be presented in a written report. I'm looking for a comprehensive breakdown of the data with statistical insights and interpretations. Key Requirements: - Proficient in statistical analysis with R - - Ability to provide a comprehensive breakdown of data - Strong analytical and problem-solving skills - Excellent written communication skills Your analysis will form the basis of a written report, which must include statistical data and insights. It's essential that you can translate complex data into clear, actionable recommendations. If you have experience in presenting data in a visually appealing and easy-to-understa...
I need a Python expert with an ability to cover various functionalities as per the need. The project might involve data analysis, web scraping, automation, or could be anything else as per the project requirements. The ideal candidate should have: - Expertise in Python programming and its different libraries. - Experience with data analysis, web scraping, automation. - Strong problem-solving skills. While applying, please share: - Your past work related to Python programming. - Your Python programming experience level. - Detailed proposal of how you can assist in this project.
We are seeking a skilled freelancer to automate the process of sending student data to school coordinators via WhatsApp. The task involves parsing a large Excel sheet containing student data, splitting it into smaller sheets based on schools, and sending each school's data to the corresponding coordinator's WhatsApp number. The main tasks include: Data Parsing: The freelancer will need to parse the provided Excel sheet containing student data. The data includes student names, grades, schools, coordinator names, coordinator WhatsApp numbers, and student codes. Data Splitting: The freelancer will develop a Python script to split the large Excel sheet into smaller sheets based on schools. Each smaller sheet should contain data for students from a single school. WhatsApp Integratio...
I need a comprehensive HTML/CSS solution for my report pages. it must be clean code with easy names class and id's not generated with ai Key Requirements: 5 pdf files not just this one . - Create inputs: I'm in need of a web developer to build inputs that can be used to create a real report. - Input types: The report inputs should include text, number, and date inputs, as well as checkboxes and tables. - Layout: The layout of the report pages should be exactly as shown in the sample page I will provide. Ideal skills for this job include: - Proficiency in HTML, CSS, and JavaScript. - Experience with form creation and layout design. - Attention to detail to ensure the layout is replicated accurately. i have x5 reports needed to be done not just thi...
...js or Django). Experience with Python, particularly in data handling (pandas) and automation scripts. Strong background in API integration and management. Experience in handling databases (e.g., MySQL, MongoDB). Familiarity with AI and machine learning frameworks or APIs (experience with image generation APIs is a plus). Good understanding of cloud services (AWS, Azure, or Google Cloud) for deploying and scaling applications. Ability to design user interfaces with attention to user experience and responsiveness. Qualifications: Bachelor’s degree in Computer Science, Information Technology, or related field. Proven track record of developing full stack web applications. Portfolio of projects involving automation and API usage. Excellent problem-solving skills and att...
...construction project data that I'd like to convert into a Power BI report. This sheet includes data from various projects of different types in a mix-use development setting. Key requirements: - Convert the Excel sheet data to a visually appealing and informative Power BI report - Create a Power BI report that can be easily updated with new data and link with Excel sheets - Ensure the report is user-friendly and can be navigated easily - Internal Links within Power BI to enhance user interaction Ideal skills and experience: - Proficient in Power BI, with a portfolio that showcases similar projects - Experience in working with construction project data, preferably mix-use developments - Excellent data visualization and report creation skills -...
I need a Notion API expert to customize my Notion pages for a smoother workflow and integration with other apps. Key requirements: - Integration with other apps: I'm looking to connect my Notion pages with an email client, specifically Microsoft Outlook. The goal is to automatically create draft emails in Outlook whenever new orders are created in Notion. - Automation of tasks: The freelancer will need to create a system that automates the email creation process. This should be seamless and require minimal manual intervention. - Email drafts customization: The only specific requirement for the email drafts will be the Email body. Ideal skills and experience: - Strong knowledge of the Notion API - Experience with integrating Notion with external apps, particularly email clie...
...loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) Kepanjen, Malang • Has a camera or phone/tablet of quality with a camera, internet access Please see the attached file for the site visit guideline. You are only required to deliver the pictures, video & observations and are not expected to put together a report like the Sample Report. Note: Milestone will be released the following week after the site visit to give us time to organize the report and contact you if we need additional clarification....
...etc. REQUIREMENTS: • Must be living in (or nearby) San Fabian, Pangasinan, Philippines • Has a camera or phone/tablet of quality with a camera, internet access Please see the attached file for the site visit guideline. You are only required to deliver the pictures, video & observations and are not expected to put together a report like the Sample Report. Note: Milestone will be released the following week after the site visit to give us time to organize the report and contact you if we need additional clarification....
I need a system that automates some feature on my website, focusing on identifying specific numbers and responding accordingly. Main Features for Automation: - Identify 1-digit numbers from the website - Track 10 consecutive numbers less than 2 - Upon detection, the system should: - Fill amount and apply for bet. Ideal Skills and Experience: - Proficient in web automation - Experience with identifying and tracking specific data on websites - Ability to integrate a betting mechanism in the automation process Please note that this project is not for developing a betting site. It's focused on automating a few select features on an existing website.
