Macro excel update database jobs

I'm seeking a proficient individual for constructing an Access database for my project. The principal requirements include: - Experience with Access, as that's the selected database management system. - Expertise in data storage and retrieval is essential. - The database will be storing textual and numerical data. Experience in handling these types of data is crucial. Ideal skills would include an in-depth understanding of Access, database design, data storage/retrieval techniques and knowledge in handling both textual and numerical data. This should make for a streamlined and efficient process. I'm excited for us to kickstart this project together!

Please Sign Up or Login to see details.

...details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Length: Short-term, estimated completion within one week. ( MAX 80 AUD as a test round, if the work is good, Larger jobs will come) Application Instructions: Please message me with the keyword "VSL" at the beginning of your application to confirm that you have fully read and understood the job desc...

I'm looking for an experienced web developer with strong WordPress and Elementor skills to update our corporate website. The main focus of this project is to add a blog/news section and a careers section to our site. In addition to these main tasks, there are various other content updates required. Key tasks involve: - Designing and customizing the blog/news section with a custom layout and related posts section. - Implementing a comprehensive careers section including job listings, an application submission form, and employee testimonials. - Updating text and images across the site and adding new pages as needed. Ideal candidates should have: - Proven experience with WordPress and Elementor. - A strong portfolio demonstrating success with similar projects. - A keen eye for ...

I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.

** Please do not apply. If you don’t meet the must have criteria at the beginning of this job description post. We are looking for a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportunities in order to ensure successful grant approvals. The G...the ability to distinguish and identify Ontario/Canadian Grant opportunities • Ability to work effectively under pressure; • Excellent writing and verbal skills; • Be highly organized with the ability to implement systems and follow-up processes; • Proficiency in research, interpreting, and analyzing diverse data; • Excellent Computer skills (Microsoft Office Word, Access, PowerPoint and Excel),...

Project Title: "Customer Order Management System" for an online retail business in MS Access. Objective: To develop a comprehensive database system that allows for efficient tracking and management of customer orders, inventory, and shipping. Key Features: 1. Customer Management - Store customer information including name, address, email, and phone number. - Track customer order history. - Customer feedback and preferences. 2. Inventory Management - Maintain a detailed list of products, including product ID, name, description, quantity in stock, and reorder levels. - Automated alerts for low stock levels. 3. Order Management - Enable creation of new orders with customer information, order details (product, quantity, price), and shipping method. - Trac...

Seeking an experienced firmware engineer to create the firmware on an STM STA8089FG GNSS chip to customize the data sent out via its UART interfaces. The task: - Obtain firmware source code and SDK from ST - Modify firmware to allow custom UART data output: UART0 - GNSS, UART2 - debug strings - Provide source codes so we can update debug messages if needed

Hi I have a python matplotlib script that allows user to scroll through a 3D image, in nifti file format. It has a slider that allows you to scroll through the z axis of the image. I would like for the image to have a text box that updates chosen coordinates that are selected by clicking on the image at a given slice. I would like for the chosen coordinates to only update if the user clicks on the canvas where the image is. I would also like for the text box to be outside the canvas and slider. If you have previous experience with Matplotlib, this should be no problem. Thank you!

I need...to plug in that content. - Products Page: Not needed for now. - Services Page: This page should include detailed descriptions of the services we offer along with the respective pricing. - Contact Us Page: A standard contact page with a contact form, email address, phone number, and a location map. - Must be familiar with !! The site should be built using WordPress, allowing me to update content myself in the future. The design should be clean, professional, and aligned with the nature of a tile company. Ideal Skills: - Proficient in WordPress development. - Experience in creating clean and professional websites. - Understanding of basic SEO practices to optimize the site for search engines. - Familiarity with creating a contact form and integrating it into a website.

I'm seeking a professional able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual repre...

