Excel vba code convert sql vba işler

I'm on the lookout for a talented virtual assistant who thrives on lengthy hours of work and enjoys every second of it! This isn't your usual VA role, though - I'm seeking someone who can confidently handle the following responsibilities: - Social Media Management: More specifically, I need someone adept at Instagram. You'll be responsible for handling and managin...our audience. Ideal Skills and Experience: - Clear understanding of the Instagram platform and how to optimally engage audience in it - Skills in crafting Instagram worthy content - visuals, captions, and stories - Experience in managing professional instagram account is a plus - Must be organized, communicative, and able to handle long hours of work If this sounds like the sort of work you'd exc...

In need of a talented translator to convert 500-1000 words of written English content into German. The perfect candidate has excellent reading comprehension in English, coupled with superb writing skills in German. Strong attention-to-detail and familiarity with cultural variations will be important in translating the subtle nuances of the text. Skills & Experience: * Native or near-native fluency in German * Proficient reading skills in English * Prior experience with translation * Eye for detail and context sensitivity * Quick turnaround time

For this project, I require an expert who can efficiently extract text content from two distinct webpages and input my data into an Excel file organized by rows. Given that all types of data hold equal importance to me, of essence is for the professional to: - Accurately scrape all text content from the specified webpages - Ensure no data is skewed or omitted during this process - Neatly organize the data by rows in the Excel file The ideal candidate for this job should be proficient in web scraping tools and techniques, possesses an acute attention to detail, and is experienced in using Excel to ensure data is properly formatted and easy to analyze. Please note that minimizing errors during this process is critical, as the data collected will directly influence fur...

...professionals in the age range of 25-40. Key details of the project are as follows: - Social Media Platforms: The campaign will be focused on Facebook, Instagram and Tiktok. I'm looking for a strategy that utilizes the strengths of each platform in a harmonious way. - Campaign Goal: The primary objective of this campaign is to drive traffic to our website. I need a strategy that can effectively convert social media engagement into clicks on our site. Ideal candidate for this project should have: - Proven experience in social media marketing, particularly in driving website traffic. - Familiarity with Facebook, Instagram and Tiktok's advertising and organic reach capabilities. - Understanding of the target audience and how to tailor content to engage professionals in t...

...displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, where you will be able to select 4 tariffs. These blocks with tariffs should be disabl...

...tenure, salary and location of our employees. Your ability to structure and organize these aspects will be key. - Creating an Excel-based system: I'm looking for a dashboard that's easy to dissect and understand. As such, I'd like the final product to be in Excel spreadsheet format. This means you should be very proficient in Excel, knowing how to integrate formulas, tables and other relevant features. - Monthly updates: The dashboard should be designed to be updated monthly. You should be dedicated to ensuring that the data is up-to-date and accurately represented. Ideal freelancer should have: - Proven experience in HR analytics and dashboards - Excellent Excel skills - Ability to present complex data in a clear and concise manner - Strong...

I have an excel sheet with intermediate complexity data, including formulas and charts. I need someone to transfer this data into tables, with the primary goal of organizing the information for better clarity and ease of understanding. Key Tasks: - Type the data into tables: This needs to be done with meticulous attention to detail to ensure accuracy and integrity of the data. - Apply borders and shading: To enhance the visibility of the tables and make them aesthetically pleasing. - Utilize headers: Rows and columns should have appropriate headers to aid in quick data navigation. Ideal Freelancer: - Proficient in Excel: Ability to work with intermediate level of data such as formulas and charts. - Strong attention to detail: Critical for ensuring that data is entered accur...

I have a set of scanned Hindi documents that need to be transcribed into Microsoft Word for further processing. Key Requirements: - Digitalization: The main purpose of this task is to convert the scanned copies into a digital format. - Basic Formatting: The text should be typed with basic formatting (e.g. bold, italic, etc.) but does not need to exactly match the scanned copies. Ideal Freelancer: - Proficient in Hindi: The freelancer should have a strong command of the Hindi language to accurately transcribe the content. - Experienced in Data Entry: This project requires good data entry skills to ensure accurate and efficient transcription. - Proficient in Microsoft Word: Prior experience with transcribing documents in Microsoft Word is preferred. 3 books in Hindi scanned copies...

