Excel vba sql update sample일자리

I'm in need of a professional and engaging website for a trucking software focused on fleet management. The site will cater mainly to customers, so it should be user-friendly and intuitive. Key aspects to consider: - 3 to 5 page website - It's crucial that the site has a professional appearance to instill confidence in our potential users and investor...mainly to customers, so it should be user-friendly and intuitive. Key aspects to consider: - 3 to 5 page website - It's crucial that the site has a professional appearance to instill confidence in our potential users and investors. Ideal candidates for this project should have: - Ability to create a simple, customer-friendly interface. - Strong portfolio of professional, engaging websites. ***Sample Websites of p...

...with two Excel files: 1. “List to be sent to ” (Main Inventory File) • Contains a list of medical disposables and device parts used in our facilities. • Each row represents a unique item that must be mapped to both EMDN & UNSPSC. • You will add four new columns to this sheet: • EMDN Code (from reference sheet) • EMDN Name (from reference sheet) • UNSPSC Code (from reference sheet) • UNSPSC Name (from reference sheet) 2. “Global Item ” (Reference Data for Mapping) • Contains official EMDN & UNSPSC codes in two separate sheets. • You will use these sheets to correctly classify each item from our inventory. ✅ Requirements & Skills ✔ Experience in medical device classification & inventor...

...with two Excel files: 1. “List to be sent to ” (Main Inventory File) • Contains a list of medical disposables and device parts used in our facilities. • Each row represents a unique item that must be mapped to both EMDN & UNSPSC. • You will add four new columns to this sheet: • EMDN Code (from reference sheet) • EMDN Name (from reference sheet) • UNSPSC Code (from reference sheet) • UNSPSC Name (from reference sheet) 2. “Global Item ” (Reference Data for Mapping) • Contains official EMDN & UNSPSC codes in two separate sheets. • You will use these sheets to correctly classify each item from our inventory. ✅ Requirements & Skills ✔ Experience in medical device classification & inventor...

...they said it is from server site. (we have documentation on it what is happening). We do not have to use NitroPack, if Cloudflare Pro could be used to speed the site up it will be even better, but I need help with Cloudflare set up so it correct those features below. Maybe some commands on Cloudflare as Bypass By Cookie needs to be set up so it would take care of the speed problem. Maybe Optimize SQL queries to reduce server load and response time. Implement server-side caching to reduce load times and improve performance. Those are the problems below with a site: Make fewer HTTP Requests Use Cookie Free Domains Add Expires Headers Compress Component with gzip Performance grade is 72 Load time 654 ms Requests 54 2. We have Immunify 360 installed on the server that keeps i...

...in need of a skilled back-end developer to complement my web app's front end. The primary function of this back end will be focused on data storage and retrieval and transactions. Key Responsibilities: - Develop a robust back end that can handle transactional data. - Design and implement an efficient SQL database (preferably PostgreSQL) to store and manage this data. Ideal Skills and Experience: - Proven experience in back-end development, particularly with web apps. - Strong expertise in SQL, specifically PostgreSQL. - Ability to design and implement efficient data storage solutions. - Experience in handling transactional data. Your role will be crucial in ensuring the smooth, efficient operation of the web app. If you have the necessary skills and experience, I ...

I can write code in VBA for moving rows (orders) from one sheet to the next upon entering specific data in a cell or any other event. Client will explain the rules for moving data in each particular sheet.

I have a CSV/Excel file containing product prices that I need adjusted. All product prices need to be increased by 20%. If the price is $0 then do not update and leave it at $0.

Architectural design - ongoing work: Architectural design of Self storage building and associated infrastructure. Software: • Revit 3D modelling • Lumion Rendering • Autocad • Excel Skills: • Experienced in architectural drafting and design • Knowledge and experience with Australian codes and standards • Full architectural drawing sets including: • Ability to create comprehensive fire safety and evacuation plans • Designing for energy-efficient and sustainable construction o Site plans o Self-storage unit layouts o Floor plans o Elevations o 3D views o Sections o Landscape plans o Traffic management plans o Window and door schedules o Cut and fill plans o Demolition plans o Office and amenity fitout o Construction details • Conve...