The database is on the National Environmental Agency's website, and it includes all of the applications submitted for environmental permits. Here is a link to the database: Please go over all of the records, and filter ones that match all criteria: 1. EIA Screening Application/Statement or EIA Scoping Application/Statement and 2. The application is for an activity in the sea Start a new spreadsheet, and for every such record, meeting the above criteria, add a row to the spreadsheet including: date of the record, screening/scoping, title of the application (translated to English), a url linking to the application on the NEA website. In addition, download the screening/scoping report document, translate it to English with Google translate

We would like to hire a freelancer expert in development of Postgres Database and Synchronization of Data from our Headquarter to our Multiple Area Office (10 No.) and to Multiple Local PC (Around 300 Nos.) locations available in Network.

We have attached the details we need to sync our data from Headquarter to Area Office and than to local PCs and back again. for RFID based application.

I need some minor changes made to a HTML template. The email template needs to be optimized for various email clients, including Gmail, Outlook, and Apple Mail. I need the new layout to be inspired by specific designs I will provide.

...scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure accuracy of the scraped data. * An understanding of URL patterns would be adva...

...enhance topical authority for blog posts, ensuring content is displayed in a topical authority format on the blog page. • Monitor and analyze SEO performance metrics, making data-driven decisions to improve organic search rankings and traffic. 2. Plugin Management: • Audit existing plugins to identify redundant or outdated plugins that can be removed to streamline site performance and security. • Update and maintain necessary plugins, including 301 Redirect Pro and WP Rocket, to ensure compatibility and optimal functionality without conflicts. 3. Site Performance Optimization: • Implement caching, lazy loading, and other performance enhancements using WP Rocket to improve site speed and overall user experience. • Collaborate with the team to achieve speed...

I am in need of someone with expertise in updating tasks in a digital planner. I would need the freelancer to: - Automate the initial task in bucket 1 to re-appear after completion - After bucket 1's task has been completed, automate a new task in bucket two, -Once bucket 2's task is complete, automate a new task in bucket 3, and so o...to re-appear after completion - After bucket 1's task has been completed, automate a new task in bucket two, -Once bucket 2's task is complete, automate a new task in bucket 3, and so on. I specifically require these tasks to be automated using Power Automate. The ideal freelancer will have experience in digital task management, Power Automate and task automation. This should allow for a smooth update of tasks in my planner with...

Project Budget: $100 Project Deadline: 1-2 Days Project Type: Custom WordPress Plugin Project Difficulty: Standard PHP Version: 8.2 and above Project Overview: Custom WordPress plugin required to allow a user to: - Upload a CSV with bulk new POST data - Select a post category, schedule start date, choose how many posts to PUBLISH ea...WordPress plugin required to allow a user to: - Upload a CSV with bulk new POST data - Select a post category, schedule start date, choose how many posts to PUBLISH each a day - Import post data and create all new posts as DRAFTS, to go live on the specified post schedule & keep a suitable log that can be checked - Insert the new POST IDs back into the original CSV file & automatically download the update CSV for a user 5* FEEDBACK WI...

...is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Mac...

I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight measurement functions. The system should enabl...quantity of each item I have in stock - Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's accessible online. As a freelancer, you should have experience in developing similar solutions and a deep understanding of stock mana...

i have a form created with HTML and PHP. user has to fill in information and when press submit, it should insert infos in database. But sometimes it doesn't it just clear or keep loading. maybe connection is not good everytime. So i need someone to adjust it to upload data in realtime. as soon as user finished typing in 1 field, it should store data. when uploading, it should show loading icon near input field. if succeed, green vink icon. if not, red cross icon. when user finish, user can click submit button which will echo all data stored in mysql database on same page in lightbox. image attached. Budget is $35. if you want more, please do NOT bid. budget is $35

I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user-friendly and has a clean, professional appearance.

I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks

I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.

