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,
11 freelancere byder i gennemsnit $25 på dette 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!