I'm seeking a skilled developer to update my Minecraft plugin from 1.17 to 1.21.4. The original developer has abandoned the project but has given permission for modifications. Key Aspects of the Project: - Bug fixes and performance improvements: The plugin needs to be updated to fix bugs and improve performance. This will likely involve identifying and resolving any issues related to incompatible items or blocks. - New features and enhancements: While no new features need to be added to the plugin, it will need to be enhanced to work with the latest version of Minecraft. Ideal Skills and Experience: - Expertise in Minecraft plugin development. - Strong debugging and performance optimization skills. - Experience with version updates in Minecraft. Please note, the goal of th...

...connections. Target Audience: Businesses in Mississauga and the GTA, including but not limited to: ✅ Plumbing companies ✅ Electrical contractors ✅ HVAC companies ✅ Landscaping services ✅ Roofing companies ✅ Delivery & logistics businesses ✅ Mobile auto repair & detailing services ✅ Any business with fleet vehicles Deliverables: The freelancer will provide a detailed, organized list in Google Sheets or Excel, including: ? Business Name ? Industry Type ? Company Address ? Contact Person (Owner/Manager/Decision Maker) ? Phone Number ? Email Address ? Company Website Requirements: ✔ Proven experience in B2B lead generation ✔ Ability to source verified, up-to-date contact details ✔ Familiarity with Mississauga/GTA business landscape is a plus ✔ Strong research skills & a...

I'm looking for a skilled ASP.NET developer to update a web application. The application will require user to use Microsoft authentication. This authentication will be based on email and password credentials. Current application is is in VB.Net Ideal skills and experience for the job include: - Proficient in ASP.NET with a strong portfolio of web applications - Experienced in implementing secure user authentication systems - Excellent understanding of web security protocols

I'm looking for a professional graphic designer to update logo. The specifics of the update will be discussed further, but I am open to a range of possibilities from a change in color scheme to a complete redesign.

...gestionar invitados. Permitir que los invitados confirmen su asistencia en línea. Funcionalidades adicionales: Envío automático de correos electrónicos con las invitaciones y confirmaciones. Posibilidad de agregar comentarios o notas adicionales al confirmar asistencia. Diseño visual y funcional atractivo y amigable para los usuarios. Posibilidad de exportar las listas de invitados a formatos como Excel o PDF. Referencias: Nos gustaría implementar algo similar a los sistemas que se encuentran en: Bliss & Bone The Knot

I need a professional to test my VBA on MAC. You will be testing for macro execution, user interface elements and data processing on MAC as we develop on PC but have mac clients. Skills: - Proficient in VBA - Experienced with testing/running VBA on MAC - Excellent problem-solving skills.

I'm looking for a freelancer who can assist in updating a PDF invoice containing over 200 product descriptions. The new descriptions will be provided directly on the PDF. Ideal Skills: - Proficiency in PDF editing - Attention to detail Experience in editing invoices or similar documents would be an advantage. Please ensure you have the necessary skills and experience before bidding. Is for eBay verification process. Cannot have mistakes.

I am having trouble installing SQL Server MSDE 2000 SP4 on my Windows 10 system. The errors occur during the finalizing installation stage. I suspect it might be a permissions issue, as I am having problems connecting to the database. The ideal freelancer for this project should have: - Expertise in SQL Server and Windows 10 compatibility. - Strong understanding of MSDE 2000 SP4. - Excellent troubleshooting skills for installation errors. - Ability to resolve potential permission issues. - Ability to provide remote assistance via screen sharing tools. i send you my anydesk Your task will be to diagnose the problem and successfully complete the installation so that I can use my older software.

...newcomers from various countries seeking health insurance in Switzerland. Ideal Skills and Experience: - Proven experience in data entry - Familiarity with public services preferred - Ability to handle sensitive data with confidentiality - Experience with database management - Attention to detail and accuracy - Knowledge of health insurance processes and terminologies The data should be entered in Excel format. The project will involve entering between 100 entries for the beginning. The project should be completed within the shortest possible timeframe. Please include the following data validation requirements: newcomers coming in Switzerland and requiring health insurance. The data should be organized by the newcomer's country of origin. Please include accuracy checks ...

