Workbook.queries vbaJobs

Looking for freelanc...settings in your file. Ensure that the database name, username, password, and host are correct. The host is typically 'localhost', but it can vary. If after trying these steps the issue remains unresolved, it may be necessary to delve deeper into the theme's integration with the database. This might involve checking the theme's code for any recent changes that could affect database queries, especially if the issue started after an update or change to the theme or plugins. Given your preference to avoid technical tasks, these steps are intended to be straightforward and can be done from within the WordPress Admin area. However, if you're unsure about any of these steps or the problem persists, it might be best to seek help from a profe...

I have 2 sheet a bit code modification

Jeg skal have sorteret forskellige studerende på nogle kurser, som de hver især har rangeret. Ikke alle kurser kan have alle de studenter der søger, hvorfor dem med størst præference skal fordeles hertil. Der skal ligeledes udarbejdes en userform, da der er flere dataset at vælge imellem.

Vi ønsker at få en pris på at få oversat den engelske LOD manual inkl. excel workbook til dansk.

Vi ønsker at få en pris på at få oversat den engelske LOD manual inkl. excel workbook til dansk.

Project Overview: We are looking for a talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancemen...

I am on the hunt for five top-notch, native English-speaking customer support agents. The successful candidates must possess expert-level experience in customer support. Shift flexibility is a must as I require coverage across morning, afternoon and evening shifts. Extensive customer support experience is essential, and having a proven ability to handle complex queries in a professional manner will definitely make you stand out. SKILLS AND EXPERIENCE: - Expert proficiency in English - Exceptional communication and problem-solving skills - Ability to work various shifts - Proven experience in high-level customer support. I encourage all qualified applicants to place a bid. Let's make customer satisfaction our top priority!

...application's performance. Prior experience in user interface redesign will be an added advantage. Backend: - The primary task on the backend is to handle the implementation of new APIs. This requires a solid understanding of backend systems, particularly within the MEAN stack. Database: - While the frontend and backend are important, the database is equally crucial. Any expertise in optimizing database queries is a valuable skill I'm looking for. The ideal freelancer for this project should have: - Proven experience with MEAN stack development - A strong portfolio of similar projects - Excellent problem-solving skills - Good communication and collaboration abilities - The capacity to work independently and proactively If you believe you're the perfect fit for ...

...communication, this must provide an all-encompassing experience for our dance studio users. Key Features Needed: - 'Class Schedules Registration': users should easily view and register for our classes. - 'Dance Tutorial Videos': Let our audience enjoy video content of dance tutorials from our studio. - 'Chat Room': A communication platform for users to discuss dance classes, schedules, or general queries. - 'Booking Studio Space': We have 2 dance studios for rent, users should be able to book them through the app. Registration Process: We require users to register for classes: - An Enrollment Form within the app itself - emailed to the Owner The preferred freelancer for this project must have the ability to merge these components into ...

...responsibilities: - Communication: the chosen freelancer must be comfortable communicating in Swedish with professional proficiency. - Grievance Management: Having a strong ability to handle complaints is key, so the candidate should be adept at resolving customer complaints effectively and ensuring customer satisfaction. Skills required: - Fluent Swedish Speaker: To effectively respond to all queries in Swedish. - Intermediate Customer Support: To competently analyze complaints and provide satisfactory solutions. - Patience and Persuasion: Above all, the ability to engage, understand, and manage customer complaints professionally is crucial. Previous experience in complaint handling will be an added advantage. Ensure that you're ready to provide 24/7 support, and can wo...

I am in need of a skilled website developer to create a...automotive parts business. Key Features: - Product Catalog: I aim to display my products in a clear and organized manner. The website should allow for easy browsing and searching of products. - Contact Form: A simple, easy-to-use contact form is a must. This form should send inquiries directly to my email. - FAQ Section: I want to include a FAQ section where customers can find answers to common queries. Key Requirements: - Prior experience in developing similar informational websites is highly preferred. - Strong understanding of user experience design. - Proficiency in mobile optimization is a must. - Excellent communication skills to ensure the final product meets my expectations. Looking forward to your bids and creat...

In quick expansion of our consumer base, I am seeking an Italian native speaker to provide customer support primarily through phone calls. The ideal candidate will have basic knowledge of sales to facilitate successful interactions with our customers. Key Responsibilities: - Answering product-related queries via phone calls - Utilizing effective sales techniques to ensure customer satisfaction - Necessitate top-tier communication skills Essential Skills: - Native level Italian - Proven sales skills - Exceptional problem-solving capabilities - High-quality communication skills I invite those who fit the bill of a proactive problem solver with sales expertise and a passion for providing excellent customer support to consider this opportunity.

