SQL - Excel Macro

40.0 GBP

40.0 GBP peopleperhour Technology & Programming Overseas
6 days ago

Description

Hi Hope you are well.I have an excel with a Macro that links to SQL and does some calculations using 3 tables of data in SQL and then keeps the data in SQL in a new table.1. this macro has stopped working due to "ADODB.Recordset" issue.2. the macro produces monthly account balances from inception to now and I would like to adjust this to be based on a start date and not all of the history.If you believe you can help with these two issues can you please let me know.Many thanksRobert

关注公众号,不定期副业成功案例分享
Follow WeChat

Success story sharing

Want to stay one step ahead of the latest teleworks?

Subscribe Now

Similar Teleworks

I’m looking for an experienced Shopify developer to build a complete vape eCommerce store for the UK market. The store must be visually appealing, mobile-friendly, and fully compliant with UK laws for selling vape products. You’ll be responsible for setting up and customizing the store, integrating age verification, configuring a suitable payment gateway, enabling bulk pricing, and applying basic SEO. What I Need: • Full Shopify store setup using a fast, modern theme • Homepage, product page, and collections customization • UK-Compliant Age Verification: • Entry popup: “Are you 18 or over?” • Integration with VerifyMyAge or similar solution • Redirect or restrict access for underage users • Payment Gateway Setup (UK vape-friendly — not Stripe or PayPal) • Bulk Pricing Setup: • Discounts based on quantity (e.g., “Buy 3+, save 10%”) • Visible pricing tiers on product pages • Can be done via Shopify apps or custom code • Basic on-page SEO (titles, metadata, product tags) • Legal pages (Privacy, Returns, Terms, etc.) • Contact page or contact form • Store optimized for mobile and speed • Optional: newsletter signup, loyalty rewards, or promotional popups You Should Have: • Proven Shopify experience with vape or high-compliance stores • Knowledge of Liquid, HTML, CSS, JavaScript • Experience with age verification tools like VerifyMyAge • Familiarity with bulk pricing logic and apps (e.g., Quantity Breaks, Volume Discounts) • Understanding of UK eCommerce compliance • Good communication and ability to meet deadlines To Apply: Please include: • Links to Shopify vape or regulated stores you’ve developed • Experience with age verification and bulk pricing features • Your preferred approach to implementing tiered pricing • Payment gateway suggestions for UK vape businesses • Your availability and estimated completion timeline
1500.0 GBP Technology & Programming peopleperhour Overseas
1 days ago
We’re hiring an automation specialist to join the Estately Team. The initial task is an automation project to optimize our outbound SMS response and booking flow using GHL, Make.com, ChatGPT, and Slack. Your main task will be connecting up a make blueprint of the system already provided to our slack and GHL account. This is an initial task and we would like to have someone fulltime to work on the automation side of the agency. Project Budget: $300 (Fixed) Estimated Duration: 3 Hours (Live Setup via Zoom) About the Project: We send thousands of SMS messages daily to real estate agents offering our lead generation service. We need an expert to automate the follow-up and booking process using our existing tools. You’ll be responsible for: Using Make.com to connect ChatGPT and generate natural, structured conversations that lead to calendar bookings. Pushing finalized conversations into a Slack channel for approval. Enabling Slack approvals to auto-book meetings on a GHL calendar. We provide: A Loom tutorial of how the system already set up from another company A Make.com blueprint of the other companies existing automation flow Requirements: Experience using: ✅ GoHighLevel (GHL) ✅ Make.com ✅ Slack ✅ ChatGPT Ability to work live via Zoom for 6 hours and ensure it’s fully operational. Strong understanding of chatbot logic, automation, and natural language integration. If you're: Detail-oriented and tech-savvy Confident in automation flows and API integrations Experienced with marketing automation tools If this task is performed well we are looking to optimise a lot of our systems with AI and in need of a specialist full time! Apply Now and we would love to work with you on larger projects in the future building things from scratch! Apply here: https://forms.gle/TVivpr6Tqu4pE8F6A We're hiring immediately—don’t delay! The Estately Team
250.0 GBP Technology & Programming peopleperhour Overseas
1 days ago
We’re looking for confident, experienced freelance trainers to deliver live online crash courses in topics like: AI in Business & Automation AI-Powered App Development (No-code / Low-code) AI for Data Collection & Analysis Content Creation with AI Tools ChatGPT for Business Growth Who This Is For: If you’re a data scientist, automation specialist, AI educator, or hands-on tech builder who loves helping others apply their skills in practical ways — we want to hear from you. You should be confident leading interactive, live Zoom sessions and be able to explain technical topics in a way that’s clear, useful, and easy to follow. What We Offer: ✅ Flexible, freelance-based online delivery ✅ Courses are short (6–7 hours total, taught in one day) ✅ Small-group format (max 6 learners per session) ✅ Content provided or co-developed with you ✅ Fixed pay per session + optional bonus model ✅ Future collaboration opportunities Who Our Learners Are: Startup founders, marketing professionals, creative freelancers, and small business owners — many with no tech background, eager to learn AI in a fast, accessible format. Ideal Skills (any of these): Experience teaching AI, automation, or data topics Familiar with tools like Zapier, Notion AI, Streamlit, GPTs, Power BI, Tableau, Make.com, n8n, Colab Bonus: coaching, tutoring, or online facilitation background How to Apply: Please include: Your focus area(s) Your availability A sample project, outline, or training snippet (if available) Your session rate or rate expectation (we typically pay per session) We’re building something fresh, flexible, and high-impact, and would love to have you on board!
250.0 GBP Technology & Programming peopleperhour Overseas
1 days ago