Excel vba write sql table row jobs

I'm seeking a skilled professional to create a comprehensive loan statement on an Excel spreadsheet. Key Project Details: - I need all transactions included in the statement, ensuring the document is fully up-to-date. - The statement should not only present the transactions but should also include complex calculations such as interests, balances, etc. - As I'm looking for this as a one-time service, the statement should be designed to be updated annually. Ideal Skills: - Proficiency in Excel is a must; the ability to handle complex calculations is highly preferred. - Previous experience in creating and maintaining financial spreadsheets, particularly loan statements, is a significant advantage. - Attention to detail is crucial to ensure all transactions are accou...

I'm looking for a skilled and experienced app developer to create a social media app with features similar to Instagram including suggestion feed features in home page. The key features I'm aiming for include: - User profiles - Photo sharing - Newsfeed In addition to these, I'm looking to include some extra features and functionalities that make the app stand out....looking for a clean and user-friendly interface that is visually appealing and easy to navigate. Ideal skills and experience for this job include: - Proficiency in app development, especially with social media platforms - Experience with creating clean and intuitive user interfaces - Strong knowledge of back-end technologies to ensure smooth functionality - Ability to bring creative ideas to the table...

I have a lot of data in a spreadheet. Have a look at attached spreadsheet. I need the sheet named "auto made" to be automaticly made. (it is now manually filled with data) What triggers data to be in "auto made" sheet is the value 1 in Ordre!B column. If no value in Ordre!B column the "auto made" sheet will onl...have a lot of data in a spreadheet. Have a look at attached spreadsheet. I need the sheet named "auto made" to be automaticly made. (it is now manually filled with data) What triggers data to be in "auto made" sheet is the value 1 in Ordre!B column. If no value in Ordre!B column the "auto made" sheet will only have headers. Description on where the data is from is described in row 10 in "auto made" ...

...as players progress through the endless waves, keeping gameplay engaging and unpredictable. - Design dynamic environments that evolve and present new obstacles or opportunities as players face more difficult waves of zombie pets. - Introduce periodic challenges and special events within the endless mode to shake up the gameplay and provide additional objectives or rewards for players who excel in their survival efforts. 5. Art and Sound Design: - Create visual cues and feedback that convey the increasing intensity and complexity of each successive wave of zombie enemies as players persevere. - Develop audio cues and immersive sound effects that enhance the tension and excitement of facing relentless zombie onslaughts in the endless mode. - Design striking visual e...

I'm seeking a professional who can assist me with populating a Google Sheets spreadsheet with text data from existing databases. This is for the purpose of conducting detailed data analysis. Key Responsibilities: - Locate and extract image links from existing databases - Ensure accurate and error-free input into the Google Sheets - Paste the image links into the right product row Ideal Skills and Experience: - Proficient in using Google Sheets and extracting data from databases - Strong attention to detail to ensure data accuracy - Familiarity with data analysis techniques is a plus - Ability to organize and structure data effectively for analytical purposes I'm looking for someone who can work efficiently and provide high-quality results.

...scraping, data compiling, and spreadsheet management will be greatly valued for this project. Accuracy, timeliness, and consistent daily delivery are crucial aspects of this job. Understanding of automation tools for data scraping would be a big plus. I am looking to collate some data from this website and need an ongoing scrape of this website to set up an ever-updating excel spreadsheet with the fields as per the attached excel file. Go to the website Go to Horse Index A-Z Starting with letter A all the way through to the letter Z Most of the fields will be self-explanatory. Some have been separated. Eg 1st 2nd 3rd Starts

..., only certain locations or only scheduling). Teacher Management Teacher Data Upload: Module to add and update teacher information, including: First and last name Email Phone number Subjects taught (both theoretical and practical) Hourly and daily availability Locations where the teacher is available to teach Intuitive interface for quick data entry with the ability to import data from CSV or Excel files. Tabular view of teachers with search and filter functionalities. Hourly and Daily Availability: Interactive calendar to set daily and hourly availability of teachers. Drag-and-drop functionality for easy time adjustments. Ability to set recurring availability (e.g., every Monday from 9:00 to 11:00). Option to add notes or comments for each availability block. Selection of loca...