I'm looking for an expert in Excel to assist me with some formulas related to numerical data. The primary goal is to help me with summing and averaging calculations.

I have an SQL exam focused on data manipulation, specifically using SQL Server. I need someone with strong SQL skills and experience with SQL Server to take the exam on my behalf.

I'm aiming to revamp my LinkedIn profile entirely. The primary purpose of this overhaul is to enhance my visibility and appeal to potential employers across all industries. I need an expert who can: - Redesign my profile picture and banner to reflect a more professional image - Craft a compelling summary and update my experience sections to highlight my skills and achievements - Fine-tune my skills and endorsements to align with my career aspirations The ideal freelancer for this project should have: - Extensive experience in LinkedIn profile optimization - A strong background in career coaching or recruitment - Excellent skills in personal branding and visual design Please provide examples of previous LinkedIn profiles you've worked on, along with the outcomes.

El objetivo es crear un *dashboard automático en Excel* para el gimnasio, que permita consolidar los datos diarios de nuevos afiliados, renovaciones, ventas de cafetería y suplementos, y el cuadre de caja. El dashboard debe ser fácil de usar para las recepcionistas, con gráficos dinámicos y filtros para ver información por día, semana o mes. Además, debe actualizarse automáticamente cada vez que se ingresen nuevos datos sin dañar el archivo y debe ser claro y sencillo para evitar errores en su uso.

I'm in need of an Excel expert who can assist with fixing my spreadsheet and importing a proposal sheet. Specific tasks include: - Creating templates - Inserting data - Design and layout I'm experiencing some issues with my current spreadsheet that have not been resolved, so I would also appreciate a review of this. Ideal candidate should be proficient in Microsoft Excel, have experience with spreadsheet troubleshooting, and capable of assisting with proposal sheet preparation.

I'm in urgent need of assistance with my Salesforce CRM panels. A consultant had previously set up various panels using the sandbox, but now I'm unable to edit or modify anything and everything is out of date. Key Requirements: - Update existing panels and create new ones from scratch. - All new panels should be sales dashboards. Ideal Skills: - Expertise in Salesforce CRM - Experience with developing and designing sales dashboards - Strong understanding of team management metrics Please note that the primary focus of the new sales dashboards should be on team management - tracking performance, setting targets and monitoring progress. I need to be able to manage my team effectively with this new setup.

...Empathetic Mentor – Warm and supportive. Structured Coach – Goal-oriented and direct. Motivational Partner – Encouraging with reinforcement. Mindfulness Guide – Relaxed and reflective. Adaptive AI – Dynamically shifts its approach based on user preferences and progress. Tutorial & Initial Guided Session Brief introduction to CBT principles. Explanation of how the AI chatbot assists in managing burnout. Sample interaction with AI coach to set expectations. 2.2. Core Gameplay Loop Daily Check-in Users log their stress levels and mood indicators. AI coach provides an insightful summary and suggests tailored exercises. Users can opt for a quick intervention or a deep-dive...

I need a talented web designer to give our virtual gift shop, accessed via a QR code in our Airbnb, a modern and sleek makeover. The current design lacks the appeal and sophistication I desire. Key Requirements: - Transform the existing landing page into an engaging, modern, virtual gift shop experience. - Incor...shop experience. - Incorporate a simple, intuitive navigation style, as it will be a single landing page. Ideal Skills and Experience: - Expertise in UI/UX design, especially for mobile interfaces. - Proven track record of creating modern, sleek web designs. - Experience with interactive product displays would be a plus. Please refer to the current design here: I look forward to seeing your proposals.