Salary 2000 EUR Montly + bonuses I am looking for a native German-speaking individual who can effectively offer customer support for my business. Key Responsibilities: - Responding to customer queries over the phone with promptness and professionalism. - Resolving customer complaints while maintaining a positive and empathetic attitude. - Providing information and assistance regarding products to the customers. Ideal candidate's profile: - Proficient in German (native speaker level) - Proven experience in customer service - Ability to manage stressful situations - Excellent communication skills, especially over the phone. If you believe you're a good fit, please make a bid. Looking forward to working with a dedicated professional who can handle our German customer b...

I'm seeking a skilled developer to create an informational website primarily serving to present company information. Main features should be: - Displaying detailed and engaging company information. - Integrating a functional contact form for queries. - Establishing a product/services page to showcase our offerings. The ideal candidate should have experience in website development, particularly with informational websites, and understanding in creating user-friendly contact forms and detailed product/services pages. Proficiency in UI/UX design is an added advantage to ensure user-friendly design and navigation. Proven portfolio showcasing similar projects required. The focus here is not just a fully functional site, but also one with an engaging, intuitive design to optimize v...

... Only Native Spanish speakers from Spain!! As a rapidly expanding company, we are in need of a dedicated Customer Support professional who is a native Spanish speaker from Spain. This full-time role requires an individual who can provide exceptional customer service during afternoon shifts. The compensation package for this role is EUR2000/monthly. Responsibilities: - Responding to customer queries via voice calls and email, ensuring each customer receives top-notch service. - Using the Zoiper platform to manage customer interactions. Ideal Skills and Experience: - Fluency in Spanish (Spain Spanish) - Solid background in customer support, preferably in a phone and email environment. - Familiarity with the Zoiper platform is an advantage. - Excellent communication and problem-s...

1. We need a logo for our brand 'fysi' for our e-commerce business 2. The logo should represent 'Nature' in any form 3. It should have simply one or two colours, preferably black and white 4. We also require a source file with all the fonts and elements Any more queries or clarifications needed, kindly DM me. Thanks.

...with key decision-makers through personalized interactions, effective communication, and exceptional customer service. Value Proposition: Clearly articulate the unique value proposition and benefits of partnering with our company, emphasizing our expertise, reliability, and commitment to client success. Follow-up and Feedback: Regularly follow up with prospective clients, address any concerns or queries, and solicit feedback to continuously improve our approach and offerings. Measurement and Evaluation: We will establish key performance indicators (KPIs) to measure the success of our efforts, including: Number of new business accounts acquired Revenue generated from new accounts Client satisfaction and retention rates Return on investment (ROI) from marketing and sales initiativ...

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.

...programs. Essential Functions * Understand the history, structure, objectives, programs and financial needs of our organization. * Research grant opportunities from Ontario/Canadian government agencies. * Draft grant proposals and supporting documents based on the funding requirements of the organization. * Submit proposals to grant coordinators for approval. * Respond to internal and external queries on drafted and submitted proposals. * Maintain positive relationships with fund providers and other stakeholders. * Maintain records and submit reports related to grant opportunities. * Researches and identifies new Canadian Government small Business grant funding prospects to match our businesses priorities; * Generates high-quality proposals, narratives, applications and support...

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. - Tra...information do the following: 1: Create a DFD using Visual Paradigm. (Note: we have worked on VP in class) 2. Choose Entities 3. Create ERD based on the entities chosen 4. Create tables/files for each entity 5. Enter minimum 3 records in each table. Read the Key Features to create Columns/Fields in the tables. 6. Create ERD inside MS Access and join the tables based on the ERD 7. Create min 3 queries using...

...searching for an experienced workbook designer to collaborate with me to develop an engaging and effective workbook for emerging documentarians. The workbook content will include: - Instructional text - Quotes - Writing prompts - Visual aids (charts, graphs, images) I already have a cover design, mood board, color palette, initial sample layouts, and draft text. I would like a designer to work with me to create templates that I can fill in (either using InDesign or another platform) that will guide my writing and work prompts process. Once I have completed a first draft of the workbook, the designer will collaborate with me to finalize page layouts and manage the printing/production process. Ideal Skills and Experience: - Experience in designing wor...

I require your expertise for an end-to-end testing of my Ruby on Rails application. Inclusive of all the components, which are Models, Controllers, and Views. Knowledge and usage of MiniTest, Simplecov, and Capybara for the testing frameworks are also required for this project. Key features for testing: - User Authentication - Database Queries - Form Validation The ideal candidate would be someone experienced with Ruby on Rails applications, fluent in the use of multiple testing frameworks, and specializes in identifying and rectifying potential pitfalls.

