EXCEL V12LOOKUP

175.0 GBP

175.0 GBP peopleperhour Technology & Programming Overseas
2 days ago

Description

I have a product range from which I make kits containing various products from the range but the kits all vary in contents.
I am seeking a skilled individual to create a bespoke Microsoft Excel workbook that will help serve as a Master Sheet, and separate working Microsoft Excel workbooks which are data connected to the Master Sheet.
Please see the clear requirements below:
1: I want a Master Sheet created that contains all the products complete with SKUs, and various levels of pricing i.e. A: List Price, B: Distributor Price, C: Training Price, D: Cost Price.
2: I then want to be able to simply create Kits on another Excel sheet by using the Master Sheet.
3: If I delete products from the Master Sheet it deletes the same product on all the other sheets. If I change a price on the Master Sheet it updates all prices.

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

Success story sharing

Want to stay one step ahead of the latest teleworks?

Subscribe Now

Similar Teleworks

I am redesigning a website, which will be built on WordPress, and require help with Web Site Integration to an Estate Agency CRM from Acquaint (Bright Logic) https://www.acquaintcrm.co.uk/default.aspx Overview: The following document provides details of the interfaces available for displaying properties uploaded to the internet using Acquaint CRM. 1. XML Files downloaded from a hosted URL 2. XML Web Service 3. HTML Pages via Querystring/Form Post Please note that once customer authorisation has been received a detailed specification will be made available to you. 1 XML Files These are a pre generated XML files which are automatically created when customers add or change properties. They are created at 15 minute intervals between 8am to 8pm and hosted on our servers. Please note this feature needs to be enabled on a per client basis. If you require the XML files please contact us. You would download the XML files and use them to populate your own local database. Your local database would then power your website. If you are developing your web site using WordPress or Joomla there various 3rd party plugins available to process / import XML files. 2 XML Web Services This is a very flexible means of obtaining data, however the technology does require programming skills to implement and a web development environment that allows the consumption of web services (e.g. ASP.NET, php) The web services simply return XML data strings, leaving the display and processing completely up to the web developer. Please note that you can either make a live connection from your web site to the web service, or use the web service to populate your own local database which then powers your web site. If you are making a live connection then you should ensure that your code is able to trap for and process any errors returned by the web service. This could include the web service being off line for maintenance. Please advise if you need more details? Can you help? Many thanks Andrew B
250.0 GBP Technology & Programming peopleperhour Overseas
5 hour ago
I need a autocad coder who can create a plug-in code. Create a Polyline: Enable users to sequentially select points to create a polyline with horizontal and vertical segments. Dimensional Labeling: Automatically provide the dimension for each segment in a feet/inches format (e.g., 10'-5") near the endpoint. Sequential Endpoints: Label each segment endpoint with a numeric identifier in sequence. Dynamic Polyline Length: Display the running total of the polyline length alongside the drawing area as segments are added. The goal is to accelerate dimensional polyline creation and analysis for layout and construction documentation within AutoCAD, thus improving efficiency and accuracy in your drafting process. My Approach: I will develop the plugin with the following key functionalities: Polyline Creation and Segment Identification: The tool will allow the user to click points in sequence to form a polyline with only horizontal and vertical segments, ensuring ease of use and accuracy. Dimensional Labeling: Each segment’s length will be dynamically displayed in feet/inches format (e.g., 10'-5"), positioned near the endpoint for easy reading. Sequential Numbering: Every endpoint of the polyline will be numerically labeled in sequence, providing a clear visual reference for your workflow. Dynamic Polyline Length Tracking: As segments are added, a running total of the polyline length will be continuously displayed next to the drawing area, providing real-time feedback. Integration with AutoCAD Workflow: I will ensure seamless integration with AutoCAD’s existing environment, ensuring the tool is intuitive and doesn’t disrupt your drafting workflow. The plugin will be built using either VBA or .NET based on your preferred solution for optimal performance and compatibility. Deliverables: A fully functional AutoCAD plugin based on your requirements. Clear instructions on installation and usage. Ongoing support for bug fixes or minor tweaks after delivery.
20.0 EUR Technology & Programming peopleperhour Overseas
2 days ago