I'm seeking a native professional translator to translate an English text into Arabic (KSA). The text contains a list of 870 words linked to DIY tools, with a 27 % repetition rate. The lists are marketing phrases intended for the web and tools for professionals (like grinders, drills, hammers, etc.). Deliverables: - The translated text must be delivered in an Excel spreadsheet + SDLXLIFF (or TMX). - The job has to be completed by Friday, 7th, at 17:00 CET. Tone: - The translated marketing phrases should have an informal tone. Terminology: - There are no specific terminologies or keywords that need to be kept in English. Ideal Skills: - Strong proficiency in English and Arabic (KSA) - Experience with translating technical and marketing content - Familiarity with DIY tools...

I'm seeking a skilled data analyst to conduct descriptive analysis on some data. Key Details: - Tools: The analysis must be conducted using SQL. - Data: While I have not specified a particular type of data, it could encompass a range of different datasets. The ideal freelancer should be comfortable working with various types of data. Ideal Skills: - Proficiency in SQL is a must. - Experience with descriptive data analysis. - Ability to work with diverse datasets. - Strong problem-solving skills.

...build a robust and scalable chemical database capable of handling millions of chemical structures. The database should efficiently store and manage the following information: • Chemical structure of each substance • Unique identification number for each compound • Supplier details, including supplier name and ID linked to each structure Requirements: • Expertise in Python and database development (SQL, NoSQL, or specialized chemical databases) • Experience with chemical informatics tools (e.g., RDKit, Open Babel, ChemAxon) • Ability to handle and optimize large datasets • Familiarity with API integration for data retrieval and updates • Strong problem-solving skills and ability to create an efficient, scalable system Preferred Qualification...

I'm seeking a researcher/writer well-versed with the Manitoba media landscape to refresh our annual publication, the Manitoba Media Directory. This extensive guide encompasses all print, radio, TV, specialty publications, and Indigenous media in the province. I need updates across all media sectors, including both specialty publications and Indigenous media. Specific information that requires updating for each media type includes: - Contact information - Publication details - Ownership information - Key editorial staff contact names and roles. Ideal candidates for this project should have: - Strong research and writing skills - Familiarity with the Manitoba media scene - Experience in updating comprehensive media directories - Ability to verify and cross-check information for accur...

I have over 400 customers who pick up products from 18 pick up locations each week. These customers sign in at the location via a QR code that is linked to a JotForm. I need a Google Sheet that pulls data from my JotForm submissions to show who has signed in and who has not. The sheet should automatically update weekly to reflect current data. It should also be capable of distinguishing between customer orders via the Order ID from my website's API. Key Requirements: - The sheet should incorporate specific fields from JotForm submissions: Customer name and contact info, Submission timestamp. - Data should be organized by Pick Up Location. - Knowledge of API and Google Sheets is essential. - The ability to distinguish different customer orders using the Order ID. - The ability ...

I have a website already built on Github and need to make a few simple changes. - Link our new email address to our contact page. - Add our new Phone number to the contact page. - Add our new company logo to the welcome page (we have the logo in PNG format). The contact page does not have specific design guidelines, just update the information as per the above. Ideal candidates for this project should have: - Proven experience with coding on GitHub - Attention to detail - Ability to deliver updates promptly and efficiently

I require a proficient web scraper to gather contact details from websites. The final data needs to be formatted into an Excel spreadsheet. Ideal Skills and Experience: - Proficient in web scraping tools and techniques - Experience in data collection from websites - Ability to organize and format data into Excel - Attention to detail to ensure data accuracy

I'm looking for a talented web designer to help me redesign my WordPress website. The primary goal of this project is to refresh the visual design of the site into a contemporary, minimalist aesthetic. Key Aspects: - Update the current visual design to a modern and minimalist style. - Provide creative suggestions and solutions, as I currently do not have specific websites for inspiration. - Improve the overall user experience through visual enhancements. Ideal Skills and Experience: - Proven experience with WordPress. - Strong portfolio of modern and minimalist web designs. - Excellent understanding of user experience principles. - Creative thinker with the ability to provide design suggestions. - Experience with SEO best practices. Please include samples of your previous ...