Dough one Sources 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 kno...

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.

We need a dedicated customer support telecaller to act as a devoted link to both our existing and potential customers. You will be responsible for offering support for our services, responding to inquiries, resolving issues, and ensuring overall satisfa...dedicated customer support telecaller to act as a devoted link to both our existing and potential customers. You will be responsible for offering support for our services, responding to inquiries, resolving issues, and ensuring overall satisfaction. This role requires: - A proven track record in customer support roles, ideally over the phone - Confidence and skill in handling all types of customer queries - Knowledge of CRM tools - Exceptional communication and problem-solving abilities - Experience with service-centric businesses...

I'm in need...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, an understanding of rel...

I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineering prin...

Need advanced SQL including stored procedures, functions, based on existing SQL code. Need c# coding with dojo -Ideal Skills/experience * c# with dojo * MS SQL Server proficient. * Expert in advanced SQL features like stored procedures, functions. * complex SQL queries. * generating SQL reports from tables.

...listings on a daily basis, as well as keeping the page updated with relevant and interesting posts for our followers. - **Video Editing:** As part of the content creation, you should be able to edit videos that could be used for property walkthroughs, testimonials or any other relevant content. - **Client Page Management:** You will also be responsible for the management of customer pages. Ensuring queries are responded to in a timely manner and any issues are handled professionally. This is a dynamic role that requires a proactive and creative approach to social media. The ideal candidate will have a proven track record of managing successful social media campaigns, particularly in the real estate sector. Your work should not only increase our visibility and engagement, but als...

Due to time and resource constraints, I need to migrate a component written in php (symphony) to Golang. The part on github relating to services towards the DB (MongoDb) and the new REST APIs (written in Golang) to access for interfacing is already active. The system will only have to execute queries on MongoDb (via Service) and render in twig template. The repository layer and service and repository are already developed in golang and will be provided. As well as indications on the function to be translated into golang. GIT access will be via wireguard VPN on the development environment

I need an experienced web developer specializing in Magento PHP to assist with an urgent ...is time-sensitive and requires a quick turnaround. Therefore, you must be able to work efficiently and effectively under tight deadlines. - Detail-oriented: Attention to detail is key as the project involves the development of a user-friendly, high-quality web application. - Communication: Effective communication is crucial. You should be able to provide regular updates and be responsive to my queries. - Problem-solving: Being able to troubleshoot and solve issues as they arise is essential. If you can meet these criteria and deliver quality work promptly, I would like to hear from you. Please provide examples of your previous work in Magento PHP, especially any projects with similar time co...

I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.

I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.

I'm looking for a skilled developer who can help me integrate a chat feature into my Telegram account. The chat should be capable of receiving inquiries and sending responses, with the following specifics: - **Manual Responses with Automated Greetings:** The chat should greet the user automatically upon initiation, and then respond to their queries manually. - **Scheduled Messages:** I need the feature to have the capacity to send scheduled messages to users at specific times. The ideal candidate for this project should be familiar with Telegram bot development, have experience with chat automation, and be able to deliver a user-friendly and efficient solution. The ability to understand and meet user needs is crucial. Please provide examples of similar projects you've wo...

...The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work with the specified technologies. Your ability to deliver a professional, well-structured, and visually appealing report within the give...

As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.

Create a Sentinel workbook to display enabled user accounts that have not logged on for 30, 90, and 180 days. This includes creating a runbook to save all Active Directory users on a Sentinel watchlist.

2 excel files with VBA macro as per customer requirement

One excel file with macro as per requirement

...services. Clients should be able to view available times and make reservations seamlessly. - **Online Payment Integration**: I envision a smooth and secure online payment system to be put in place. This will enable clients to complete their bookings conveniently through the website. - **Live Chat Support**: A live chat feature will be an essential component of the site. This will ensure that clients' queries and concerns can be addressed promptly, thus enhancing customer satisfaction. Other Requirements: - The website will primarily focus on a single type of charter service, namely transfer from Hobby Airport to the cruise terminal. - The design of the website should be visually appealing, professional, and in line with the theme of a premium service provider. - Mobile resp...

Hello to all talented SQL freelancers! We are seeking an advanced SQL specialist with proven experience in handling multi-level marketing (MLM) databases, as well as knowledge of Dolibarr ERP. We need someone who can understand the complex terms associated with MLM compensation plans and create effective SQL queries to extract the necessary data, as well as integrate with Dolibarr ERP systems. Responsibilities: Develop advanced SQL queries to extract data from MLM databases. Understand and apply concepts of MLM compensation plans. Collaborate closely with the team to understand project requirements and goals. Integrate SQL solutions with Dolibarr ERP systems. Optimize query performance and ensure data integrity. Requirements: Demonstrable experience in SQL and PHP. Deep k...