I'm looking for a highly skilled React expert to convert our current project's design from CSS to React. Our project's API is already prepared, so the job will include connecting the API to the newly designed front-end. Key Requirements: - Converting entire project design from CSS to React - Implementing the project's API - Using Material-UI in design Ideal Skills & Expertise: - Expert level React skills - Proficient in Material-UI - Experience in API integration

As a agency, I'm in need of a professional with versatile skills in Facebook Ads and Website Development. To help my clients to reach new heights for their busines Facebook Ads: - Ad Campaign Setup: You'll launch a campaign that can convert visitors into customers. - Ad Targeting & Audience Research: Dive deep into our target audience, understand their behavior, and identify their needs. - Ad Creative & Copywriting: Develop engaging ad creatives and compelling copy to connect with our target audience. Website Development: - E-commerce Integration: Set up a smooth-running e-commerce platform on our website to facilitate transactions. - Content Management System : Create a CMS for easy publication and update of content. - Interactive Contact Form: Incorporate a c...

...looking for an Excel expert who can create a comprehensive sales target tracking spreadsheet for my customers. This spreadsheet should have several key functionalities. Features Needed: - Customer Information: It should contain a section where I can input and maintain all my customer's details. - Sales Tracking: The spreadsheet should enable me to track my sales targets daily and provide a detailed analysis of my performance. - Target Achievement: The spreadsheet should also be able to analyze the achievement or shortfall of selected items target completion by each customer. Analysis Required: - I would love to have a feature that shows how well sales targets are being achieved as per defined targets. Ideal candidate should have great attention to detail, proficiency...

I need an organized mind to help with research and data entry of a list of companies in a specific industry. Your main responsibility will be organizing this data. While basic Excel skills are a must, experience with data organization, particularly in a business context, would be highly beneficial. The data will be divided into 4 separate categories, so whoever takes on this task needs to have a keen attention to detail and an understanding of categorization. This project is perfect for an individual who thrives in organizing and systematizing data.

**Tour Costing Sheet Structure** 1. **Tour Details** - Tour Name - Tour Code - Duration - Destinations 2. **Client Information** - Client Name - Number of Adults/Children - Contact Information 3. **Accommodation** - Hotel Name - Room Type - Meal Plan - Cost per Night - Total Nights - Total Cost 4. **Transportation** - Vehicle Type - Distance - Cost per Kilometer - Total Cost 5. **Sightseeing and Activities** - Activity Name - Per Person Cost - Number of Persons - Total Cost 6. **Miscellaneous Expenses** - Guide Fees - Entrance Fees - Other Expenses 7. **Pricing** - Subtotal (Sum of all costs) - Markup Percentage - GST (Goods and Services Tax) - Final Price 8. **Payment Details** - Deposit ...

I'm looking for a Python script that uses PyAutoGUI to control keyboard inputs, with a specific focus on interacting with a Firefox web page. I would do it myself as its simple python. However, it needs to record a specific set of keystrokes that are now manually entered 100's of times a day. This script will record the pattern of keystrokes from the start with will be inside the url text box as a neutral starting point. Then after selecting escape several times it is ready to start playing and mimicking the prior manual input. The manual keyboard strokes and presses are recordered and patterns emerge. The gui must then present two hotkeys. Hot key one will playback the most frequent repetitive pattern of keystrokes. The second hotkey will play back the second most freque...

I have an informational website that urgently needs speed optimization. The goal is to remove unnecessary code and CSS, convert the header and footer to PHP and fasten the download speed. Key focal points: - Prioritize the home page, product/service pages, and the contact page for speed enhancement. - Be mindful to sustain the overall HTML structure without specific design alterations or functionality losses. Ideal skills for the job: - Proven experience with HTML, CSS, PHP, and website speed optimization. - Detail-oriented with a strong understanding of download speed issues and solutions. - Previous experience working on informational websites would be a plus. Please bid if you can deliver a quicker, smoother website while retaining its informational essence.

