Ok, let me explain..
In the sheet last tab (Local stockfile) has all the items (SKUs) they sell and cost and Retail prices.
Column A and B shows their departments and fine lines respectively.
3 rd tab (Trade01-06 Matrix extract) tab is the download of pricing discount structure. If you filter
column A you can see 6 types of Matrix IDs.
For example of if you just filter by column A by TRADE01.
First from row 4 to 21 shows department discount structure
From row 22 to row 50 shows Fineline discount structure
Row 2 and 3 applies for all the items (skus).
2 nd tab (SKU check) is the ideal report im after. Basically when you enter Item (SKU) numer in cell A3
it shows all the discount structures, Column C to column P returns corresponding data from tab 2
(TRADE 01-06 Matrix extract). Sorry order in my sketch report tab (SKU Check) is not the same,,but
im basically after the same information.
Ignore columns from Q to Y in SKU check tab. This is to determine calculate best price depend on the
price basis, I can design this part.
If you can help me out to design what im after that would be great.
Let me know if you have any questiions.
---
cell I4 (best price) & J4 (GP%) is the best sell rate (column X) depending how many combination of matrices that item (SKu) has..Column Q to W you dont need to worry,
Hi, I have seen your proposal. I am an excel expert with very good knowledge of formula and VBA. I can make this Matrix Compare Report for you.
Please come on chat for more details.
Awaiting your response.
Thank you.
$30 USD në 1 ditë
4,3 (40 përshtypje)
4,5
4,5
10 freelancers are bidding on average $25 USD for this job
I am a highly trained in Data Entry, Research, Web search, Web scrape, great knowledge of Excel and all Social Networks. My bid is optional and I will let you chose the price that suits you best!
Dear Mrs/Mss,
I'm working with BI-matrix report everyday and good at VBA , i would like to chat over to know detail what you expect the result, i can give the expected result as well as you want. Thank you!