Salary 2000 EUR Montly + bonuses I am looking for a native German-speaking individual who can effectively offer customer support for my business. Key Responsibilities: - Responding to customer queries over the phone with promptness and professionalism. - Resolving customer complaints while maintaining a positive and empathetic attitude. - Providing information and assistance regarding products to the customers. Ideal candidate's profile: - Proficient in German (native speaker level) - Proven experience in customer service - Ability to manage stressful situations - Excellent communication skills, especially over the phone. If you believe you're a good fit, please make a bid. Looking forward to working with a dedicated professional who can handle our German customer b...

1. We are seeking a proficient HTML5 and CSS3 expert to improve alummoottil.com. This website is purely HTML5 and CSS3 and there is no usage of javascript (except for google analytics) 2. Your task will be to optimize the performance of the website with the following objectives. a - Improve the website's loading speed b - Enhance its mobile responsiveness c...before contacting us. This is mandatory and the requirement cannot be waived. 7. Please do not contact us with alternate technologies (such as wordpress, wix etc) or tools, and solutions. We are not interested in other technologies. 8. We have no specific budget in mind. We are open to all freelancers who can do the work effectively and at a reasonable cost. As such, we will not respond to queries asking us for what...

One excel file with macro as per the customer requirement

...apart from the standard ones (document format, creation date, update date, size, link to document,...). So the frontend will be sending queries to opensearch and displaying the results. Key Features: - Filter Options: Users should be able to filter their searches based on multiple criteria, such as date, location, category, etc. - Sorting Options: The search results need to be able to be sorted by relevance, date, or other relevant parameters to enhance user experience. It should be possible to sort the documents by multiple parameters at the time. - Autocomplete Suggestion: An intuitive autocomplete suggestion feature would help users with their search queries. - Security: Access to the frontend is restricted to users whose credentials will be checked against the organiz...

As a client looking to set up a home VoIP solution, I'm seeking guidance from a skilled freelancer experienced with both Raspberry Pi and Asterisk server setup. Key Project Details: - I do not require a full-fledged PBX setup, just a basic VoIP service facilitated through my Raspberry Pi. - The primary feature I'm...protocols. - Ability to guide and explain the setup process clearly. Your Role: I've tried to set it up but no voice can be heard on the other end. So this task is mainly a trouble shooting job. Your primary role will be to walk me through the setup of Asterisk on my Raspberry Pi, ensuring proper configuration for home VoIP usage. You should be able to explain key concepts clearly and address any queries I may have. Please do not hesitate to reach out ...

I'm in need of a dedicated professional proficient in English, with excellent communication skills and attention to detail. You will...Details and Preferences and Interests. - You will be given all required access to the online form it needs to be added to. - The project will require adherence to a specific deadline. Ideal skills and experience: • Experience in creating and implementing user-registration forms online. • Knowledgeable in privacy considerations with user data collection. • Able to effectively communicate for any queries or problem-solving needed. • Detail-oriented to ensure each requirement is fulfilled. • Time management skills to adhere to the specified timeframe. Please note that the client has decided to omit specific contact inform...

... Only Native Spanish speakers from Spain!! As a rapidly expanding company, we are in need of a dedicated Customer Support professional who is a native Spanish speaker from Spain. This full-time role requires an individual who can provide exceptional customer service during afternoon shifts. The compensation package for this role is EUR2000/monthly. Responsibilities: - Responding to customer queries via voice calls and email, ensuring each customer receives top-notch service. - Using the Zoiper platform to manage customer interactions. Ideal Skills and Experience: - Fluency in Spanish (Spain Spanish) - Solid background in customer support, preferably in a phone and email environment. - Familiarity with the Zoiper platform is an advantage. - Excellent communication and problem-s...

...improving the bot's ability to understand and process a wide variety of user inputs smoothly and effectively. - Generating Accurate Responses: I require assistance in fine-tuning the bot's response generation to ensure it provides relevant and accurate information to users' queries. - Performance Optimization: I am seeking recommendations on how to optimize the code for better speed, efficiency, and overall performance. The level of customization I'm aiming for in the Chatbot's responses is moderately customized based on user queries. The ideal freelancer for this project should possess: - Proven experience in developing and improving AI Chatbots - Expertise in working with ChatGPT API and Langchain - Strong understanding of natural language proc...