... Monitoring of sales and accumulated commissions. Request for withdrawal of commissions. Updating bank details or PayPal/Mercado Pago to receive. ✅ Integration with Payment Gateways PayPal: Checkout and automatic payment return. Mercado Pago: Checkout and automatic payment return. Automatic registration of sales and calculation of commission for the corresponding affiliate. ✅ Database SQL Server or MySQL to store users, affiliates, transactions and payments. ✅ Other Requirements: Clean and well-documented code. Responsive and user-friendly interface for affiliates and administrator. Security and protection against fraud in the payment system. Differentials: Experience with integration of PayPal and Mercado Pago APIs. Experience with developing affiliate systems. ...

I have received the file and information. I will update the resume and complete it as soon as possible.

...de vendas e comissões acumuladas. Solicitação de saque de comissões. Atualização de dados bancários ou PayPal/Mercado Pago para recebimento. ✅ Integração com Gateways de Pagamento PayPal: Checkout e retorno automático de pagamento. Mercado Pago: Checkout e retorno automático de pagamento. Registro automático da venda e cálculo da comissão para o afiliado correspondente. ✅ Banco de Dados SQL Server ou MySQL para armazenar usuários, afiliados, transações e pagamentos. ✅ Outros Requisitos: Código limpo e bem documentado. Interface responsiva e amigável para afiliados e administrador. Segurança e proteção contra fraud...

I need assistance with changing my domain from to www.marketleads.in. The task includes: - Redirecting the old domain to the new one - Updating all website content to reflect the new domain The hosting service I am using is shared hosting. Experience with domain management, website content updates, and shared hosting platforms is essential.

I'm looking for a professional with experience in data collection and SQL database creation to compile a comprehensive list of all family doctors in the Greater Toronto Area using publicly available data. The database should include their names, addresses, fax numbers, and contact numbers. Key Details: - The data should be sourced entirely from publicly available resources - The project also involves faxing marketing materials to these doctors at the end. - The contractor should ensure the accuracy and reliability of all collected data. - Include a mechanism for updating the database in the future as new data becomes available. - Implement a backup and recovery strategy to protect the database against data loss. - All data should be handled securely to protect against unauthor...

I need an expert in Excel to help automate calculations and report generation for my civil engineering projects. Key Tasks: - Automating calculations: This includes a variety of mathematical operations and civil engineering specific calculations. - Streamlining report generation: I want to simplify the process of creating reports from the data and calculations. Ideal Skills: - Proficiency in Excel: You should have advanced knowledge of Excel, including familiarity with its more complex functions and tools. - Civil Engineering Expertise: A strong understanding of civil engineering principles and calculations is crucial. - Automation Skills: Experience in automating tasks in Excel will be key to the success of this project. Please provide examples of similar p...

I'm looking for an Excel expert to create a daily fantasy sports sheet for basketball. This sheet should include current season player statistics, as well as an optimal lineup complete with captain and vice captain. Key Requirements: - Proficiency in Excel - Understanding of basketball and daily fantasy sports - Ability to source and incorporate up-to-date player statistics Ideal Skills: - Data analysis - Fantasy sports strategy - Excel VBA (for automation) Please note, this project is focused solely on the current basketball season.

I need someone to help me with data entry on my WordPress site. The task involves transferring data from another site into my WordPress site. The job involves 600 products, specifically car wrap films. Dat...my WordPress site. The job involves 600 products, specifically car wrap films. Data to be transferred includes: - Product descriptions - Price variations - Product Images I have some images, but will need assistance in sourcing additional ones. The data from the source site is in a CSV/Excel format. Ideal skills and experience for this job: - Proficiency in WordPress - Excellent data entry skills - Experience with product data entry - Ability to source product images - Familiarity with handling CSV/Excel files. Please ensure you have the necessary skills before bi...

I need assistance with entering mixed data (both text and numerical) from scanned documents into an Excel spreadsheet. The data does not require any specific formatting and can be entered in a standard table format. Ideal skills and experience for the job: - Proficient in Excel - Detail-oriented - Experience with data entry - Ability to transcribe information accurately from scanned documents