I'm looking for someone to curate text and image data for me and compile it into an Excel document on a monthly basis. The successful contractor will have experience with using the Internet to collect data and be able to present it in a structured and organized manner. This data needs to be sourced from reliable sources, checked for accuracy, and edited for quality. The contractor must be able to take initiative and use their own discretion in order to create the best results. Additionally, the contractor will be expected to act in a timely manner, ensuring that the data is updated and ready to use on a monthly basis. This project requires attention to detail and good communication skills.

I'm seeking a talented designer for an education book aimed at Condominium Owners and board members. - Genre: Education - No specific concept in mind, so your creative input is valued - Target audience: Condominium Owners and board members Ideal Skills and Experience: - Extensive experience in book cover design - Ability to work with minimal direction and bring creative ideas to the table - Understanding of the target audience, Condominium Owners and board members, possibly with prior experience in this field. Title: Understanding Condominium Safety and Security in Canada Subtitle: A comprehensive guide for condo managers and resident to keep their property and residents safe Author: Scott Hill, CPP, RCM, PSP

...experienced Solidworks professional to help me design a complex mechanical product. Key Requirements: - The primary task is to model a product with detailed mechanisms and moving parts, so I need someone who is proficient in 3D modeling and assembly design. - The product is at a prototype stage, so you need to have a good understanding of product design and the ability to bring innovative ideas to the table. Please provide examples of similar work you have done in the past. This project is time-sensitive, so please only apply if you can commit to meeting the deadlines. the pictures are for reference only I want to design a machine that works similarly the the one at but it must not be the same machine, it needs to be of similar size, look somewhat different but do the

...seeking an expert in Excel, OneDrive and email notifications who can develop an automated system for me. This system needs to: - Monitor a specific Excel file within my OneDrive for business for cell value changes. - When changes occur, the system should not send an individual notification for each. Instead, it should group updates together. - These grouped updates should then be sent as a single email to a preselected set of recipients at a specific time interval. - Crucially, the email should not only contain the updated cell values but also their previous values, enabling recipients to easily compare old and new data. Only experienced Excel and OneDrive professionals should apply, preferably with a background in automated data notifications. Familiarity with han...

...extract comprehensive data and metrics essential for reporting purposes. Your primary responsibility will involve pulling detailed information from Sales, Orders, Products, Customers, and other relevant columns and sources via the API. Your expertise in navigating the intricacies of the Amazon Seller API to extract pertinent data for reporting is crucial. This data MUST be pulled into Microsoft Excel seamlessly and effortlessly. This will enable easy access and manipulation of the data for reporting purposes. The columns of data required, but not limited to are as follows: Order ID, Tracking ID, Product Name, Unit Price, Ship By Date, Deliver By Date, Purchase Date, Ship Date, Payment Method, Fulfillment Methods, ASIN, Quantities, Item Subtotals, Tax Total, Refund Total, Ship...

...form and the form will show availability for all the hours any of the linked expert calendars show available time. • Blog section - All type of Users can read, like, share on multiple social media platforms, and add comments on posts (only logged in user), - Admin: content creators can login to write and publish blogs in their desired design and format. Blog contents could be videos hosted on YouTube and other platforms • University data and pages - Admin: o can update university data in bulk using excel or other supported file formats o can update individual university data from university page (separate login for data entry operators, data is published online once validated by a proper assigned user on the admin side) - Public users (no login required) o Can ...

Write mobile responsive html code. 222 words, 4 images. Some design work needed.

I'm looking for a talented Excel expert who can create a highly interactive and visually appealing budget analysis dynamic dashboard. - Highly Interactive Dashboard: Develop a dashboard that allows users to interact seamlessly with the data. This includes the ability to navigate between different views, select specific time periods, and drill down into detailed information. - Visual Appeal: Design visually appealing charts, graphs, and tables that effectively communicate key financial metrics. Utilize color schemes, fonts, and layout techniques to enhance readability and engagement. - Monthly and YTD Sheets: Incorporate tables of accounts for 12 months and year-to-date (YTD) sheets into the dashboard. Ensure that data from these sheets can be easily accessed and analyzed wit...

