SQL - Excel Macro

40.0 GBP

40.0 GBP peopleperhour 技术与编程 海外
6天前

详细信息

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

免责声明

该外包需求信息来源于站外平台，本站仅提供公开信息部分字段展示与订阅服务，更多请查看免责声明。

立即前往
关注公众号,不定期副业成功案例分享
关注公众号

不定期副业成功案例分享

想领先一步获取最新的外包任务吗？

立即订阅

类似推荐

We require a developer to assist with the following When a user searches in the search bar on our website, the search results returns a blog page, opposed to a search listing page Blog page - https://new.tonebay.co.uk/?s=epiphone Search listing page - https://new.tonebay.co.uk/search/ The theme we are using is the Vehica theme https://themeforest.net/item/vehica-automotive-dealership-wordpress-theme/28437452?gad_source=1&gad_campaignid=20946799167&gclid=EAIaIQobChMIltaXh7SljQMVDpRQBh05PAZ2EAAYASAAEgK4S_D_BwE We are also using a fast search plugin called Super Speedy Search, which returns the results, this is set up to only search for listings, so the issue is the template being called when someone hits Search If you can do this please get in touch. Thanks
15.0 GBP 技术与编程 peopleperhour 海外
18小时前
We are a digital agency and we have out own team but we do not specalise in Shopify and this client wants a shopify website, this is the spec and scope of work: Scope of Work – Shopify Store Setup This project includes setting up a complete Shopify store for you. Here’s what’s covered: • Theme Setup: install and set up any theme the client likes whether it’s a free one or a premium one they have chosen and bought. • Fully Built Store: store will be fully developed and ready to use, not just a template. • Speed Optimised: make sure clients store loads quickly on both mobile and desktop devices. • Homepage Design: design a homepage that reflects cleints brand and makes a good first impression. • Content Pages: set up all the key information pages customers website o About o Our Story o Contact o Shipping Info o Terms and Conditions o Privacy Policy o Returns, etc. • We will provide Content created with SEO in mind for the above pages. • Product Upload: upload up to 100 products (we will provide the following) including images, descriptions, and pricing. • Categories: organise client products into main categories and sub-categories, based on what makes sense for clients shop. Client should have as many as they need • Homepage Slideshow: design a slideshow or banner on the homepage (for offers, featured products, etc.), . • Shipping, Tax & Payments: configure the backend settings so that shipping rates, taxes, and payment methods are set up properly and ready to go. • Menus & Navigation: set up your menus so visitors can easily browse your site. • Social Media Links: your social media accounts to your shop (like Instagram, Facebook, etc.). Website needs to have a high end design finish and optimised for conversion. This is ongoing work as client will want regular updates and support and if the project goes well we shall also then begin to sell shopiy websites in turn coming to the successful developer. The client likes a similar quality to this site https://www.tropicanawholesale.com/, a full breifing shall be issued to keep things simple
400.0 GBP 技术与编程 peopleperhour 海外
1天前
Project Overview We maintain a live pricing feed in an online Excel/Google Sheets file and need a seamless solution to: Detect Changes immediately when the source file updates. Copy & Rebrand into our own spreadsheet (logos, headers, formatting). Apply a 15% Mark-Up to all price cells (configurable). Keep Everything in Sync—new rows, removed items, renamed columns—every time. What You’ll Deliver Automated Watcher: A trigger or cron-based solution (Google Apps Script, Power Automate, Python, etc.) that fires on file-change or on a schedule. Branded Copy: A live copy of the source file in our workspace, complete with our branding and formatting. Data Transformation: +15% mark-up applied to every price cell, with numeric precision and configurability. Robust Sync Logic: Handles additions, removals, renamed columns, and intermittent API errors. Notifications & Error-Handling: Alerts via email or Slack only if a sync fails. Documentation & Handover: Clear setup guide covering deployment, parameter tweaks, and ongoing maintenance. What You’ll Deliver Automated Watcher: A trigger or cron-based solution (Google Apps Script, Power Automate, Python, etc.) that fires on file-change or on a schedule. Branded Copy: A live copy of the source file in our workspace, complete with our branding and formatting. Data Transformation: +15% mark-up applied to every price cell, with numeric precision and configurability. Robust Sync Logic: Handles additions, removals, renamed columns, and intermittent API errors. Notifications & Error-Handling: Alerts via email or Slack only if a sync fails. Documentation & Handover: Clear setup guide covering deployment, parameter tweaks, and ongoing maintenance. Skills & Experience Solid experience with Google Apps Script or Microsoft Power Automate or Python (using Google Drive/Office 365 APIs) Proven track record of building reliable, change-driven workflows for Excel Online/Google Sheets Expertise in data transformation, error handling, and API-based automation Strong communicator in English, with proactive troubleshooting and clear documentation Timeline & Budget Start: Within 3 business days of award Delivery: Fully deployed and tested within 1–2 weeks Budget: Please quote your hourly rate (or fixed price) and an estimated total
252.0 GBP 技术与编程 peopleperhour 海外
2天前
Background: we have an existing site: cambridgelawstudio.co.uk the site is built using a bespoke theme and Elementor Pro this project is to focus only on LearnDash as an LMS and we are not looking at any other updates such as aesthetics or other functionalities on the site Project goal: Create an LMS (learning management system) using LearnDash Core objectives: 1. Tutors/Teachers/Instructors can sign up to be approved onto the platform; can upload their own course material and manage their own calendar and payment rates. 2. Students to be able to search for a suitable approved Tutor/Teacher/Instructor on the platform; check the tutor’s availability on their calendar and book in a one to one lesson with them. Core functionalities to include: - tutor (instructor) registration option (tutors are vetted prior to be given access to the platform) - 8 x courses for site Visitor to be able to search with results listing tutors that provide that course - tutors can provide more than one course - tutors that pass the vetting process, become listed tutors and create their own calendar and course materials - possibly payment options - students choose tutors and interact directly with them - additional considerations to include but not limited to, any payment gateway options Additional: - a DEVELOPMENT site will be used BUT no dashboard access will be provided prior to awarding the project - LearnDash and Elementor Pro licenses will be in place - the current developer who supports the site will be available to answer any questions - we like the search option like on this site: https://preply.com/ Search functionality: https://preply.com/en/online/english-tutors - we like the results profile for teachers as on this site: https://theenglishfarm.com/ Search results and presentation: https://theenglishfarm.com/teachers So we can consider the best candidates, from the information provided, proposals should include: - previous LearnDash successes and you should provide URLs to sites you have completed that use LearnDash as an LMS - advise how you would approach a project like this and incorporate any challenges you believe may need overcoming and how you would overcome them - your proposed cost even if it is higher than the indicative budget - your expected timeline
215.0 GBP 技术与编程 peopleperhour 海外
20小时前

HuntsBot(狩猎机器人)，一站式外包任务、远程工作、产品创意分享与订阅平台，支持钉钉、飞书、企业微信、邮箱、Telegram机器人订阅。平台会以及时、稳定、可靠的技术把外包任务需求、远程工作机会、产品创意等推送给每一位订阅的用户。

简体中文 English

平台

支持

友情链接

联系我们

在使用过程中有任何问题或建议，可以通过以下方式联系我们：

微信公众号: 火星来客

Email: huntsbot@xinbeitime.com

Copyright© 2022-2023 www.huntsbot.com 浙ICP备2022000860号-4 All Rights Reserved.