Database vbaPekerjaan
mình đang tìm dịch vụ support cho tự động hoá đọc dữ liệu ở Excel dùng VBA. bạn nào có thể giúp thì sẽ nói chuyện trực tiếp để giải thích thêm
...experience to help me build a software solution. The primary goal of this system is to manage a variety of business activities, such as managing schedules, tracking project progress, and more. Key Features: - **Database Management**: The software should primarily focus on data storage, retrieval, and basic data manipulation. Database Management Functionality: - **Data Reporting and Analytics**: Developing the capability to generate detailed reports and perform basic analytics on the stored data will be crucial. Ideal Skills: - Strong experience in Codeigniter - Proficiency in database management - Understanding of data reporting and analytics - Ability to create user-friendly interfaces This project will be a great fit for you if you're looking to work on...
I am creating a disruption tracking sheet for Disaster Recovery. I am in need of an Excel VBA expert who can create an efficient macro for me. Your task will be to create a macro that will primarily deal with: - Copying Affected systems from each incident, to the tracking page. - Sort tracking page maximum allowable disruption time - Need to add a manual entry for the time of the incident, and the maximum allowable outage time should have a countdown to how long until it is breached. - Macro should run automatically every 30s or so. If you have a good understanding and experience working on Excel VBA scripting, specifically in creating macros, this job is right for you. An in-depth knowledge of disaster recovery protocols and incident tracking will be a plus point. Please ...
I'm seeking a skilled web developer who can update a music store. I would like to add an auction page, contract management and generator feature. I have updates to user login and music management. Please have experience with audio players and being able to play music while playing an additional mp3 audio tag at a lower volume. Being familiar with ecommerce and using paypal, and stripe for payments. See the attachment for details. Ask all of your questions in the discussion board so everyone knows the question and answer. Please do not submit a fake bid amount and completion time as that will disqualify you. We can discuss everything in the clarification board. We will communicate in chat after I select you as the winner. Thanks!
Need a Plugin/App to Transfer Google Sheet Data to Database via Webhook URL Description: We are looking for a skilled developer to create a custom plugin or app that seamlessly transfers data from a Google Sheet to our database whenever changes occur. The plugin/app should be able to detect any modifications in the Google Sheet and trigger the transfer process automatically. The data transfer should be facilitated through a webhook URL provided by us. Requirements: 1. Develop a plugin/app compatible with Google Sheets that can monitor changes in real-time. 2. Implement functionality to extract data from the Google Sheet and send it to a specified database via a webhook URL. 3. Ensure the plugin/app is secure, efficient, and scalable. 4. Provide clear documentation and...
...View page during invoice creation in Laravel. 24. Implement company filter and action links for quotations based on type on the Invoice listing page in Laravel. 25. Disable automatic PDF creation when viewing data; display data in HTML view instead in Laravel. 26. Develop a calculator for estimating materials, ensuring compatibility with the old CRM and website in Laravel. 26a. Update the Enquiry database to save enquiries from the website Estimate Calculator form in Laravel. 27. Work on integrating a map to visualize data in Laravel. 28. Implement CRUD functionality for Email Templates in Laravel. 29. Allow selection of email templates within the current module and associate specific module items with them in Laravel. 30. Integrate SMTP for email sending in Laravel. 31. Enable e...
I'm seeking an expert in .NET framework for a project that involves setting up a multi-tenant database. My preference is to have a separate database for each tenant, with the databases themselves being simple and containing only a few tables. Key Responsibilities: - Develop a multi-tenant functionality in .NET entity framework - Implement a separate database for each tenant - Design a simple database with few tables Ideal Skills & Experience: - Extensive experience in .NET Framework - Proven expertise in multi-tenant database setup - Proficiency in designing simple databases
...of data structure, the scraped data should be organized and stored in a Google Sheets according to categories. This approach allows for a more coherent and systematic pattern for data analysis and representation. The ideal professional for this task should possess: - Proficiency in web scrapping - Expertise in Python or other relevant programming language - Experience with Google Sheets and database creation - High attention to detail - Demonstrable ability to classify and categorize data. The goal of this project is to track changes over time, based on the data scrapped. This requires a design that will facilitate easy updates and quick overview of changes. Hence, knowledge and experience in data visualization will be an added advantage. I've added a few screenshots of...
I am looking for a specialist to create an interactive UI in React Js that provides a seamless user experience. This project will require: - The creation of at least two UI tes...create an interactive UI in React Js that provides a seamless user experience. This project will require: - The creation of at least two UI test cases, with a clear emphasis on user interaction tests. - Setting up and integrating Routing and Guard Components for authorization. - Developing a backend in Spring Boot. - Saving credentials in a MySQL database. Ideal candidates should have solid experience with React Js, Spring Boot, and MySQL database. Proficiency in creating user interaction tests is also a must. Once completed please provide a GitHub link for the project in .docx file with scree...
My current server setup is causing slow response times for my web application and database system. This project involves optimizing the server settings to enhance the performance of both the web and database applications. Ideal Skills and Experience: - Proven experience in server performance optimization - Expertise in managing servers running web applications and database systems - Familiarity with Laravel, as the web application is built using this technology - Excellent understanding of server-side technologies and configurations Key responsibilities: - Diagnose the current server setup to identify performance bottlenecks - Implement necessary changes to optimize the server settings - Regularly monitor and fine-tune the server to maintain high performance - Provi...
I am in need of a seasoned data entry professional who can attentively transcribe information from various online databases into Google Sheets. The role is strictly manual data entry. Skills and Experience: - Proficient with Google Sheets and similar spreadsheet management tools. - Past experience with database interaction, particularly online databases. - Must have a keen eye for detail to ensure accurate data transcription. - Excellent time management skills are essential as deadlines are strict. Although this position emphasizes manual data entry skills, experience in data cleaning and validation pave the path for optimal efficiency. The successful candidate must provide proof of prior similar projects. Your ability to maintain high standards of accuracy and confidentiality ...
I'm seeking an experienced developer to assist in optimizing database speed for my Node.js website. Key tasks: - Conduct initial review of current setup, hosted on a Hostinger VPS with a configuration of 16GB - Advise and implement changes to improve response time, usining knowledge of different hosting platforms such as Amazon Web Services, Google Cloud Platform or Microsoft Azure. - Familiarity with MySQL as a database management system is a must. Ideal candidate would possess keen problem-solving abilities, strong knowledge in database management and previous experience with Hostinger VPS. Experience is optimizing Node.js websites is advantageous. Please provide examples of similar assignments in your proposal.
I'm looking for a skilled professional to create a robust AI-driven marketing program. This project aims to optimize the marketing database, generate sales, and increase our revenue. Key requirements include: - Building an AI system for data verification to ensure high-quality, accurate information. This includes email verification, phone number verification, and address verification. - Implementing an AI program to sort and segment lists for each campaign. It should consider the following criteria: - Demographic data: Utilizing data such as age, location, gender, and income level. - Customer behavior data: Tracking and understanding customer interactions with the business, such as preferences, buying habits, and engagement. - Purchase history data: Analyzing past purcha...
My WordPress website is currently displaying "Error establishing a database connection" and I can't access the admin dashboard. I need an experienced freelancer with deep expertise in WordPress troubleshooting and database issues resolution. Tasks will include: - Diagnosing the cause of the database connection issue - Fixing the problem to get the website back online - Ensuring all website features are functioning as they should post-fix I'm using a Cpanel on Godaddy for hosting. So, familiarity with Cpanel and Godaddy is a requirement for this task. Also, I'd prefer someone with immediate availability as this is a high-priority issue. Skills required: - Advanced WordPress proficiency - Strong understanding of databases - Experience with ...
I need you to take the list of 250 companies on a google sheet and search each company online and confirm there website, then search for eaxh comoany and add the data to a google slide. Theee should be 3 cell names on the sheet Company name Website Companies house link
I have an online database searching service and I'm looking to upgrade its current features and introduce some new ones. Key Features to Add: - Advanced Search Options: I'm interested in building on my current search function to offer more refined search capabilities. - Scraping: I'm looking to add a data scraping capability to my service. This will involve extracting data from various websites and integrating it into my existing database. - AI Data Analysis: I'd like to incorporate AI data analysis functionality into my service. Specifically, I'm interested in pattern recognition and data clustering. Other Enhancements: - Batch Searching: I need to implement a batch search functionality. - Additional Database Integration: I'm interes...
...noticeable delays during actions that involve fetching data from the MongoDB database, significantly impacting the user experience. I'm seeking a skilled developer who can help me address these performance issues. Key Tasks Include: - Investigating and identifying the root cause of the slowdown when fetching data from MongoDB - Implementing optimizations and solutions to improve the performance of the server actions, particularly those related to database interactions - Testing and validating the improvements before deployment to ensure they effectively address the issue without causing any unintended consequences Ideal Freelancer: - Proficient in and MongoDB - Experienced in optimizing server actions and database interactions for performance - Familiar wi...
I'm looking for a skilled professional to create a comprehensive database ( 10,000 to 20,000) of Non-Resident Indians (NRI) working and/or residing in foreign countries like USA, UK, SIngapore, Canada, Australia, Dubai. Their age group may be between 22 years to 42 database will be used for marketing and promotions for my existing business. Key Elements Needed: - Name - Email - Mobile - Company Name (if available) - Country of Residence or Work Data Collection Methods: - Online Surveys - Social Media Platforms - Public Records Skills and Experience Needed: - Experience in data collection and database creation - Proficiency in using online survey tools - Familiarity with social media data mining - Ability to identify and use relevant public records - Attention ...
... project-wise material usage, stock alerts, etc. 10. **Stock Alerts:** - Implement stock alert mechanisms to notify users when inventory levels fall below a certain threshold. - Alerts can be sent via email, SMS, or displayed within the software dashboard. This software solution would require a database backend to store all relevant data and a user-friendly interface for easy interaction. You could develop it using Microsoft Access, incorporating forms, queries, reports, and VBA (Visual Basic for Applications) for automation and customization. Consider consulting with stakeholders and users throughout the development process to ensure the software meets their specific needs and requirements. Additionally, thorough testing and refinement will be crucial to ensure...
...necesitará conocer varios aspectos: Conocimientos básicos de Excel: Deben estar familiarizados con las funciones básicas de Excel, como la creación de hojas de cálculo, el formato de celdas, la creación de fórmulas, etc. Macros en Excel: Deben comprender qué son las macros en Excel y cómo funcionan. Esto incluye la capacidad de grabar y editar macros, así como comprender el lenguaje de programación VBA (Visual Basic for Applications) utilizado para escribir y modificar código de macros. Requisitos del documento: Deben comprender claramente los requisitos y objetivos del documento de Excel que se está creando, incluyendo las funciones específicas que se espera que realice y los datos...
Hello freelancers, I am seeking someone with a keen eye for detail who can assist me in entering a large amount of numeric data into a database. Here's what the ideal candidate would bring to the table: - Expertise in data entry, particularly with a focus on numeric data. - Proficiency with databases; experience with both creating and updating entries is necessary. - Demonstrated ability to manage large datasets, as the volume of data for this project is over 1000 entries. - Strong analytical skills with a propensity for accuracy. Your task will involve accurately capturing the numeric data and ensuring its successful entry into our database system. The success of this project is reliant on not just swiftly completing the task, but maintaining a high level of accuracy ...
Hi. I need help to setup the binding for a RichTextBox .NET Control so that data is retained. There may be use of VBA that is needed. This is within a FactoryTalk View SE version 14 application. I don't know .NET or VBA, I am a FactoryTalk guy though. Example use case: Lets say a factory has 100 valves. If a user opens popup for Valve #3, I need a text box field in that popup for the user to enter data, and then data is preserved/saved. That popup should be one common FTV display that references the Valve_# that was selected (using parameter files, or...). This example is the main objective. I need a simple and easy solution to this, and I need to understand how to do it myself afterwards. This is perhaps a 1 hour job. My name is Marc. I'm ready to s...
I need a Python expert to scrape tabular data from a series of PDFs and store it in a database. Ideal Skills and Experience: - Proficiency in Python. - Strong experience in web scraping with PDFs. - Familiarity with database management. The PDFs are consistent in format and all contain tables. The scraped data needs to be stored in a database.
I need to configure my Postgres database software to authenticate users with local Active Directory (AD) credentials. Key Requirements: - Authentication: Set up the database to authenticate users with their local AD credentials. This is crucial for security and access control. - Seamless Integration: Ensure that the connection between the database and the AD server is seamless and reliable. - User Management: The system should allow for easy management of user privileges, ensuring that the right people have the right levels of access. Ideal Skills and Experience: - Experience with Postgres: You should have a strong background in working with Postgres, particularly in a configuration and security context. - AD Integration: A deep understanding of Active Directory ...
Function is done, amend the label that is stored and the value show. Only with ftp
I need a skilled professional who can compile a comprehensive spreadsheet of massage and beauty therapists. The data will come from provided databases which include salon details. Key Requirements: - Compile names, addresses, and phone numbers from the databases. - Organize the data in the spreadsheet by type of service (massage or beauty). The ideal candidate for this job should possess: - Proficiency in data entry and management. - Excellent attention to detail to ensure accuracy in the information gathered. - Familiarity with Excel for organizing the data by type of service. - A good understanding of the beauty and massage therapy industry would be advantageous. Please note that the final deliverable should be in Excel format.
As the client, I am looking for a reliable professional to build a customized Excel plugin that will enhance my financial data management. ...adaptability to changing needs or scenarios. The Ideal candidate has advanced knowledge not only in plugin development but also a deep understanding of financial data and its complexities. Proficiency in Excel, VBA, and data management are key, along with a keen attention to detail and a commitment to accuracy. Experience in financial modeling is a big plus. Your ability to meet these specific needs could make a significant difference in my work. - I would like to do quick interactions of the project and rapidly develop the final product. My design does not require any database connection. - All source code must be posted with c...
As someone struggling with certain aspects of Excel 2016, I need an experienced VBA Developer who can assist in creating custom Excel functions and rectifying existing Excel errors. Key duties will include: - Macros programming to automate repetitive tasks - Troubleshooting and fixing inaccuracies in the current Excel functions, if any Despite my lack of specificity about the exact functions or errors, I expect the developer to have a strong understanding of Excel functions in general and to use this knowledge to identify any issues that may exist. Ideal candidates should: - Have significant experience in VBA development - Have a solid understanding of custom Excel functions - Be proficient in troubleshooting & error handling in Excel 2016 - Demonstrate flexibility a...
I'm looking for a VBA programmer to help me with creating custom functions and macros for data analysis in Excel. Key Tasks: - Creating Macros: The project involves developing macros that can automate repetitive tasks and facilitate data analysis. - Building Custom Functions: I need custom functions to aid in data cleaning and manipulation, as well as report generation. Ideal Skills: - Proven experience in VBA programming, especially in Excel. - Strong background in automating tasks and data analysis. - Ability to develop custom functions for data cleaning and report generation. Output: - The generated reports should be in an Excel spreadsheet format, as well as a PDF document. Please provide samples of your previous VBA work, specifically any projects rel...
...performance issues, database errors and configuration conflicts. Your main responsibilities will include: - Improving slow performance: My website is running slowly, and I need you to identify the bottlenecks causing the slow performance, and fix them efficiently. - Fixing database errors: We are experiencing database errors that need to be addressed promptly to ensure smooth operations. - Resolving configuration conflicts: There are conflicts in the configuration which need to be resolved to avoid further complications. Ideal skills for this project include: - Prior experience with Magento 2: You should have a solid background in working with Magento 2 and optimizing its performance. - Database Management: Strong experience in managing large databases on M...
I'm looking for an app developer who can create an alumni database application that will run on both iOS and Android platforms. The primary function of the app will be to provide a comprehensive database of our alumni. Our existing alumni database will need to be integrated into the app. This will require a good level of understanding of database management and integration. I'm seeking a developer who has experience in developing apps for both iOS and Android, and who is also comfortable with integrating and managing large databases. Experience with database management systems and good UI/UX design skills are desirable. Skills Required: - Proficiency in app development for both iOS and Android - Experience with database management ...
I need a diligent professional to gather the specifications of 50 mini PCs and organize them into a spreadsheet. This job will involve: - Checking the manufacturer's site for specifications of mini PCs. - Accurately inputting the data i...mini PC has two RAM configurations, it should be shown as "8GB/16GB" and not "8GB, 16GB". Please open the attached spreadsheet for sample and for list of initial batch of 50 mini PCs. Start a conversation with me if you are interested by telling you have had a look at the spreadsheet and would like to work with me. The purpose of this project is to create a comprehensive database of mini PC specifications. This database will be continually updated with more mini PCs in the future, so a successful completion of th...
I'm seeking a skilled database developer to help me successfully migrate my database from .NET Framework 4.8 + EF6 + AspNet Identity to .NET 6 + EF Core + Identity. The database size is small - less than 1 GB, but it's crucial that user data is meticulously preserved during this transition. Key Tasks: - Perform data migration without any data loss. - Ensure the user login system and roles functions seamlessly in the new system. Ideal candidate should have: - Proven experience in .NET Core and EF Core migrations. - Strong attention to detail, particularly regarding user data. - Proficiency with user login systems in a .NET environment. Attached is the project source.
I am in need of an experienced professional who can work hand in hand with me in exporting my old MySQL database into my new Node.js website. There are a few discrepancies in column names that need attention, so attention to detail is crucial. This is a personal project, and the chosen freelancer should be comfortable providing remote assistance through anydesk, and maintaining open communication over a call throughout the duration of the task. I will personally guide you through the necessary steps and the specific level of accessibility that should be set for the new database. Ideal skills and experience: - Solid understanding of MySQL - Experience in Node.js website development - Exceptional problem-solving abilities - Excellent communication skills - Ability to follow...
I'm looking for a skilled software engineer. THi...task is too large for excel power query, however i want it to operate in a similar fashion. The main purpose of this project is to develop a self-updating database of every racehorse in the state of NSW, Australia, via the website. Key tasks and responsibilities: - Determining the best platform for the software (Web-based/Desktop-based/Mobile application). - Creating a software solution that will automatically update and manage a database of racehorses. Skills and Experience: - Proficiency in at least one high-level programming language i.e., Java, Python, C++ - Experience with automation software - Familiarity with database management - Ability to recommend best software platform based on project requirements...
I am in need of a freelance MIS Executive with strong skills in data analysis and database management. Responsibilities: - Conducting detailed data analysis using the provided tools - Proficiently manage and maintain a database Ideal Candidate: - Proficient in Microsoft Excel and SQL Server - Experience in database management and data analysis - Strong analytical skills - Excellent attention to detail This project requires someone who can work independently, has a good eye for detail, and can deliver high-quality results. A background in MIS or similar field would be a big plus.
...code for payment. 17. Track payment status via UPI acknowledgment. 18. Generate PDF invoice for successful transactions. 19. Record order details in the backend including customer and restaurant information. 20. Develop a dashboard for monitoring user, order, and restaurant data. I'll need all these functionalities seamlessly integrated into the system. Your role will be vital in ensuring the database, UI, and algorithms all function optimally together....
I am looking for a professional who could potentially help me create accountant Databases. Prefer for recent ready database. Ideal skills and experience: • Data entry • Report generation • Customizable fields Contact urgent.
...ability to extract insights from complex data sets and present them clearly is crucial. - Macro Development: You will be responsible for automating repetitive tasks in Excel, including generating reports, automating data entry, and creating efficient formula calculations. Your macros should be user-friendly and easy to maintain. Ideal Skills: - Proficiency in Excel, including advanced functions and VBA programming - Strong background in data analysis and visualization - Experience in creating macros for automation - Excellent communication skills to understand the project requirements and translate them into effective solutions This project is a great opportunity for someone looking to enhance their skills in advanced Excel-based roles and gain hands-on experience in data analy...
It is basically an app that helps the sales see the account profile data that is attached. We already have the designs ready, workflow will be decided in collaboration with the freelancer. Expertise required is app development and not design
I'm in need of a seasoned developer who can design a dynamic, responsive, and custom database synchronization system. Key Requirements: - Custom Data Mappings: The system should allow the designation of unique data mappings for seamless sync across various platforms. - Conditional Sync: The system should support conditional sync to ensure only relevant data is shared. - Automation: The synchronization process should be automated to reduce manual intervention and enhance efficiency. Platforms and Websites: The system should sync data with: - Social media platforms - Mobile devices Ideal Freelancer: - Proficient in database synchronization and mapping - Experienced with integration across websites and devices - Capable of designing automation processes - Knowledgeable ...
I am seeking a proficient VBA developer to help me create a set of macros in Excel. The purpose of these macros is to automate the process of generating multiple files from a base Excel file, specifically for the task of data analysis. Key Requirements: - The macros should be designed to create multiple Excel files from a single base file. The output files should maintain the formulas, formats, and templates of the original file. - The macro should be designed to run on a monthly basis. - The output files can have the same format with different data. The ideal candidate should have: - Proficiency in VBA and Excel - Experience in creating macros for data analysis - Ability to deliver a reliable, efficient, and well-commented solution. I need this to be delivered in the next...
Follow directions in video. Maidstone and Unity - Janessa and Kenzie Turtleford/Shellbrook/North Battleford - Juan David and Eduardo Meadow Lake - Cody/Tristan
...goal is to automate daily updates of the website's database. Key Requirements: - Daily database updates: The website should automatically update its database every day. - Products and prices: The database should include technology products, such as electronics and computer hardware. - Design and layout: The website should be visually appealing and user-friendly. - Database type: The database can be either SQL or MySQL. Ideal Skills: - Proficiency in SQL or MySQL - Experience in e-commerce website development - Strong understanding of front-end design - Ability to automate database updates - Expertise in handling technology products Your proposal should include: - Your experience in similar projects - Your approach to automating da...
...professional who can smoothly transition my old database into the new one for my website. There are some extra columns in certain tables in the new database, so understanding the essence of the project is pivotal. Here's what I need assistance with: 1. Importing Data: I have a detailed list of specific tables and columns which need to be brought into the new setup. Your work will heavily rely on this list. 2. Data Combination: While importing the data, some of it requires merging. I won't be able to guide you on how this should be done, so it will fall under your professional judgment. Your proven experience and innovative strategies will come into play here. I am hoping to find someone who has extensive experience in MySQL, data merging, and database...
...relational database design. The primary goal is to deepen my understanding and skills in E-R modeling, functional dependency theories, and database norms, particularly: * Identifying entities and relationships * Applying E-R modeling and normal forms for a well-designed relational database. The chosen candidate should be proficient in the aforementioned areas, plus have the capability to clarify how to use these skills to identify performance issues, validate data integrity, and evaluate scalability. The project scope encompasses E-R modeling, identifying entities and relationships, and applying normal forms. Ideal Skills: * Advanced knowledge in RDBMS * Proficiency in E-R modeling * Understanding of functional dependency theories * Experience in applying normal...
I am seeking a PHP developer who is experienced in frontend development, and an expert in PHP frameworks and MySQL database integration. The focal point of the project is database management. • Main responsibility of the PHP developer will be to build new databases, thus experience in this is essential. • A background working with PHP frameworks and MySQL is crucial for success in this role. • The role also entails some front-end development tasks. Successful applicants will illustrate these skills throughout their portfolio in relation to past projects. If you are a self-starter with a penchant for database management, I look forward to receiving your bid.
I'm requiring aid in managing and optimizing my SQL database. This database is currently handling a range of information including product details, customer details, and order details. Key Tasks: - Improve the existing SQL database - Ensure efficient handling of product, customer, and order data Ideal experience and skills: - Proficiency in SQL queries - Experience in database management - Familiarity with inventory management processes, specifically handling a limited range of 20 different products. This project will require a keen attention to detail and a comprehensive understanding of SQL database manipulation.