...sections clearly (Heading 1 for section titles, Heading 2 for sub-sections, etc.). Header and Footer Configuration: Set up a dynamic header on each page using a table format to include: Section number and title. Document revision number and effective date. Ensure headers are accurately reflected and are consistent on every page. Include a footer with the page number, centered at the bottom of each page. Table of Revisions: Correct and update the Table of Revisions to include a log of all changes made to the document. This table should include columns for Revision Number, Date, Description of Change, and Page Number. Ensure this table is correctly linked to the content changes throughout the manual. Bookmarking and Hyperlinking: Add bookmarks for eac...

I'm in need of a detailed guide that helps individuals and businesses choose the right conference table for their office needs. The guide needs to cover the materials and styles that are suitable for different environments and purposes. Key deliverables include: - A breakdown of common materials used for conference tables (wood, glass, metal, etc.) - An outline of different styles available in the market (modern, traditional, etc.) - Recommendations on the best materials and styles based on the purpose of the table - A discussion on the importance of size in relation to the number of people the table should accommodate - Insights on how budget should influence the selection process -1000 to 1200 words - Will need to reference two links that will be provided to ...

I require a meticulous professional, experienced in the workings of Microsoft A...Solve data type mismatch errors, ensuring seamless data integration - Add some of the small functionalities to the application. - Need the full application to run smooth without errors. Ideal Skills: - Commitment to meet tight deadlines as an immediate resolution is vital - Prior experience in troubleshooting errors in Microsoft Access 2007 - 2010 - Expert understanding of database structures and Sql syntax Ultimately, the freelancer should bring this software application back to its most optimal version in the earliest possible timeframe. If you're that hands-on problem solver with a keen eye for detail, you could be just what this project needs. *Some of the sub-application the software has t...

I'm looking for a skilled developer to c...Features: - Email Verification otp on login A simple website for our team to use with login option and it should have following features A form to manually update my database A search page to search in my database (For example :- for a student databases a page to add all the details of a new student manully and a page to search for students base on sone criteria which shows the result in a table form) Ideal Skills: - Strong experience with Flask: You should have a proven track record of developing websites using Flask. - User Authentication Expertise: Understanding and implementing secure user authentication systems is a must. - Email Verification Services: Experience with integrating email verification services into websites is ...

Hi Oleh, Please change the colors of the black ottoman to the colors I attached.

I require a creative professional, with a keen taste for the minimalist aesthetic, to chart an interior design makeover for my medium-sized, 3-4 bedroom apartment. The successful freelancer should ideally have: - A strong portfolio of minimalist designs, preferably for similar apartment sizes. - Proficiency in design programs such as CAD, SketchUp, or similar tools - Ability to flawlessly inte...the utility of available space. Expectations for the project: - A complete interior design plan for all rooms in the apartment. - An interactive process where I provide feedback and approve of ideas during each stage. - All final design plans + necessary revisions for my approval. This is your chance to revamp an entire apartment space. I'm excited to see what your design skills bring to th...

I am looking to significantly revamp my home's exterior in order to increase its c...include: - Window replacement: To maintain a unified style, the new windows should complement the modern rustic look. - Addition of front dormers: Designed to integrate seamlessly with the existing structure while adding to its visual appearance. - Stone and siding: Both these elements should be curated carefully to bring the essence of the modern rustic style to life. Experienced freelancers who excel in exterior home remodeling with proficiency in modern rustic designs would be ideal for this project. Critical abilities include an eye for design, detail-oriented work, and the capability to execute window replacements and dormer additions smoothly. Previous experience working on similar proj...

