Macro in Excel
- or -
Post a project like this1475
£80(approx. $100)
- Posted:
- Proposals: 13
- Remote
- #2754240
- Awarded
Excel VBA, MS PRoject Expert, Web Scraper, Arena, Simulation, Spreadsheet, Wordpress customisation
Istanbul
Virtual Assistant | Web Research Specialist | Excel | Fillable / Editable PDF |Data Mining Specialist |Data Extraction | & Project Coordinator
Cairo
Excel Macro/VBA Automation, PDF Conversions, Fillable PDF Forms, Data Scrapping, Data Entry
Bhaktapur
Excel | Google Sheet | User Interface | Web App | Data Scraping | Internet Research | Photoshop Service
Jakarta
Trusted CRM Consultant and Data Automation Expert. Automating your business, designing your future!
Mumbai
694576871571300449178829020629462325100242805426125852642406288970837211203819976
Description
Experience Level: Entry
We need someone to create a system within Excel where it uses information for a price list we have already. Using the next sheet/tab on the file we would like to create bundles for our product range. This new page will allow us to give this bundle a name and then we would input the SKU and QTY of the products included within this bundle (max of 10 SKUs should be fine).
We would create many bundles so it needs to be in a readable format and easy to look down to check the bundles for reasons which will follow.
It would take all the items in the bundle and the qty of each item and add up the cost price (colume N) from our main list - then a column would work out that cost price + 40%+Vat for a guide of bundle sale price. Another column would allow us to input manually the actual sell price for that bundle and next to that a column would work out GP% based on that manually entered price Vs cost (cost is excl VAT so it has to take that in to account as our sell price is incl vat).
The clever bit is that in our main list we have two possible price columns - column F is what we call street price - and always has content. Then column I has Web price and this is where we put the price for a product if we are price matching on our website. The hard part is we want the spreadsheet to work out our manually entered sale price of the bundle Vs the actual price on our website (which is column I added together for the items - but when there is nothing in that cell, it is column F and some of the products in the bundle will have a price in both columns, but other items might not have anything in column I).
As prices are being changed daily - we want a red colour or something to indicate if the bundle price is ever more than the web price of all the items individually - if that makes sense. So we could visually check the bundles regularly to monitor them quickly so we never sell a bundle at more than you can buy everything on their own.
On top of that visual check for the price – we would also need to be able to spot any bundle where we have removed an item on our main price list that is included within the bundle – for instance if a product is discontinued then we would delete that row the product is in on the main price list.
We would create many bundles so it needs to be in a readable format and easy to look down to check the bundles for reasons which will follow.
It would take all the items in the bundle and the qty of each item and add up the cost price (colume N) from our main list - then a column would work out that cost price + 40%+Vat for a guide of bundle sale price. Another column would allow us to input manually the actual sell price for that bundle and next to that a column would work out GP% based on that manually entered price Vs cost (cost is excl VAT so it has to take that in to account as our sell price is incl vat).
The clever bit is that in our main list we have two possible price columns - column F is what we call street price - and always has content. Then column I has Web price and this is where we put the price for a product if we are price matching on our website. The hard part is we want the spreadsheet to work out our manually entered sale price of the bundle Vs the actual price on our website (which is column I added together for the items - but when there is nothing in that cell, it is column F and some of the products in the bundle will have a price in both columns, but other items might not have anything in column I).
As prices are being changed daily - we want a red colour or something to indicate if the bundle price is ever more than the web price of all the items individually - if that makes sense. So we could visually check the bundles regularly to monitor them quickly so we never sell a bundle at more than you can buy everything on their own.
On top of that visual check for the price – we would also need to be able to spot any bundle where we have removed an item on our main price list that is included within the bundle – for instance if a product is discontinued then we would delete that row the product is in on the main price list.
Darren L.
100% (35)Projects Completed
31
Freelancers worked with
13
Projects awarded
12%
Last project
17 Apr 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies