Update vba sql jobs
Looking for an expert in Excel VBA and Macros to automate various processes in my work-flow. Here's the brief rundown of the task involves: - Automated data analysis which includes summarizing data, filtering, Slicers, automatic calculation, and the visualization of data. - Creation of a Custom excel automatic dashboard for real-time reporting and data visualization. Ideal Skill-Set: You should be knowledgeable and experienced in the use of Excel VBA and Macros for automation. Prior experience in VBA, Macros, data analysis and report generation would be a major advantage. Familiarity with automated summary, filtering, Slicer and calculation methods is essential; knowledge of using Macros to create dashboards for real-time reporting is key. If you can meet th...
...some updates to my single page WordPress site using the Ronneby theme and Ideally would like it in less than a week. The updates include: - Menu Updates: I need the font style changed and the layout improved to enhance user experience. The menu should be clean and easy to navigate. - Inter-Page Links: I need these updated for improved usability and to ensure all links work efficiently. - Font Update: I'd like to change the fonts on the entire site to match my brand's guidelines. - WP Forms Mailer: This needs to be updated for improved reliability and to ensure all forms work as intended. - Redesign Services Section: The UI of the services section needs to be redesigned, but not in an accordion style. The ideal candidate should have: - Strong experience with WordPress...
I'm seeking a skilled Wordpress developer to create a professional business website for my company. I will share my pitch deck to provide look and feel of the website. I would like a single page website with multiple sections (i.e., clicking on Services takes the visitor to the section of the landing page with my services etc.). Lastly I need this to be in a format that I can update sections with blurbs and services etc. myself with medium level understanding of Wordpress. No graphics design work is required, logo etc. will be provided.
... preferably with website is for a new business that manufactures emergency fire helicopter equipment, they have one product they are releasing with more planned. I need a logo and I need a website, and need to start on it today. If you want to be considered, do not skip the ratings and questions below. Budget is $250. I have the lifetime license of divi and they're releasing a big update (v5.0) in a month or two that makes it a lot faster & stable to use, so I think it's a good choice. You'll need to create a simple version of the site, more than a wireframe but it'll be less than the final version, as we don't have all the information / content from them yet, but we can at least get started. We will use ai generated images and content as fille...
I'm looking for an experienced VBA programmer to extend and modify the existing 'getpdf' project. The key focus is on integrating it with Microsoft Excel. Key Responsibilites: - Integration with Microsoft Excel: This involves extracting data from Excel files and downloading data from VBA which is PDF-based data, renaming it, and using Selenium. Ideal Skills: - Strong VBA programming skills. - Proficiency in integrating VBA with Microsoft Excel. - Experience with Selenium for web data extraction. - Prior work with GETPDF data extraction preferable.
...the respective service, branch out from there into respective subservices), about us page, contact us page, portfolio and blog. Additionally, these pages must follow a stunning design and reflect our brand's tagline of "Look no further" and it may/may not be dependent on our company's colours. I will be attaching our company's logo below for you to gain an idea. The website must also be easy to update and add information from the back end, such as new pages and blog articles and images (WordPress preferred). It must follow good practice such as being quick to load, SEO friendly and feature a stunning design. I have gathered some design elements from websites which I believe execute certain aspects I am looking for very efficiently. If this sounds right...
...couple of pages. This is a simple modification in telling the page where the config file to connect to database is located. The past developer did all these mods for us and uses three different locations for a config file so anytime I need to change something I have to modify all files instead of just one config file. You will change the call to page to ONE config file so that we only have to update one config file each time. This is a one hour project at most. Your pay will be $20 and you will be paid once changes have been made and source code has been uploaded. Please ping me if you’re available...
...accounts integrate with GeoDirectory. Some of the links on the sidebar have disappeared, probably with an update. I did not originally customize the sidebar and I need somebody to add these links back. These include: - Add new listing - I have the link for this - Manage listings - **I have the OLD link for this, but now it is broken and I don't know what the new link would be or where to find it. This link would go to all of the person's listings in Geodirectory.** - Layout and Design: I require changes to the layout and design of the My Account page. - Functionality: I want custom links to be added to the sidebar. This should be done in a way that is easy to manage and update in the future, allowing me to add more links as needed. Ideal Skills: - Proven...
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.
I need an experienced developer to handle a two-way synchronization between the Bling system and the ERP DeluxeUp. - You will need to import vendors from the Bling system and update their information on the ERP DeluxeUp. - Also, you'll update the Bling system with the latest information from the ERP DeluxeUp. - A GitHub connection is required for the DeluxeUp vendor registration. The synchronization process should be scheduled to run daily and should work efficiently. The ideal candidate for this project should have: - Proficiency in API integration, specifically with the Bling system and GitHub - Experience in two-way synchronization between systems - Strong understanding of the ERP systems Please note that access to the Bling system's source code is a requi...
...for jobs, and managing profiles and portfolios. - Build an admin portal with role-based access for monitoring user activity, managing complaints, and generating reports on job listings and user satisfaction. Preferred Tech Stack: - Front End: TypeScript framework with Server Side Rendering (React.js or Vue.js for web, React Native or Flutter for mobile) - Back End: Utilize GCP services (Cloud SQL, Cloud Functions, etc.) - Payment Gateway: Midtrans Indonesia. This work is going to be divided into 6 major stages, corresponding to 6 milestones: 1. Planning 2. Designing (Software design) 3. Developing 4. Testing 5. Implementation & Integration 6. Maintenance Details upon each stage will be discussed through online meeting If you're passionate about creating innovati...
I'm in need ...modern, and professional-looking website. The site will mainly serve as an informational hub for our company's latest news. Key Requirements: - Purpose: The primary goal of the website is to inform and engage business professionals. - Design: The website should have a corporate, professional, and easy-to-navigate design. - Content: The main content will be company news, so a function to easily update and publish news is a must. Ideal Skills and Experience: - Strong background in web design and development. - Proficiency in creating user-friendly, informative, and aesthetically pleasing websites. - Experience with content management systems for seamless news updates. - Previous work in creating websites for business audiences is a plus. Looking forwar...
...be 1% more than the real time price-Admin fees (2.5%) (This will be functional once the live streaming will start working). So as such no extra work is needed in it. The locking period is 3 working days. It can be checked on the admin as it is already functional. (Just need to check) The sales amount to be transferred to the miner’s bank account manually and once the payment is done admin should update that on the miner’s table which would show the process as completed on both admin and miner dashboard.
I'm looking for someone who can fully understand all XUIONE php files, including the variables and everything else. I have decrypted all php files and I want them to be updated to FFMPEG and FFPROBE version 6.1. I look forward to your suggestions.
As the developer for this project, I will write a RESTful service in Java for tracking timecards. My main purpose is to let the company record employee working hours, generate payroll reports, and monitor employee attendance. To do this, my service must include the following functionalities: - PUT: Create a new timecard - POST: Update an existing timecard - DELETE: Delete an existing timecard - GET: Retrieve timecard information All the aforementioned tasks will return a JSON string, either formatted or unformatted. The JSON string format will not strictly be enforced in this RESTful service, as the main focus is providing a swift and reliable way for the timecard data to be manipulated and retrieved. The successful freelancer for this post should have excellent Java programmin...
I need to move my current WordPress website from its current template to a new one. This change will encompass the entire design and layout, not just specific elements. I also need improvements made to the website, including better performance. Key Requirements: - Move website to new template - Update the design and layout of every aspect - Improve website performance Additionally, I would like the following features added: - A functional and aesthetically pleasing contact form - A calendar system Ideal Skills and Experience: - Proficient in WordPress and its various functionalities - Experience in website migration and template change - Understanding of design principles and UX - Ability to optimize website performance - Experience in implementing and customizing contact forms ...
I need to integrate Tableau with my SQL database, and I'm looking for a skilled freelancer to handle this. Key Responsibilities: - Setup Tableau integration with SQL database - Ensure seamless connection and data flow between the two - Deliver a functional, user-friendly interface for data visualization Ideal Skills: - Strong experience with Tableau and SQL - Excellent understanding of database management and integration - Ability to create interactive dashboards - Proficiency in optimizing data for Tableau visualization This project will require a keen eye for detail and a commitment to delivering a quality, tailored solution.
I'm looking for an experienced web developer to create a profession...appealing gallery to showcase high-quality images of my rental apartments, including interior and exterior views. The website will list less than 10 rental apartments. Therefore, the design should be clean, modern, and easy to navigate. Additionally, I need an integrated calendar for managing availability and pricing for each rental. This feature should be user-friendly, allowing me to easily update and modify rental details. Ideal skills for this project include web development, e-commerce, and experience with developing booking systems. A keen eye for design, user experience, and knowledge of best practices in the vacation rental industry would be a big plus. Please provide examples of similar projects yo...
Development and Enhancement of Excel VBA Project Tracker.
Hi Ashwani G., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
I am in need of a Python script that can extract Amazon's official keywords and search terms, and update this information on a daily basis. This data includes keyword search volume, keyword competition, and top ranking keywords. Key requirements and responsibilities include: - Developing a Python script to extract Amazon's official keywords and search terms - Ensuring the script is capable of updating this data on a daily basis - Retrieving keyword search volume, keyword competition, and top ranking keywords - Aiming for improved product visibility, enhanced product listings, and optimized PPC campaigns The ideal freelancer for this project should have: - Proficiency in Python - Familiarity with web scraping and data extraction - Experience with Amazon's API or web...
I have an unfinished web app that needs some bug fixing and an SES (Simple Email Service) integration for email sending + some code reviewupdate Key Project Requirements: - Fixing existing bugs: The app has several unresolved issues that need to be addressed to make it functional and reliable. - SES integration: You'll be responsible for integrating the Amazon SES into the web app to enable email sendingreceiving. This will require setting up the necessary API calls and ensuring the email delivery system is seamless. - Testing & Production Run: After the bug fixing and SES integration, you'll be expected to conduct thorough testing. Once all issues are resolved, you'll assist us with a successful live production run. The ideal candidate should have: - Proficie...
I've built a form, which has around 8 custom fields. However, numerous questions weren't coded using the appropriate HTML form objects and therefore, I'm in need of a developer who can update the form to ensure that it has the relevant form objects and submits correctly. Once the relevant form objects have been completed a JS script should be written to send the form submission data to a PHP script, where it should be printed. All the while the CSS of the form should be retained. Preferred Skills & Experience: - Proficient in HTML and PHP - Familiar with creating HTML forms - Experience in passing form data to PHP scripts - Knowledge of field validation (since multiple unique fields are involved) - Attention to detail to handle diverse form content successfully. ...
I have the source code of my existing Android app and I'm eager to update its functionalities by using Flutter. The primary goal of this project is to revamp the app and introduce new features. The main aspects of the project include: - Implementing a user login system: The app should allow users to create accounts, log in, and manage their profiles. - Setting up push notifications: I'd like the updated app to send push notifications to users, based on their preferences. - Integrating in-app purchases: Users should have the ability to make purchases within the app securely. Ideal candidates should have: - Proficiency in Flutter and Dart - Experience with Android app development - Strong understanding of user authentication systems - Previous experience with push notifica...
I'm on the lookout for highly skilled Excel VBA developers who can enhance my workbook's functionality and deliver efficient solutions. The scope of this project includes: - Automating data entry procedures to increase efficiency, reduce errors, and ensure accuracy - Designing custom Excel functions for a more streamlined experience - Producing comprehensive reports as per need Key Skills and Experience: - Proficiency in Excel 2013 and Excel 2016 is a must. - Strong knowledge of Excel VBA development - Prior experience with data automation and custom function creation - Expertise in generating powerful reports in Excel I am focused on seeing quantifiable improvements in efficiency and data accuracy through your work. If you have the required skills and experienc...
...Entry (Item): Users should be able to add new items or remove items from the database through the website. Search Feature: Users should be able to search for items using their in-house product code (e.g., FIX001). The website will search the database and display the item along with details such as stock count and a picture. Stock Management: Interactive buttons for "Goods in" and "Goods out" to update stock levels directly through the interface. User Interface: The GUI must be user-friendly, catering to production staff with varying levels of tech expertise. Database: All item data will be stored securely in a database. Regular backup capabilities are essential. Data Analysis: An analysis tab should be available, displaying all items and featuring a search ba...
I'm currently experiencing some problems with SQL Server 2019 regarding a synchronization error in my Snapshot Replication model. Present issue: - Synchronization process follows an error. Desired solution: - Ability to correct the synchronization errors to allow for smooth data replication. Ideal Skills: - SQL Server 2019 expertise - Solid understanding of Snapshot Replication model - Proven experience in troubleshooting synchronization errors. I'm seeking assistance from someone with these expertise, who can provide a quick and efficient resolution to this problem.
I'm seeking a skilled WordPress developer with strong experience in Elementor to update my landing page. - Popup Correction: The Popup check is currently not functioning correctly. It's supposed to be based on the country code but currently appears for all countries. I need this fixed to only appear for specific countries. - Module Understanding: You must understand the Modules section in Elementor. This is to ensure the last two landing pages we've used are consistent in terms of form and function. - Hero Banner Slider: I'm looking to update both the images and text in the Hero banner slider. Additionally, I'd like to introduce some new slides to keep the content fresh. Ideal candidates should be proficient in: - WordPress - Elementor - Understand...
I'm in need of an experienced Vue.js developer to assist with front-end development and implementing dynamic components. The project specifically involves working with Vue 2 and does not require integration with external APIs. Key Responsibilities: - Front-end Development: You'll be tasked with designing and developing the user-facing aspects of the application. - Dynamic Components: Implementing dynamic components to enhance user experience and application functionality. Ideal Skills and Experience: - Proficient in Vue.js: Extensive experience with Vue 2 is a must. - Front-end Expertise: Strong background in front-end development, with a focus on user interface design and development. - Dynamic Component Implementation: Proven experience in implementing dynamic components in V...
...and it is for logistics business. It is an application used by logistical companies to facilitate communication with delivery drivers. * It has already been launched and used by an international company, and it has succeeded and will be more widespread among companies. Therefore, we want to update the design in a professional manner. As the go-to application for logistics companies, Fleetour plays a pivotal role in optimizing operations and ensuring seamless delivery processes. And we only need to update 6 pages in the application . The application contains: 1. Main page: Displays daily tasks for efficient planning. 2. Login page: Provides secure access for users. 3. Car photography page: Simplifies capturing delivery vehicle images. 4. Car registration page: Streamli...
I need someone to replace names and holidays in the calendar I'll send. In InDesign, we need to update the names for the year 2024/2025 from September 1, 2024, to September 1, 2025. It's a copy-paste job, or if you can do it faster, it's up to you. I need it to be error-free. The project is in Slovak, but I have no problem having someone from another country work on it if it's error-free. Payment will be made after inspection. Have a nice day :) You can find the calendar with current names and holidays at the following URL: Template is in format Indesign in attachment.
i have a view like this i need you to make so when i press on the button it should call a enpoint and update food. there is a field called "show_food" And if user press on power icon if is red is should send a request to /food/update/{Food_id} where it updates "show_food" = 0 else if it green it should do "show_food" = 1 )
I'm currently in need of 2 mid-level sales representativ...in need of 2 mid-level sales representatives to aid in the sale of advertising space for my online newspaper. This is a Commission only job but it could prove quite lucrative for the right candidate. Key Responsibilities: - Approach leads with provided information about our platform, and services. - Maintain and grow existing client relationships. - Close sales and achieve quarterly targets. - Update CRM with customer interactions and transactions. The ideal candidates for this project would have: - Proven experience in sales - Understanding of the advertising industry is a plus - Ability to work independently and collaboratively - Excellent negotiation and communication skills - Strong organizational and time-manag...
I am looking for a Magento 2 developer who can help me fix a specific cron job error I've been experiencing. The error states "SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in". Ideal Skills and Experience: - Proven experience with Magento 2 development - Strong understanding of cron jobs and how they work within Magento 2 - Familiarity with debugging and resolving SQL integrity constraint violations Please note that the specific table causing the error was not identified. Your expertise in this area will be crucial. I am using Magento 2.4.6-p4 CE and I get the following error after every order. The job indexer_update_all_views scheduled at 2024-04-15 10:31:03 failed with the following error message: SQLSTATE[23000]: Integrity ...
...server-side rendering features that will be added by the back-end team. - Collaborate with the project and back-end team to understand project requirements and objectives. - Develop reusable UI components and design patterns to ensure consistency and maintainability across the website. - Implement responsive design techniques to create seamless user experiences on various screen sizes and devices. - Update the framework and implement the latest features using NextJS 14. Skills: - Proven experience in UI/UX design for web applications. - Excellent English - Proficiency in NextJS 14, Tailwind CSS, TypeScript, and Node.js. - Familiarity with Restful API design principles and implementation as well as experience working with MySQL or similar relational databases. - Strong skills in ...
I'm looking for an experienced AngularJS developer with a strong understanding of good design principles. Key Aspects: - The primary focus of this project is to update an existing website. - This update will encompass enhancing the user interface design and improving the functionality and features of the site. Your responsibilities will include: - Conducting a thorough analysis of our current AngularJS website's design and features. - Suggesting and implementing improvements in both design and functionality, in line with contemporary design standards. - Ensuring that the updated website is user-friendly and intuitive. - Conducting testing to guarantee the site is responsive and optimized for performance. The ideal candidate will have: - Proficient experience ...
I'm seeking a talented full stack developer for initial software development for a pathology lab. The software must be responsive, user-friendly, and robust, catering to patients, staff, and referring doctors. Here's what we need: 1. **Choice of Platform**: As the client, I am open to using Angular, React or PHP for the development along with SQL Server/MySQL for the database. Feel free to recommend a platform when you apply. 2. **Essential Modules**: - Building Patient Database (From existing Lab Software - Which will remain as is). This database will be used for Whatsapp , email , SMS Marketing (This also is part of scope) and also For Patient Web App interface. Whatsapp API interfacing will be required for sending and interacting with Patients. - Patient Web A...
...experienced developer to integrate my Google Sheet board into my WordPress website. To make it simple I want to do the same as this plugin without using this plugin: Key Project Details: - **Data Types**: I need to display text content, numerical data, and images from the Google Sheet. - **Update Frequency**: I would like the data to be updated on the website in real-time, so it should be refreshed every time there's a change in the Google Sheet. - **Design**: I already have a specific design in mind for how this data should be displayed. Ideal Skills and Experience: - **Google Sheets API**: You should be familiar with the Google Sheets API and how to fetch data from a Google Sheet
• Automate the collation of data from two sheets, "Data" and "Report," into one Excel workbook. • Transfer data from specified columns in the "Data" sheet to new columns in the "Report" sheet. • Implement exception handling to a...columns in the "Report" sheet. • Implement exception handling to address missing values during the data transfer process. • Develop an email notification feature to inform managers about the completion of the collation process. • Add "Data" suffix to transferred column names in the "Report" sheet for differentiation. • Provide a solution to automate the process without manual copying and pasting of VBA code. • Name the final file as "Book of T...
...to my SQL Server database. Key Features: - Property Search: Users should be able to search for properties in my database - Property Details: Users should be able to view detailed information about the properties - Favorites List: Users should be able to save properties to a favorites list User Authentication: - The app should allow users to sign in using their Email and Password. Property Search: - The property search feature should integrate a map view for a better user experience. Users should be able to visualize the location of the properties they are interested in. - It should also include the option to save searches, which will be a convenient feature for users who are actively looking for properties. Ideal Skills: - Proficiency in Xamarin development - Experience with ...
I need a developer to create a proctoring exam application using Python and SQL Server. The primary role of this app is to monitor candidate behavior during online exams. Key features include: 1. Online Registration Of Candidates: A feature for students to easily register for exams. 2. Password-Based Authentication: To authenticate candidates before they can access the exams. Prior experience in implementing secure login mechanisms is preferred. 3. Advanced Browser Disablement: Unfortunately, there will be instances when candidates try to cheat the system. I need to prevent this by disabling browsing other tabs, accessing other applications, and the copy-paste function during the exam period. 4. Random Image Capturing & Video Monitoring: To further deter any cheating, the appl...
I require an expert to set up a CPanel template for my NeoBank website. Files are already uploaded, just need installing and SQL setup. Links to website setup provided.
I'm in need of a VBA or VSTO developer who can assist with data validation tasks in Excel. You would be responsible for: - Validating numerical and textual data - Organizing validated data in a separate sheet Ideally, you should have experience in working with data validation, especially in Excel. You should also be knowledgeable about building or modifying VBA / VSTO for data validation. Specific criteria for data validation are available and will be provided. Your skills in understanding validation requirements will be instrumental. Familiarity with Excel functions and features is necessary, and proficiency in handling both numerical and text-based data will be of importance. Strong attention to detail will be crucial for successful output.
I'm looking for a Linux server administrator with experience in AWS to help maintain and update. Key Responsibilities: - Regular maintenance: We need someone to ensure all the servers are running smoothly. This includes troubleshooting any performance issues and addressing them promptly. - Updates: Keeping all software, including the Linux systems and other server software, up-to-date is crucial for security and performance. We are looking for a Linux server administrator with expertise in AWS to manage our server infrastructure. The responsibilities include ensuring the smooth operation of the servers and addressing any issues that may arise within our custom-built system. We will provide comprehensive knowledge and training about our system. The workload is expected to be m...
I need a freelancer well-experienced in VBA to automate the generation of reports for my business, specifically in Gmail. It's critical for this project to be completed as soon as possible, and here are the specific needs: - Develop VBA scripts that will automatically generate and send specified reports. - Must have a deep understanding of Gmail infrastructure in order to correctly implement the automation process. - Must demonstrate a proven track record in completing similar automation tasks. Your expertise in ensuring efficiency and accuracy is important. If you believe you're the perfect candidate and can deliver this project promptly, please reach out.
...throughout the site. I also need you to be able to build the site in Wordpress using Elementor Pro. It should be built in a way that is expandable and easy to take and reuse parts of the site. The current site is and yes i am a developer myself that knows the site needs updating but i don't have time to do the update. It needs to be sleek and professional and use our already existing branding (see attached). Main Goals: • Update and restructure the placement of images and graphics on the site, giving room for insertion of new captivating visuals to bolster overall appeal. • Restructure site layout to enhance user experience and customer interaction. Ideal Skills & Experience: • Proficient in UI/UX design. • Robust portfolio showcasing design...
...and runs in background - app listens to the incoming messages - on incoming message the forwarding is done by a configurable delay in milliseconds milestones: MS1: implement a basic hardcoded forwarder which detects new SMS (event) and forwards them via e-mail to a hardcoded e-mail address (android and ios) MS2: design & implement a UI, which has a settings dialog for the rules: - add/delete/update/display (CRUD) operations on rules - user can choose a regex pattern to detect specific phone numbers (from) - user can choose the destination(s) (a list of destinations) with whatsapp, telegram, sms, e-mail - implementation in this MS on the UI only for e-mail (but user can select all the named options) - user can choose to use macros like: - sender phone (smsSenderPhonenumb...
"Monitor Regedit for the changes related to the policies applied through Service. Send notification to server, in case of change not applied through Service. 6. Reading Frequency - 1 min, 10 min etc needs to be update in Regedit - HKEY_LOCAL_MACHINESOFTWAREVShieldService, Polling -1 7. Logs needs to be updated to SQL via a API POST call (this endpoint is developed you need to call this Only) and keep a backup at local. api/logs/ { "Username": "", "MachineName": "ABC", "Timestamp": "", "appliedPolicies": [ { "Policy1": "0", "Policy2": "2" } ], "removedPolicies": [ { "Policy3": "2" ...