5 small videos of 3 seconds each table with diferent movments and merge in a 15 seconds video for each table. total cost 185 USD as is video the cost of calculation is diferent than the images, becuase the video need from 30 to 60 images per second. TOTAL 2 VIDEOS OF 15 SECONDS

I'm looking for a professional who can help me generate contact information (name, email, and phone) for leads suitable for my direct email marketing campaign. Key Responsibilities: - Develop a robust strategy to identify and collate data from various sources. - Ensure the data is accurate and up-to-date. - Organize and present the data in an Excel spreadsheet format. Ideal Skills: - Experience in sales lead generation. - Proficiency in using data collection tools. - Strong analytical and organization skills. - Knowledge of email marketing best practices. Experience in direct email marketing or a CRM system would be a bonus. The successful candidate will be meticulous and detailed-oriented, with the ability to deliver high-quality, targeted leads to support my marketing ef...

I'm seeking an experienced LinkedIn marketer to elevate my brand's visibility and construct a robust professional network. Key Goals: - Enhance brand profile on LinkedIn to attract potential leads. - Strategize to build a strong professional network within the recruitment...Requirements: - Proven experience in LinkedIn marketing and networking is essential. - Experience with B2B marketing targeting recruitment industry. - Ability to craft engaging, industry-specific content to appeal to the target audience. - Willingness to brainstorm and implement effective LinkedIn marketing strategies. Please bring your creative mindset and out-of-the-box strategizing skills to the table. I'm looking forward to seeing actionable proposals for this project. Let's make the ...

EXCEL VBA + EXCEL EXPERT. Please check video attachment and excel file and tell me if you can do this. Quality of proposal cover letter is always #1. Be #1. This will take 1 hour to code and complete if you know what you are doing.

I'm in need of a creative graphic designer to take my existing logo and create a visually striking and colorful design for a van wrap. The prima...through the wrap. Key Requirements: - Expertise in graphic design and creating vehicle wraps. - Proficiency in creating bold, colorful and visually appealing designs. - Ability to effectively incorporate the existing logo into the design. - Understanding of and experience in product promotion through visual mediums. I'm looking for a professional who can bring fresh ideas and concepts to the table, while aligning with the overall branding of my business. Experience with similar projects or a strong portfolio in this area will be beneficial. The van is a Ford Transit Custom, 2021, Short wheel base, sliding door on left side a...

It is necessary to write a scientific article on economics

I'm looking for a data analyst to scrape LinkedIn data and create a series of analytics from the information. Linkedin Recruiter or Premium Account will be needed for this task. Output should be presented in Google Sheets or EXCEL.

This project needs a skilled professional who is highly efficient with dbt, Databricks, Snowflake, Google Cloud Platform (GCP), Python programming, and SQL database management. Responsibilities: - Execute data transformation tasks using dbt - Process and analyze data using Databricks - Handle data storage and querying on Snowflake - Manage cloud platform setup and tasks on GCP - Implement Python programming for data manipulation - Write and manage SQL queries and database Ideal Skills and Experience: - Prior experience in the same field - Intermediate level expertise in dbt data transformation - Knowledge of Python and SQL - Understanding of cloud architectures, particularly Google Cloud Platform - Familiarity with Snowflake and Databricks Applicants ...

Having problems with Docker and need configurations 1 - 3 current running containers need proper ports assigned to them. The containers connect be lost as they are for production. 2 - set up and configure three additional separate Docker groups, each for a different entity which would contain sql, Apache, and file storage. Key Requirements: - Configure 3 isolated Docker groups for Entity A, Entity B, and Entity C isolated from each other. - The setup should be designed for scalability, load balancing, and security although specific requirements for each are not yet defined Ideal Freelancer: - Proven experience in Docker containerization - Familiarity with setting up and managing production environments - Strong understanding of port assignment and management - Capability f...

I need a simple C# Windows Forms management project. It has three classes: Service, Tourist and Tranzactions. It's for college and supposed to be for a tourism agency wanting to keep track of its services, tourists and tranzactions. Nothing complicated, a CRUD app connected to a SQL database, simple UI and the project has to meet the requirements from the screenshot attached below.