I'm seeking an experienced Android developer for a major interface update to my app. We need to facilitate a better user experience through user interface design enhancements and additional features. Key project aspects: 1. UI Design Updates: - Specifically, I want to improve the layout and navigation of my existing app. This process requires an innovative approach to enhance user experience and navigation flow. 2. Adding New Features: - Although I'm open to your expert suggestions for new features, the direction was not specified upfront. Potential freelancers must be proficient in Android development with a keen eye for intuitive, modern design. Working remotely, your ability to maintain clear communication for updates and changes on a shared session is cruci...

...customer service. - POS & Credit Management: An integrated point of sale system that also incorporates credit management functionalities. - Finance Management: A module dedicated to tracking financial transactions, generating reports, and managing financial records. Additionally, I'm interested in the following eCommerce functionalities: - Product Catalog Management: The ability to easily create, update, and manage product listings on my online store. - Shopping Cart: A user-friendly interface that allows customers to add items to their cart and proceed to checkout smoothly. - Payment Gateway Integration: Secure and reliable integration with popular payment gateways to facilitate seamless online transactions. Ideal Skills: - Proficiency in developing ERP systems with a...

I need a proficient Google Ads manager to handle my campaigns. I'm looking for someone who can update, create, and manage my Google Ads campaigns on a weekly basis. The main goal of these campaigns is to boost my product sales. You should be well-versed in the following types of Google Ads campaigns: - Search campaigns - Shopping campaigns I need someone with the following skills and experience: - Proven track record of managing successful Google Ads campaigns - Strong analytical and problem-solving skills - Excellent understanding of Google Ads and SEO - Ability to create compelling ad copies - Experience in boosting product sales through Google Ads is a plus. If you think you're the right person for this job, I'd love to hear from you.

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.

Hi Naveen K., please update as per our previous chats.

My WordPress site hosted on AWS is currently down due to a database connection issue. Key requirements: - **Database Connection Issue**: The site is throwing an 'Error establishing a database connection' message. I believe this is related to database connection details in the WordPress configuration file. If you are experienced with AWS and WordPress, this could be a quick fix. - **Backup Restoration**: I have a recent backup of the site. However, I'm not confident about the database connection details in the configuration file. Restoring the backup and ensuring the database connection works correctly is crucial. - **AWS and WordPress Expertise**: Ideal candidates should have experience with both AWS and WordPress. Familiarity wi...

I'm looking for a PHP developer to assist in the web development of a web page for a customer I'm working with. The primary focus will be on implementing the ability to display customer raffle ticket numbers from the database to a WordPress page. Current page was rendered obsolete by a plugin update and needs to be rewritten. Ideal Skills and Experience: - Proficient in PHP, with a good understanding of its ecosystems - Experience in web development, particularly with WordPress - Knowledge of database management for websites - Ability to integrate and display data in a clear and user-friendly manner

I'm looking for a tech savvy freelancer to rectify a persistent issue I'm experiencing when trying to use my DualSense controller natively with the game, Brawlhalla. Despite having support for DualSense, Brawlhalla no longer responds appropriately to the controller. Notably, I've already made an attempt to update the DualSense controller firmware; unfortunately, the issue persists. Your objectives will be to: - Diagnose the problem's root cause - Develop and apply effective manuver to fix the issue - Test to ensure the problem is completely solved The right person for this job should possess the following qualifications: - Proven experience in troubleshooting and resolving tech-related issues on Steam and Windows. - Familiarity with DualSense controller and ...

I'm in need of an expert who can help in developing a relational database using SQL and Python. The project will primarily revolve around database management. Consequently, I would appreciate assistance in the following tasks: - Designing a new relational database, ensuring it's optimized for efficiency and performance. - Implementing data import and export capabilities for seamless data movement. - Developing queries to support the database's functionality and ease of use. The ideal candidate for this project should have a strong background in both SQL and Python, with a specific focus on database development. Experience with optimizing databases for performance and some knowledge of data import/export mechanisms would be advantageous. Moreover...

