Macro script update database exceldela

...require: - User Registration and Login: Visitors should be able to create accounts and sign in to access their personal information and history. - E-commerce Capabilities: The platform will host between 50 to 200 products. Each product will need to have its own page with detailed descriptions, pricing, and an option to add to cart. - Content Management System: I will need to be able to easily update product listings, add new items, and manage orders. The ideal candidate for this project should have: - Previous experience with fullstack web development, especially on e-commerce platforms. - Proficiency in modern web technologies and frameworks. - A strong understanding of security and best practices in online retail. - Excellent communication skills and a proactive approach to p...

...used to enter customer orders that are taken over the phone or in person. (Employee will enter customers info and order) (NO PAYMENT processing or customer access) Employee and admin level (Employee cannot delete order, only void) Customer (First Name, Last Name, Phone Number, Note ) (Option to import/export customers would be great) (from Excel file) Item/Product: (Product Category, Product name, SKU, Price) (Option to import/export Products from Excel file) would be great) Workflow would be: Login to App (email and password) (Option to stay logged in) (Option to reset password through email) Flow 1. Customer calls in to place an order. 2. Employee will search for customer by first or last name or phone number of customer. (Search field that searches trough eithe...

I'm in need of a meticulous professional to clean a mixed set of data contained in an Excel file. I am specifically struggling with duplicate values and missing entries. To effectively accomplish this: - You should possess excellent skills in data analysis and data management. - Previous experience with Excel-based data cleaning is preferable. - Profound knowledge of dealing with duplicate entries and filling in missing data is required. - A keen eye for detail and ability to spot and correct errors is essential. In summary, my ideal candidate would be someone with significant experience in data cleaning, particularly with mixed data in Excel files. It would be a bonus if you've previously resolved issues related to duplication and missing entries in da...

I need an adept data entry freelancer to skillfully convert text data from various online sources into an organized Excel spreadsheet. You'll reap the benefits of this project if you're detail-orientated, familiar with navigating online sources, and proficient in Excel. - The project involves researching, collecting and collating text data from specific online sources - The final deliverable needs to be an Excel spreadsheet, with data arranged legibly - Demonstrable experience in data entry jobs would be ideal - A keen eye for detail is paramount as exactness is key for this data entry task - You should be comfortable working with Excel and have proficiency in using all its features. The testimonials of your past clients and your portfolio of simil...

...documents will be analyzed in the next part of the task. • First, select 2-3 companies or tickers of your choice. • Second, for a given company ticker from a user, you need to download a 10-K filing for each year from the SEC website for the period 1995 through 2023 (resulting in approximately 29 10-K documents, it can be less depending on when the company IPOed). • Note that the task is to write a script or program to do this automatically, and not to download all files manually. • You can use the sec-edgar-downloader (https://sec-edgar-downloader.readthedocs. io/en/latest/) package in Python for ease or other similar packages. Task 1.2: Text Analysis • Note: You have to submit ONLY – The program is used to merge data, clean data, perform analys...

I need a proficient excel expert to help me with a data entry project. The data involves simply names, emails, and phone numbers. It will be a table with 100-500 entries, so proficiency in data entry and Excel is crucial. Key Requirements: - Accurate Data Entry: The job is primarily about accurately transferring names, emails, and phone numbers from a document to an Excel sheet. - Excel Proficiency: Knowledge of Excel functions is a plus, though not specifically required. You should be comfortable working with a table of this size.

I'm in need of comprehensive and detailed Australian databases. Specifically: - Medical databases, with a key focus on medical specialties. Medical databases should prefe...should preferably contain reliable and relevant information about the different branches of medical specialties across Australia. - Business databases, encompassing detailed company profiles inclusive of industry category, phone, fax, email, physical address, etc. I'd appreciate getting more data, as in-depth as possible. The databases should be pre-existing or scraped and must be provided in Excel format, or .BAK for MSSQL server. Professionals equipped in big data collection, scrapping, and data analysis would be the most suited for this project. Knowledge about Australian medical and business sect...

I am searching for a talented web developer having experience in creating responsive designs. Specifically, your main task will be to update a website with seamless navigation features, focusing primarily on user interaction. Here is what I am looking for: - Extensive experience in creating responsive website designs - Proven expertise in Android device optimization - A strong background in designing user interfaces aiming at seamless navigation This project doesn't involve e-commerce functionality or interactive elements, but if you have experience in these areas, it could be beneficial for future collaborations. An ideal candidate will be one who can take these requirements and provide a product that is not just functional, but also offers an excellent user experience i...

Prosimo, vpišite se ali se prijavite za več podrobnosti.

Our system stacks various features on top of each other. The attached is our draft of our news feature. The left side will have an internal scroll bar which scrolls down to see more news items. When one comes in focus, the highlight bar on the right will update to show the one in focus. We aren't worried about the actual news item but would like to perfect everything else.

...Oracle 19c database through JDBC. The primary goal of this project is to incorporate essential data operations into the application, mainly including reading, writing, and updating data in the database. Key Responsibilities: - Establishing a secure connection to an Oracle 19c database using JDBC. - Implementing CRUD operations (Create, Read, Update, Delete) features within the application. - Ensuring the application is optimized for efficient data handling and processing. Security Requirement: - The application must be able to securely access the database using username/password authentication. Ideal Candidate: - Proficient in Java and Springboot framework development. - Experienced with Oracle database SQL and JDBC connectivity. - Prior exp...

I need a freelancer to assist with accurate and efficient data entry into Microsoft Excel. The data is in digital format and involves numeric values. Key Requirements: - Enter numeric data into Microsoft Excel from provided digital sources - Ensure data is accurately transcribed - Maintain confidentiality of the data Ideal Freelancer: - Proficient in Microsoft Excel - Strong attention to detail - Previous experience in data entry, preferably with numeric data - Ability to maintain data integrity and confidentiality. Note: Please ensure you have a copy of Microsoft Excel for this job.

I am in need of a professional who can help provide insights into a dataset using Excel's pivot charts, tables, and dashboard. The area of the data is unspecified as of now, but a strong candidate would be adaptable and skilled across domains. Key responsibilities will include: - Data Visualization - Creating Pivot Charts - Building Tables - Preparing a Dashboard Note: This project is basic-level work and my budget is 10 not more than that I already checked price comparisons with different freelancing platforms. if anyone works in that price range only the person make bids does not waste time.

I'm looking for a skilled web developer to transform and enhance our company website, shedbosstablelands.com.au. The major focus of this project is to bring it up to date with modern design trends, improve user navigation, and update the existing content. Additionally, I need an inquiry form integrated into the site to enable interested customers to request quotes easily. Key Deliverables: - Redesign the website with a modern, minimalist aesthetic to reflect current design trends. - Enhance user experience by improving site navigation. - Update the company information content to ensure its accuracy and relevance. Furthermore, the addition of an inquiry form is crucial for our business. This form should be integrated seamlessly into the website's interface and shou...

Necesitamos una hoja de excel donde podamos introducir datos y sea dinamica, os enseñaria un ejemplo de algo que ya tenemos hecho Solo Hispanohablantes por favor, sino es muy complicado el entendimiento

O trabalho consiste em digitar 140 páginas de extratos que estão em PDF para uma planilha do Excel, conforme modelo (os extratos a serem digitados e o modelo de planilha estão nos anexos deste projeto)

...happened and we simply stop the discussion. To us, trust is critical. And it needs to be there from the start. Your first bid is your only bid, we will not continue to engage with those amending bids mid communication. 1 MONTH- LONGER TERM Initially this will be a temporary position (1 month) and this is what you will be bidding on, with a view to a long term role. We will need someone to manage and update the platforms on a continuing and full-time basis. You will be the ideal candidate for this role. CONCLUSION This project promises to be as challenging as it is rewarding, ideal for a social media manager keen on playing a key role in what we hope will become a major new offering in the large and growing Sportsbetting market....

I am seeking a bilingual Sales Specialist with a mid-level experience in enhancing our Service Sales. (5 Sales Specialist needed). Key Requirements: - Fluency in English and Spanish - Mid-level experience in sales. Ideal Skills and Experience: - Proven track record in service sales - Strong communication and negotiation skills - Bilingual proficiency in English and Spanish - Ability to excel in a fast-paced environment. The Sales Specialist will focus on sales effectiveness through phone calls. The primary target market is the Telecom/Home service. The ideal candidate should have a solid understanding of this market and be able to communicate effectively in both English and Spanish. Training on our Services and related will be given. We offer excellent Commissions. Join our tea...

I'm in need of an experienced 2D animator who can bring my script to life through captivating visuals. This project is intended for entertainment purposes, so creativity and storytelling skills are key. * Key Responsibilities: - Create 2D animation based on provided script - Sync the animation with an engaging voiceover Ideal Skills: - Proficiency in 2D animation - Ability to tell a compelling story visually - Experience in synchronizing animation with voiceover Please note that while the script is ready, a voiceover artist will need to be sourced as part of this project. If you have voiceover connections, it would be an added bonus. Looking forward to seeing your portfolio and hearing about your ideas for this project. Title: "The Rise of Black Swana&q...

I have a Perl script that searches a CVS file and generates HTML. When this script has zero results, it currently displays a page stating "SORRY there are no RESULTS". I need this behaviour to change: instead of generating a custom error message, I want the script to send a 404 call to the Apache server. Key Requirements: - Modify the Perl script to send a 404 call to the server when no results are found. - Implement a custom error message to be displayed on the 404 error page. Additional Details: - No logging of details of 404 errors is required for monitoring or debugging purposes. - The script should still function as normal when results are found, only altering its behaviour when no matches are found. - The ideal candidate for this project...

I am looking for a freelancer who is proficient in data entry and familiar with Excel to assist in the digitization of a 276-page vintage parts manual. Your task would be to: - Accurately copy the information from pdf to Excel. This includes part numbers, the description of parts, and all other columns present in the original tables in the document. - Organize the spreadsheet such that each section of the document is represented by a separate worksheet. No specific data validation rules or cell formatting are required, but the data must be accurate and searchable in Excel. This job requires someone with a keen eye for detail and a good understanding of Microsoft Excel. Prior experience in similar data entry tasks would be a significant advantage. A sample pa...

I'm seeking an experienced FiveM developer with proficiency in debugging and performance optimization of scripts. The tasks required include: - Fixing bugs in existing FiveM scripts. Deliverables should work seamlessly without causing system errors or crashes. - Optimizing the performance of th...include: - Fixing bugs in existing FiveM scripts. Deliverables should work seamlessly without causing system errors or crashes. - Optimizing the performance of these scripts. This includes enhancing their efficiency so they do not negatively impact server performance. There will be about 15 purchased scripts that will need to be integrated into the site. Please include examples of previous FiveM script debugging and optimization projects in your proposals. If you do not, you will b...

I'm in need of a proficient Meteor JS developer who can handle both frontend and backend tasks, including database integration, for a web application I am planning to build. The aim of this project is to ensure real-time updates, fostering timely interactions and engagement on the application. KEY RESPONSIBILITIES: - Frontend and Backend development using Meteor JS - Database integration to support the web application's functionality - Implementing a system for real-time update features REQUIRED SKILLS AND EXPERIENCE: - In-depth knowledge and experience with Meteor JS - Proven track record of successful web application development using Meteor JS - Proficiency in database integration - Ability to deliver real-time updates in a web application enviro...

Looking for an expert who can import data from 1-10 Excel files into Google Earth. Key tasks: - Convert location data from Excel into a format readable by Google Earth (preferred Google Eath Pro Tours for Commercial Real Estate Properties - Ensure perfect alignment of data with the geographical locations - Grouping and categorizing the locations as per the content of each column within the Excel files Ideal candidate: - Proven experience with data visualization tools, particularly Google Earth and Google Earth Pro tours for Commercial Real Estate Properties -- High proficiency in handling Excel files and data - Understanding of Geographical Information Systems would be a bonus.

I have a MySQL database that needs exporting. All user data, product data, and transaction data are required to be exported. Key Tasks: - Export all MySQL user data - Export all MySQL product data - Export all MySQL transaction data The final export should be in Excel format. This is not a job for beginners. You should have prior extensive experience with large database exports and MySQL. It would be a big plus if you're familiar with handling sensitive user and transaction data. As the project involves substantial data, confidentiality and data security are non-negotiable. Please include samples of similar database exporting projects you've completed.

I am in need of an Excel spreadsheet expert to create an Excel template using a PDF sample. Without being specific about the details, the ideal candidate should have excellent skills in extracting data from PDFs and well-versed in designing Excel templates. Here's what I'm looking for: Mactacquickshipsellsheet pdf converted into an excel sheet example of what I would like as template.

As the owner of a mobile application, I'm in need of a graphics designer with a creative touch to develop new in-app logos and update existing logos for my project. The primary emotion that I'd like these logos to convey is innovation. I'm open to suggestions when it comes to color schemes. Ideally, the designer should have experience with mobile application graphics and a strong understanding of the principles of logo design. The successful candidate will be able to deliver modern and innovative logos that are aesthetically pleasing and reflective of the application's purpose. Please design one logo each for the following sport category: Basketball, Field Hockey, Floorball, Football, Football Gaming, Gaming, Handball, Ice Hockey, Netball, and Water Polo.

I'm in need of a Python expert who can meticulously extract text and tables from PDFs for data analysis. The requirements are as f...PDFPlumber for extraction Required Skills and Experience: - Proficient in Python - Familiarity with Jupyter Notebook - Experience with PyPDF2, Tabula, PDFMiner, PyMuPDF, and PDFPlumber - Data extraction and analysis expertise. Your commitments would include understanding the architecture of the PDFs, and the most effective library for extraction in each case. The ultimate goal is to create a Python script that eases the data extraction process for subsequent analysis. Whoever can most efficiently extract (using Python) the contents table from p.2 of the attached PDF (an Annual Report), with page numbers and corresponding section titles, wi...

We are looking for a MILVUS devOps expert who will know how to recommend and install the best Milvus hosting server. We are also looking for someone who has done this before MANY MANY times. The end goal is to 1/ recommend which Milvus install plan is best (K8, simple Docker, etc...) 2/ install Milvus and 3/ write detail documentation on how it was done. Then we may want to give you the chance to support and maintain the install. FOR us to consider your submission (WITHOUT the answers to these questions your submission will be automatically deleted) Question 1: Please let us know how many times you have configured and install Milvus. Question 2: Please describe the best architecture you recommend to install and host Milvus. Question 3: Will you be able to demo at leas...

Database Tool Development I. Introduction 1. Purpose: The DRP Talent Solutions team currently manages an internal workforce partner database developed in-house and updated internally. This resource, currently in an Excel spreadsheet format, is used to assist employers in navigating our regional workforce programs and partners. To enhance its utility in responding promptly to RFIs (Request for Information), we aim to reinforce this database tool. Our objectives include implementing organizational features with multiple tags for efficient categorization and establishing a user-friendly update and maintenance system that does not require consultant engagement. 2. Objectives: i. Objective 1: Enhance Database Organization 1. Introduce multiple tags f...

I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel

...calendars. - Allow the company planner to schedule and assign work events to team members. - Implement a communication/chat module to facilitate team coordination. - Incorporate file sharing capabilities to streamline workflow processes. - Enable viewing of uploaded pictures and videos within the application. **User Profile Management:** - Introduce user profile management allowing special users to update their personal data. **Team Management:** - Implement team management functionalities by assigning role models such as Teammember, Teamorganiser, Controller, Boss, and Admin to facilitate efficient team coordination and task allocation. - Restrict access to information based on user roles, ensuring that each user can only view the information relevant to their role. **Communi...

I am looking for a freelancer to assist me with a data entry project. The task involves typing data from handwritten documents into a digital format. The data must be formatted in a specific way, so attention to detail is important. Skills and Experience: - Proficient typing skills and accuracy - Experience with data entry and handling handwritten documents - Familiarity with formatting data according to specific guidelines - Ability to work efficiently and meet deadlines The project includes 1-10 pages or documents that need to be entered. If you are interested in this project, please provide examples of previous data entry work and explain your experience with formatting data.

I'm looking to automate the process of updating a Mailchimp user's profile with a tag when a new blog post is published on Wordpress. This will require the utilization of Zapier to create a connection between the two platforms and ensure that the workflow is seamless and efficient. Key Requirements: - Trigger: A new blog post in Wordpress - Action: Update the corresponding Mailchimp user's profile with a specific tag - Utilize Zapier to create the necessary connection ** I have already built some of the steps for the connection in Zapier but need some help to make it working at 100%. See uploaded photos!

Our manufacturing company is seeking a proficient app developer who can take our existing work orders onto a tablet platform. The application will function as a means for our employees to access, update and input additional information into work orders. A direct connection to our SQL server is essential. The app should have the following key features: - Access and view work orders: Our employees should be able to easily browse and access the work orders. - Update work orders: A functionality to update the status of work orders is pivotal. - Add additional information: The app must also enable employees to input further necessary information into the work orders. Minimum qualifications include: - Proficient in app development. - Familiarity with SQL for direct s...

* Proxmox, hetzner. task is to update the servers, set up zabbix (or similar), and take care of the VPN wireguard. Time to time to configure new VMs, change configurations and improve certain things. Servers are on linux and windows server. In the future, we want you to run hosting server with DirectAdmin.

I'm looking for a talented Excel programmer to build an Excel tool tailored for my business' quotation procedures. Notably, this tool must provide these key functions: - Automatic Price Calculation - Customized Quotation Template Design I already have a specific design in mind for the quotation template and would require the freelancer to implement my design concept accurately. A potential candidate should have considerable Excel programming skills coupled with a solid understanding of quote creation processes. A sense of accuracy, creativity, and robust attention to detail would be beneficial for this task. Outputs should be precise and user-friendly, ultimately contributing to streamlining our current operations.

I'm looking for a talented Excel programmer to build an Excel tool tailored for my business' quotation procedures. Notably, this tool must provide these key functions: - Automatic Price Calculation - Customized Quotation Template Design I already have a specific design in mind for the quotation template and would require the freelancer to implement my design concept accurately. A potential candidate should have considerable Excel programming skills coupled with a solid understanding of quote creation processes. A sense of accuracy, creativity, and robust attention to detail would be beneficial for this task. Outputs should be precise and user-friendly, ultimately contributing to streamlining our current operations.

I'm looking for a capable professional who can migrate my website and emails from to hostgator. The focus of this project is to upgrade the existing hosting plan to enhance the site's performance and speed, while also ensuring that no data is lost during the migration process. Key Tasks: - Transfer website and emails seamlessly from to hostgator - Perform necessary updates and improvements - Address and fix any existing bugs - Enhance the speed and performance of the website You should also: - Be proficient and experienced in website migration and hosting setup - Have a strong understanding of website performance optimisation techniques - Be able to troubleshoot and fix bugs efficiently without compromising data integrity - Prior experience with both and hostgator would be a...

...my website by creating and setting up new pages as needed. - Uploading blog posts: This involves formatting and uploading blog posts on a regular basis. - Adding images and videos: You'll be responsible for adding visual content to the site to enhance its appeal and engagement. For the ongoing maintenance aspect, I need help with: - Updating plugins and themes: You should be able to regularly update the site's plugins and themes to ensure they're up-to-date and compatible with the latest WordPress version. - Managing backups and security: You'll need to set up and maintain a reliable backup system for my site. I also need you to monitor and take care of the site's security. - Optimizing site speed and performance: Your role would also involve improving t...

...in whatever way you’d like: 1. You control the ad spend 2. Only $500 management fee* 3. Search, Display, & Video Ads *excludes ad cost Testimonial: Following the Pandemic our SEO, Blogs and Website were out of date and no longer ranking in Search. No one could find us! Small Business Marketing Solutions knew exactly how to target the problem. First they did all the keyword research needed to update our blogs and content. SMB also created awesome videos for our marketing and used their special formula to give us maximum visibility with every post. Using a methodical approach and small batch testing they determined which platforms we should target with our marketing spend to find our customers. I highly recommend working with Small Business Marketing Solutions. Nicole...

I'm looking for a skilled Excel expert who can help with adjusting product pricing, adding products, creating formulas, adding products etc via excel, .csv. This is a ongoing project. If you can upload .csv to wordpress is a big plus!! KEY REQUIREMENTS: - I specifically need assistance with spreadsheet automation. - The work required is at a basic level, focusing on formulas and functions. - Implement automation for the designated tasks. - Ensure that the automation is robust and well-documented. SKILLS & EXPERIENCE: - Proficiency in Excel is a must. - Experience in basic spreadsheet automation. - Strong understanding of formulas and functions. - Attention to detail and commitment to quality.

I'm looking to develop an Artificial Intelligence (AI) charges calculator for Excel. The core functionalities include: - Automatic calculation of fixed charges - User-friendly interface for effortless interaction and data management. - Reliable data input validation to ensure accuracy and consistency. - Calculate Profit based on fixed charges and earning from subscription The calculator will primarily handle financial data. Prospective freelancers should have a strong grip on Excel, data validation, and UI/UX design—along with financial acumen for effective calculator development. A successful execution ideally enhances efficiency and aids with precise financial management.

I'm in need of web developer to design and create a custom-built e-commerce website for my business. Key Requirements: - Update previous website. - Custom-built website: You'll be responsible for building the site from the ground up. - E-commerce functionality: The website is primarily an online store, so a strong background in this area is essential. - Less than 50 products: Initially, the site will contain a limited number of products, so experience in handling smaller-scale e-commerce projects is preferred. The ideal candidate should have: - Proven experience in custom website development. - Strong knowledge of e-commerce platforms, strategies and tools. - Ability to work with a relatively small product catalog. - Excellent communication skills and a keen eye for det...

Hello, every time I send campaigns what I want is to develop a script that works with API that you can configure, for example, emails that I sent on March 1, I sent it automatically on April 1 and it tells me, example, in the month of April, x amount was sent. of choreo. I want an easy to use interface

I'm in need of a meticulous and reliable freelancer to assist with online data entry tasks. You'll be required to input data into spreadsheets using platforms like Excel or Google Sheets. The data will be provided to you in digital formats, such as PDFs, Word documents, or scanned images. Key Requirements: - Proficiency in online data entry - Experience working with spreadsheets (Excel, Google Sheets) - Ability to maintain accuracy and attention to detail - Familiarity with handling data in digital formats Ideal Skills: - Previous experience with similar data entry projects - Proficiency in using Excel or Google Sheets - Background in spreadsheet management - Strong attention to detail and accuracy A successful candidate will be someone who can ensure da...

I am looking for a skilled Adobe InDesign professional who has experience in editing text within this graphic design platform. For this project, the scope of the task involves: - Updating 4 sentences within the current design while maintaining the existing font style and size. The ideal freelancer for this job would have great attention to detail, proficient in text manipulations in Adobe Illustrator, and the ability to maintain existing design settings like fonts and sizes. It's vital that the overall aesthetics and visual appeal of the design remain untouched, focusing only on the text changes requested. If you could manage to make these changes seamlessly, I’d like to discuss this opportunity with you. The picture shows the few changes needed. The current InDesign file an...

I am in search of a proficient data entry specialist to integrate data into my online Microsoft Access database. Key Responsibilities: - Entry of a large volume of data accurately and efficiently - Verify the integrity of data before entry into the database Ideal Skills and Experience: - Proficiency with Microsoft Access - High attention to detail, precision and excellent organizational abilities - Prior experience with large database data entry is a plus Please note, the spreadsheet format requirement was skipped and so any standard format is acceptable. Only apply if you are proficient, accurate, diligent, and can meet deadlines.

I'm seeking a skilled C/C++ developer with a focus on Windows compatibility for a project to update and fix existing software. Key Requirements: - Experience with C/C++ programming for Windows OS - Strong problem-solving skills to fix existing software issues Please note that the scope of the project does not currently involve integration with external systems or libraries.

I would like a custom sales order created in Excel for about 50 different items. Key Requirements: - Each item's entry in the order should include item name, quantity, and description. - The items should be sorted by their ship date. - The system should incorporate a feature to apply a total discount on the order. Ideal Skills and Experience: - Advanced Excel Skills with the ability to create customized sales orders - Proven experience in developing financial/ordering spreadsheets - Excellent understanding of sales order process and discount mechanisms.