I am currently working on a project that requires the integration of Excel with a PostgreSQL database. As such, I am in need of a freelancer who is proficient in both Excel and PostgreSQL. The primary tasks to accomplish include: 1. Exporting data from Excel to SQL 2. Updating PostgreSQL data using Excel You will be working with various kinds of data as we aim to streamline our operations in a more efficient manner. Ideal skills and experience include: - Solid understanding of PostgreSQL - Expert skills in Excel - Previous experience with SQL data exporting and updating The success of this project highly relies on a flawless data transfer between Excel and PostgreSQL. Your expertise will be extremely valuable to our project&#...

I need a script that will convert any html div to pdf (and download).

I'm in need of an expert to assist with the cleanup of our Medicine database. The goal of this project is to accurately remove all duplicate entries improving the overall accuracy of the data. Ideal Skills & Experience: - Strong background in Database / Excel /CSV management, specifically in the medical field. - Proven track record of similar past work. In your application, please include details of similar projects you've worked on. Efficiency and precision are pivotal for this task. Looking forward to a neat and streamlined database!

I have a channel where I make EXCEL educational videos, I upload 12 videos a month, between 5 to 7 minutes each. YOU MUST BE ABLE TO : - Have experience in editing videos for YouTube. - Have basic knowledge of Microsoft Office, to be able to edit the videos better. - Be able to edit 10- 12 videos consistently every week (Some will be only 1 minute long). IF YOU WANT TO STAND OUT FROM THE REST SEND US YOUR PORTFOLIO

I need a word document translated from English to Russian as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

...for a proficient professional who can create a report in Microsoft Access from a MySQL database. 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 specifie...

I need a professional graphic designer to convert my existing logo into a high-quality PNG file. This project requires: - Converting the logo into PNG format, suitable for various use-cases - Flexible approach in providing the logo in different dimensions as needed - Providing the logo in JPEG format as well Ideal skills: - Graphic design - Proficient in Adobe Illustrator or similar software - Experience in logo editing and file conversion

I need a word document translated from English to Simplified Chinese as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

I am in need of a specialist to optimize my Amazon product listings for coloring books. The key focus will be enhancing visibility and maximizing customer engagement for my book collection. Here's what I am looking for in a freelancer: - I need you to know more about KDP marketing than I do. I only know the basics. I need an advanced skilled...listing. - Suggesting effective marketing strategies tailored to coloring books. - Execute strategies once approved. - Expertise in Amazon's A9 algorithm to optimize listings. Through these efforts, the ultimate goal is to increase the visibility of my coloring books on Amazon, targeting a better ranking in search results, and thereby improving sales. If you have the skills and experience to excel in this role, I would be thrill...

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.

I'm in need of an Excel formula expert to help me with a specific task. I need a formula that will COUNT cells based on the following criteria: - I need to COUNT the number of cells in a range that are greater than -250 - The count should be done for the last 50 cells (ongoing) Your task will be to help me create a formula that dynamically counts the number of cells based on the above criteria. I need this formula to be able to adjust as new values are added to the range. The ideal Freelancer for this project should have: - Extensive experience with Excel functions and formulas - Strong understanding of dynamic range referencing in Excel - Excellent communication skills to explain the logic behind the formula in layman's terms Please include any relevant...

I'm in need of an experienced CAD designer to convert my architectural plans into 2D CAD drawings. These drawings will primarily focus on the interior layout changes required for a new construction project. Key Responsibilities: - Translate 3D drawings into detailed 2D CAD drawings. - Accurately represent all interior layouts -Prepare set of interior design construction documents Your Experience: - Proficient in CAD software, particularly for interior design - Proven track record of creating accurate 2D CAD drawings for construction projects - Prior experience with interior design drawings

I'm seeking a highly skilled programmer proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would be beneficial. Successful completion of this proj...

I am part of an online travel marketing company that specializes in live aboard yacht scuba diving tours on the Red Sea in Egypt. We are in search of a freelance marketer or travel agent to help us increase sales for our tours. We offer a generous commission of 15% per sale and our tours are priced between 1000-1500USD. Here are some key de...experienced divers. - Proven track record in generating leads and increasing sales in the travel/tourism industry. - Creative and strategic thinker who can propose and implement effective marketing campaigns. This is a flexible arrangement with no minimum sales requirements or time commitment. The more you sell, the more you earn. If you're passionate about travel and adventure and have the skills to convert leads into sales, we'd lo...

2 excel files with VBA macro as per customer requirement