I'm in need of an expert who can fix my corrupted .FIC file in my HFSQL database. Key Project Requirements: - The file is currently not opening and is producing errors, so the main goal is to restore it to its original state and ensure it can be opened without any issues. Please note that I can provide the corrupted .FIC file for analysis. Ideal Skills and Experience: - Proficient in HFSQL database management. - Proven track record in repairing and recovering corrupted database files. - Strong problem-solving skills to identify and rectify the issues within the file. If you're confident in your ability to handle this task efficiently, please provide details of your relevant experience and how you plan to approach this project in your bid.

I'm looking for a talented individual to build a data dashboard that will display our procurement spend data in a user-friendly and visually appealing way. Key Requirements: - Display Procurement Spend Data: The primary focus of this dashboard is to showcase our procurement spend data, broken down by different categories. - Manual Data Update: The dashboard should be updated by uploading files manually. Ideal Skills and Experience: - Prior Experience: I'm looking for someone who has previously built data dashboards, preferably ones that deal with procurement or financial data. - Data Visualization: Understanding of how to best present data in a simple, yet informative manner. - Tableau or Similar Tool Proficiency: Experience with tools such as Tableau that can integrat...

Project Overview: I am seeking assistance in integrating image links into two Excel sheets containing a total of 620 and 46 product entries for my Shopify store. Each entry includes links to the official websites where the products are sold. The task involves creating a new column labeled Images in both Excel sheets and inserting corresponding image links. This integration is crucial for ensuring that when uploading a CSV file to Shopify, each product will display its respective images seamlessly. Project Details: Scope: Adding image links to Excel sheets for 666 products in total. Task: Create a new column labeled Images in each Excel sheet and insert corresponding image links for each product. Requirements: Image links should open the respective product images...

More details: What type of integration are you looking for? Product inventory syncing How frequently should the product inventory update occur? Every few hours Are there specific product categories that need to be prioritized in the syncing process? Horse feed

I require a skilled contractor to integrate an existing API from an unspecified shipping carrier into my Prestashop store. This integration would enable automatic interaction between the carrier and my store. The key functionality sought is for the automatic posting of customer orders to the carrier's system and the subsequent status update in the Prestashop system whenever the carrier adjusts this status. What I expect from freelancers: - Past work details should be included in the application to demonstrate experience and expertise. Required API Functions: - Customer orders made in Prestashop should automatically post to the carrier system via their API. - Any changes of status made by the carrier should reflect in the Prestashop orders panel. Anticipated Status Changes: -...

I require an experienced photographer to help me update my business's headshots and capture some shots for our YouTube channel. The style of photography I'm seeking is artistic, with unique angles and lighting. It's crucial that the photos stand out and possess a creative touch. The photo shoot will be conducted indoors. It's important that the photographer has the knowledge and equipment to manage lighting and other indoor challenges to ensure top-quality shots. - Experienced with both headshot and YouTube photography - Possess an artistic and creative approach - Skilled in working with indoor lighting - Familiar with creating images for a business context Please provide a portfolio of your previous work that demonstrates your ability in these specific area...

Complete Excel Analytical and Descriptive Analysis on provided dataset by Friday 4 pm

LOGO: - Update/Rebranding current logo in 3 variants. - Creating color variations of the logo selected by the client. - Other additional drafting and preparation - Logo to be the same font as the recommended for to use in post social media and site LOGO PACK (PNG/AI/SGV/PDF/Pozitive/Negative). PATTERN: - Creation of 3-4 brand patterns. - Preparation of files in variants (PDF and PNG). SOURCE: - Identification of new fonts for social media and site. - Preparing the font package and delivering them.

...present the results in a detailed, report that relates to each hypothesis for my thesis research. The analysis is expected to be done using Excel analyses then further descriptive analysis is needed, focusing on summarising the main characteristics of the data and how they prove/disprove each hypothesis. This will involve exploring the responses to the survey questions, identifying patterns, trends, and constructing summary statistics. The key deliverable for this project will be as follows: an Excel spreadsheet with... - raw data in one tab (provided for you in the attached excel document) - cleaned data a separate tab (provided for you attached excel document) - your statistical analyses on other separate tabs a Word doc or PDF with... - insights and f...