I'm looking for a detail-oriented freelancer to assist with a simple data entry project. The task involves copying text data from a digital Excel file into online database records. Ideal Skills: - Proficiency in Excel - Attention to detail - Good understanding of text data - Ability to maintain data confidentiality Experience: - Prior data entry experience preferred - Familiarity with handling digital files Other: - Can perform duties during normal Mountain Standard Time working hours - English-speaking Please bid if you can meet these requirements. Thank you.

I have 15 Excel documents containing survey data tables. Each document has multiple tabs with tables. You will need to: - Format all tables uniformly, ensuring they have the same headers and layout - Set the headers to be bold and centered - Adjust the tables to have uniform column widths After formatting, please return the files as: - A neatly formatted Excel document - A merged PDF of all the tables Ideal candidates for this project should have: - Strong Excel skills and experience with data formatting - Attention to detail to ensure all tables are formatted identically - Ability to create a merged PDF from Excel Please note, the headers should be bold and centered, and all tables should have uniform column widths. Ensure the table font style is uniform ...

I need a VBA document designed primarily for report generation. The document should be capable of creating reports that include text summaries, and it should adhere to a consistent font and size throughout. Ideal skills and experience for the job include: - Proficient in VBA programming - Experience in designing documents for report generation - Attention to detail for consistent formatting

...long-term collaboration. Preferred Skills (Not Mandatory): Experience with SEO-based scriptwriting for YouTube. Familiarity with popular anime genres (Shonen, Seinen, Isekai, etc.). Previous experience in scriptwriting for YouTube anime channels. Payment & Work Details: Payment: Per script basis. Script Length: Typically 60-80 minutes of spoken content. If you are interested, please share: A sample script or any related writing work. Your favorite anime and why you love it. Your expected price per script. We look forward to working with passionate anime lovers! ?✨...

I'm looking for a web scraping expert who can extract Over/Under lines (all lines , not only the main one) for all MBL (Baseball) and NHL (Hockey) games from the past 5 seasons. The data should be delivered in an Excel (XLSX) format. Key Requirements: - Expertise in web scraping - Proficient in data handling and Excel - Familiarity with MBL and NHL data - Ability to extract specific betting lines The ideal freelancer for this project would be detail-oriented, with a proven track record in web data extraction, particularly in the sports and betting domain. The ultimate goal is to get comprehensive, clean data for analysis.

I'm seeking a biologist to assist me in running RNA sequencing and variant calling workflows. The workflow is already set up by our devops engineer, but we should validate the configuration. The primary objective is to process some sample datasets. Key Responsibilities: - Validate the existing bioinformatics workflows configuration for RNA sequencing and variant calling (e.g., using tools like GATK). - Run sample datasets through these workflows. Ideal Skills and Experience: - Proven experience in wet lab biology , specifically with working with RNA sequencing and variant calling workflows . Please state which workflows you are familiar with

I'm in need of a male who speaks Telugu and Hindi fluently. Your job will be to call various barber shops in Hyderabad and gather information about their services, specifically service names and pricing. This will include: - Understanding and noting down the different services offered, such as hair cuts, shaves, head mass...include: - Understanding and noting down the different services offered, such as hair cuts, shaves, head massages, etc. - Inquiring about the pricing for these services Once you have collected this data, you will need to upload all of it to the admin panel of my web app. This will involve: - Manually inputting each detail The ideal candidate should be comfortable with: - Data entry - Working with Excel - Using Google Experience in similar tasks will b...

A3 restaurant (folded) menu needs modified - i will provide PDF file - needs price changes and some new items added and small adjustments. i need u to send me revised print ready pdf and also the AI source file Technical Details: it is a FOLDED A3 MENU it folds to A5 (so when opened out u have 4 x A5 sections front and back) UNFOLDED side 1 we can call A B C D UNFOLDED side 2 we can call E F G H A to H are A5 sections when u fold it C and D folds over onto B and A respectively i.e C touches B and D touches A (please note which section "touches which section") Then it is now in an A4 state and u are looking at sections E and F (left to right) E then folds to the RIGHT onto F and A folds to the RIGHT onto D Note: in the A4 state A is face up underneath E and D is the BACK sid...