One excel file with macro as per requirement

We are looking for an expert for static site generation using faustj...headless WordPress in a monorepo project. Data fetching is done using graphQL. We already have all required react components for the site, but the components need to be moved into a reusable, independent ui library (including build scripts). We use Storybook which should import components from the ui library. We use styled components as css-in-js solution in our react components. We use graphql code generation to generate typescript types from our fragments. Static site generation should make use of SSR and server components. The coding is more than half done. We are looking for someone, who has already made all the mistakes, and guide us. My backend dev scope the project for 2 days. If it takes longer, we will ...

I need an expert in Microsoft Excel to build an efficient spreadsheet to monitor potential lost revenue due to late service deliveries. The ideal candidate would possess a strong background in creating financial models and understanding of revenue tracking. Key Requirements: - Proficient in Microsoft Excel, with emphasis on creating advanced, clear, and highly-functional spreadsheets. - Experience in financial modelling and understanding of revenue tracking. - Ability to automate the process as much as possible to minimize manual tracking. Objective: - Create an intuitive and efficient Excel spreadsheet to replace the current manual method of tracking potential lost revenue due to late service. Skills Needed: - Microsoft Excel - Financial modelling - Adv...

I'm seeking a professional to diligently run through LinkedIn, identifying and documenting HR higher-u...Identifying: I'm targeting senior-level personnel only. Expertise in navigating LinkedIn search and understanding corporate hierarchies will be a plus point. 2. Documenting: I'd like the findings to be presented in a tabular form within an Excel document. Critical data points to be captured include the Company Name, individual's LinkedIn Profile link, and their Role. Your background in HR and corporate structures would be critical in understanding the perfect fit for my requirements. Strong organizational skills, meticulous attention to detail, and proficiency in Excel would be highly appreciated. Overall, a good grasp of LinkedIn-based research would...

I'm seeking an innovative and creative marketing expert, proficient in TikTok, to help generate sales for my online dropshipping store. The type of products I'll be selling is not yet d...products I'll be selling is not yet decided, hence I need someone who can adapt to promoting varying items. Solid expertise in directing campaign strategies to both young adults and teenagers would be advantageous. Skills and Experience: - Deep understanding of TikTok marketing - Proven experience in driving online sales - Knowledge of different product promotion - Ability to target, engage and convert young audience - Flexibility in handling diverse product range Expectations: - Increase store traffic - Generate product sales - Optimize TikTok ads for success - Flexible approa...

I'm looking for a skilled freelancer to help me create a pivot table in Microsoft Excel that will be used to find pricing quicker Key Requirements: - The pivot table must be created in Microsoft Excel. - The purpose of the pivot table is to find pricing easier The data sources which the pivot table will be using are confidential, and will be shared with the selected freelancer.

I am in need of an expert illustrator who can transform a blueprint into a realistic house illustration. Key project requirements: * Convert the blueprint into a realistic illustration primarily focusing on architectural structures. * Use neutral colors for the illustration. Ideal skills and Experience: The ideal candidate for this project should have: * Strong experience in creating realistic illustrations, particularly architecture or real estate. * Proven ability to work with neutral color palettes. * A keen eye for architectural details. * Ability to interpret and utilize blueprints. If you fit this description, I encourage you to bid on this project. Explain your process briefly and provide examples of your previous work in similar projects. Let's bring this blueprint ...

...to guide a transformer model to generate code-mixed sentences. Specifically, we are targeting basic code-mixing complexity - inserting words from one language into another. Key Responsibilities: - Develop and fine-tune a transformer model for code-mixing at a basic level - Implement the model in a way that can generate code-mixed sentences effectively Ideal Skills and Experience: - Strong proficiency in Python programming - Proven experience with NLP and transformer models - Familiarity with code-mixing and its linguistic aspects would be a plus - Good understanding of basic code-mixing complexities - Ability to design, implement, and evaluate NLP models This project is ideal for someone who is passionate about NLP and has a keen interest in ...

I'm seeking a proficient individual to help with a data entry project. I have about 40 URLs, from which I need to extract the product names, prices, and descriptions. The goal is to collate this information in a pre-defined Excel template. Key Aspects: - Extract product names, prices and descriptions from 40 URLs. - Populate an Excel file with the gathered data.