I need a redesign for the header part only, of my website, see the attached site image and logo for know the color scheme! The header is divided into 2 rows : The first row is the logo and buttons 2nd row is the menu! So I need a nice design of the first row (logo and buttons) and 2nd row (menu) , which good match with my website.

I require proficient excel skills to create two distinct spreadsheets. The first spreadsheet should focus on an immediate expense breakdown, specifically highlighting repair costs as an individual category. Knowledge in business accounting would be advantageous to ensure accurate representation of financial data. The second spreadsheet requires a CAPEX table, based on an example I will provide in PDF format. Freelancers will ideally have: * Expertise in Microsoft Excel * Background in accounting or financial planning * Detail-oriented and able to follow a provided example * Ability to create easy-to-understand, visually appealing spreadsheets Please assure that the work is precise and completed on time.

I'm in need of a skilled WordPress developer who can create a plugin from scratch. This plugin needs to provide a specific fu...manage at backend with no more than 15 fields. Key Requirements: - The plugin should not be based on any existing WordPress plugins. It must be custom-built. - The plugin is just for backend, no frontend function is to create, only need to build plugin that creates admin side functions like add, edit, delete, list view, detail view, etc info of given fields, and all info is to save in one separate table only. Ideal Skills: - Proficient in WordPress plugin development. - Strong understanding of PHP and JavaScript. - Experience with custom plugin development is must. Please note: I will provide more details about the specific functionality to shortlis...

I am in need of a proficient Google Sheets wizard who can utilize their expertise in managing and modifying spreadsheets for a specific task. I am interested in adding dynamic drop-downs to the cells in the ranges A1:A1000, B1:B1000, and C1:C1000 in Google Sheets. Key aspects for my project include: - Dynamic Population: These drop-downs must be dynamically populated and each row should maintain its independence from other rows. - Dropdown Values: The values for the initial dropdowns (A1:A1000) are derived from a specific list on Sheet2 of the Google document. - Manual Updates: The values on Sheet2 will be updated manually by the user. The perfect candidate should possess the following skills: - Advanced knowledge in Google Sheets: You must be able to easily navigate Google ...

...to ensure that our website is consistent with our brand identity, and that it effectively communicates our values and mission. Key requirements: - Proficient in Figma: I need a designer who is comfortable using Figma for web design. - Experience with performance marketing: It would be beneficial if the designer has worked with similar agencies in the past, and can bring that experience to the table. - Strong understanding of user experience design: The ideal candidate will have a proven track record of creating user-friendly and engaging website designs. Please provide examples of your previous work, particularly any experience with performance marketing websites. Your ability to understand and implement marketing strategies through design will be crucial to this project

...existing Excel VBA project that interfaces with AutoCAD 2020. I'm looking for an experienced VBA developer to update the current functionality. Key Requirements: - This project involves updating an existing Excel VBA tool that works with AutoCAD 2020. The tool is currently used to generate data in Excel extracted in AutoCAD drawings what can be easy changed and send back to the relevant Drawings. You will be required to maintain the current functionality while also enhancing its capabilities. - The existing tool is aimed at automating the process of generating Excel data from AutoCAD drawings based on. The updated version should be user-friendly, and should ideally also allow for some form of automation of repetitive tasks within A...

- Merging Persons Records on a Single Table - Fixing some bugs - Displaying "merge company" interface instead of the expected "merge person" interface - Merging Persons Records on a Single Table - Displaying the listed fields on merge person CRM section - Add a "Date-Added" field to CRM records for FirstPrint project. - Update image on CRM Instruction page for FirstinPrint project - Update the Input field and other Issues in the FirstinPrint project

I need someone to consolidate data from multiple Excel sheets. The data in these sheets consists of both text and numeric values. The goal is to bring all this data together into a single sheet, while handling duplicates in a distinct manner. Key elements of the project include: - Merging text and numeric data from several Excel sheets into one - Handling duplicate entries by marking them without removing - Organizing the data by grouping it as per the provided sheets separately Ideal candidates should have: - Proficiency in Excel and experience working with data consolidation - Understanding of handling and marking duplicate entries if any - Ability to accurately organize and group data Your task will be to create a consolidated view of text and numeric data from t...