As an organization using Exchange 2019, we've recently applied a Cumulative Update. However, post-update, we're encountering issues with both OWA ECP and Exchange PowerShell. The specific problems we're experiencing include: - OWA ECP failing to load properly - Exchange PowerShell unable to connect We are seeking a skilled professional who can assist in rectifying these issues. The ideal candidate should have: - Extensive experience with Exchange Server (preferably 2019) - Proficient in handling issues post Cumulative Updates - Adept at troubleshooting OWA ECP and Exchange PowerShell problems The goal is to have our OWA ECP and Exchange PowerShell fully operational again, following the CU installation. If you're confident in your ability to diagnose an...

...up and redesign my website. This project will involve four main areas of focus: Design Layout, Content Organization, and Speed. Design Layout: - Change color scheme: I need a fresh color palette that is visually appealing and cohesive. It should include a black and white core like my logo with red/blue accents. The images should be updated with the same colors using photoshop recoloring. - Update fonts and typography: I am looking for a modern, readable and consistent font that matches my logo. - Optimize for mobile devices: The website should be responsive and provide a great user experience on all devices. It is already setup like this, but may need some fine tuning. Content Organization: - Rearrange pages and sections: I want to organize my website in a way that is intu...

I need an experienced freelancer to assist me in typing data from handwritten notes into an Excel sheet. Key Requirements: - Previous Experience: Please include details of your previous work in this area - Handwriting Deciphering: Due to the nature of the data being handwritten, you'll need to have good skills in deciphering handwriting - Accuracy: It's crucial that the information is entered into the Excel sheet with the highest level of accuracy Looking forward to your application.

I have a series of PDFs with text that needs to be typed into an Excel sheet. The data is mainly textual in nature. Key Requirements: - Data Entry: You'll be responsible for accurately inputting the text from PDFs into the corresponding cells in Excel. Ideal Skills: - Proficiency in Excel: You should be comfortable using Excel and have experience with data entry. - Typing Skills: Fast and accurate typing skills are essential. - Attention to Detail: The data needs to be entered accurately to ensure the integrity of the information. - Familiarity with PDFs: Experience working with PDFs is beneficial. Please note, there are no specific formatting requirements beyond accurate data entry.

As the developer for a flutter application, you would resolve an issue with the calendar not displaying correctly. Despite not using any third-party libraries, our calendar is not updating with new data. As an ideal candidate, you should: - Have proven experience in Flutter app development - Identify and resolve bugs efficiently - Know how to handle data update issues - Prior experience in calendar functionalities is a bonus

...Appstore and Google store, seamlessly interacting with both Apple and Samsung devices. The key features should include: - Task/Event Management: The app should provide an avenue for the creation and assignment of tasks or events. It will be fundamentally used for administrative organization and must hence accommodate this featured component efficiently. - Notification System: Having a reminder and update system is crucial for the app’s functionality. Timely notifications about upcoming tasks or events should lead to seamless organization. - RSVP Functionality: Incorporate a system that allows users to RSVP or sign up for tasks or events, thus ensuring a steadfast and dependable participation record. The ideal professional for this project will have excellent skills in IOS...

I have a number of scanned documents that contain financial figures. I need someone to accurately type these into an Excel sheet for further analysis. Key Requirements: - Experience with data typing and analysis in Excel, particularly financial data. - Attention to detail is paramount; precision in typing is crucial for the accuracy of the analysis. - Proficiency in English is a must, as the data will be in English and will need to be accurately transcribed. The ideal candidate should have prior experience in financial data entry and analysis, and comfortable working with scanned documents. Your work will be the foundation for subsequent data analysis, so precision and attention to detail is key.