I need an professional who can design a WordPress website for my honey selling business, Also good knowledge on woocommerce required. ** You need good knowledge to attract customers to place order Some other fetures: 1. Correct check out page design for easy checkout 2. Website login before purchase 3. Easy and most powerful way yo convert a visitor to a buyer 4. Products page with content design with review and image review design where user can place reviews with image.

I'm seeking a skilled individual with a strong command of Microsoft Excel and Word. The tasks at hand are primarily data entry, table creation in Excel and development of an instruction manual in Word. Key Responsibilities: - Efficiently perform data entry tasks in Excel. - Create tables in Excel to visually present the data. - Develop an instruction manual in Word. Ideal skills for this project include: - Advanced proficiency in Microsoft Excel, with a strong expertise in data entry and structuring information. - Proficiency in creating tables, and potentially pivot tables. - Strong experience in creating documents in Word, preferably instructional or informative content. - Attention to detail, as accurate data entry is vital. - Strong communica...

Need someone to make a reactive webage which will replace an existing site with a single "holding page" whilst a new site is being worked on. Single page, a few links and some text.

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 i...

I'm in need of an Excel calendar for 2024 - 2025 that will be used for tracking school days off and special events. The calendar should feature the following: - Ability to add and modify events - Monthly view - Color-coded categories - Dates should be highlighted with background color Ideal skills: - Proficiency in Excel, including knowledge of advanced functions - Experience in creating and customizing calendars - Design proficiency to ensure aesthetic and functional layout Look at the Sample

I'm in need of a virtual assistant to help with a variety of tasks, specifically: data entry, email management, and conducting research. ...help with a variety of tasks, specifically: data entry, email management, and conducting research. Ideal Skills and Experience: - Proficient in Google Docs and Sheets - Experience in managing email inbox - Can attend video calls and meeting to write MOM with clients I'm looking for someone who can commit to more than 20 hours per week. The ideal candidate should have a basic understanding of Excel or Google Sheets. Your job will be to document data, answer emails effectively, and conduct research on various topics. I am looking for someone who is timely, organized, and detail-oriented. Please reach out if you think you are a goo...

I have a calculator form that needs some updates made. It allows the user to input measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: New page (needs some jQuery updates): Also have Excel with new formula

I need a skilled draftsman to convert my hand-drawn sketches of building ventilation systems into professional, detailed technical drawings. Here's what the job entails: - Translating my sketches into professional drawings: You will need to accurately transpose and refine my hand-drawn designs into detailed, technical drawings. - Providing the drawings in two formats: I require these drawings in two different formats: PDF for my personal use and an AutoCAD file for my clients. You should be comfortable working in both environments. - Attention to detail is key: These are not rudimentary sketches but detailed, technical drawings. I expect a high level of precision and meticulousness. Ideal candidates have experience with technical drawing, a keen eye for detail, and proficie...

One excel file with macro as per the customer requirement

Hi there, I am seeking a skilled media buyer who is particularly proficient in Facebook and Instagram advertising. A successful candidate will have experience tailoring ads specifically to reach individuals aged between 25-44, women with a long awaited wish for a c...English speaking locals in UAE and Saudi Arabia. - Driving suitable leads from Meta Ads to our Funnel. - Regularly testing and optimizing campaign metrics for maximum efficiency and effectiveness Ideal candidates will have an understanding of audience analytics and demographic targeting. A solid background in multimedia ad creation, especially video, is highly desired. Let's create leads and convert them into customers. If you're results-driven and have a track record of success with Media Buying, I'm ...

...platform. The goal is to develop an indicator based on 3 existing indicators and predefined rules. The source code of all 3 indicators will be provided to the right candidate. The custom indicator should generate trade signals for alerts. Should be able to use this strategy in the Chart, where it should display buy, sell and exit signals. This project requires expertise in Pine Script v5 and a deep understanding of technical analysis principles. My requirement will be as below; 1. Convert 3 indicators into a strategy.(Source code will be provided) 2. Alert Creation. 3. Buy/Sell signal, Trailing SL/Trailing TP integration with alert function. 4. Session End/Start as per the script. 5. Code debugging required if any. 6. Back testing in different time frames....