Hi Work-Nix Solutions, I would like to work with you again please on refining the great Excel-spreadsheet that you have helped me to build.

Hired already client is aware of details

I'm in need of an Excel developer who can aid me in analyzing data, creating advanced formulas and functions, and programming macros. With your expertise, the primary goal is to develop an Excel file that will be used to generate various reports. Ideal Skills and Experiences: - Proficient in Excel data analysis and manipulation - Experienced in creating advanced formulas and functions - Able to implement macro programming - Adept in generating insightful reports from complex data Our goal is to provide you with an exportable dashboard in Excel, a tool that will efficiently display opportunity details per property and provide a dedicated area for your notes. Opportunities that meet the threshold should display the value. The dashboard should be sortable a...

Please Sign Up or Login to see details.

I am in need of a Senior Financial Analyst to assist with our company's financial modeling, forecasting, and data analysis and reporting. The ideal candidate must be familiar with various financial concepts, data analysis, and proficient in the use of Microsoft Excel, Tableau, and QuickBooks. Key Responsibilities: - Develop and maintain financial models for our operations and future forecasts - Analyze and interpret financial data - Prepare regular reports on financial performance - Utilize Microsoft Excel, Tableau, and QuickBooks for data management and analysis. The candidate must have significant experience in financial modeling and data analysis, preferably in a senior role. The ability to communicate complex financial information in a clear, concise manner is hig...

I'm in need of an experienced CodeIgniter developer to help with a variety of tasks. Key Responsibilities: - Front-end Development: You'll be responsible for designing and implementing the user interface of our web application. A strong grasp of HTML/CSS, and Bootstrap will be crucial here. - Back-end Development: You'll also be involved in developing the server-s...features or functionalities you think could enhance our application. Ideal Skills: - Proficient in PHP, Laravel, JavaScript, HTML/CSS, and Bootstrap - Strong knowledge of CodeIgniter framework - Experience with integrating databases in CodeIgniter - Understanding of user interface design I'm looking forward to working with a dedicated developer who can bring their expertise and creativity to the tab...

I'm looking for a talented and experienced freelancer to design a Figma POS system exclusively for a night club. The POS system will need to include the following key features: - Table reservations management: The system should allow us to efficiently manage table reservations, both in advance and on the night. - Menu customization: It should accommodate easy customization of our menu, reflecting our diverse range of drinks and food. - Song Queue: The system should have an integrated song queue, allowing patrons to request their favorite tracks. Payment methods to be integrated: - Cash payments: As a night club, we deal primarily in cash, so integrating this payment method is crucial. The

I'm in search of an individual who is both tech-savvy and creative, capable of designing and editing an Excel-based yearly budget tracker for my department. This document must not only be functional, but visually appealing, making use of our company's branding and in a way that ensures user-friendliness. Key Requirements: - Creating a Comprehensive Tracker: I need a budget tracker that can calculate data and maintain it in a clear and organized manner, reflecting both incoming and outgoing finances. - Visual Appeal: This tracker should not be a typical, boring spreadsheet. It should feature vibrant colors and bold fonts, while still maintaining a clean and simplistic design. Additionally, it should incorporate our company's logo and color scheme to ensure it's o...

...Detection In terms of output, I require the processed videos to generate a Metadata file, which ideally is formatted into an Excel or CSV file. This data should include details such as date, time, classification, and direction. While I do have an Azure account for hosting and I am comfortable with it, I am also open to suggestions on which programming language would be the best fit for this project. The ideal freelancer for this task should possess the following skills and experience: - Proficiency in Python, C++, or Java - Familiarity with Microsoft Azure or similar - Experience in image classification and object detection - Ability to create Metadata files in Excel or CSV format. Remember that while these are the core requirements, I am open to suggestions and m...