Log In
Register
Home
Active Member
August 11, 2020
Offline
Hello..
I have sets of data which needs to be migrated as one...
First data -- The List of Products & the Discount IDs (Here Product codes are unique & each product will have one Discount ID. But Discount IDs are not unique one discount ID can be shared with multiple Product codes)..
Second data -- The Discount IDs list along the multiple quantity ranged tiered discounts..
I need to VBA tool which converts the above data into the Product code with Discount IDs list along the multiple quantity ranged tiered discounts..
attached the example format - where sheet 1 (data_1) and sheet 2 (data_2) are my input and Expected Result is pasted in Sheet 3..
Hope someone can help to get tool to get this done
My E-mail ID: [Removed by Admin]
Thanks
Girish
October 5, 2010
Offline
Hi Girish,
No need for VBA, use Power Query.
The attached file does what you want.
regards
Phil
P.S. I removed your email address. I you post your email on websites you're going to end up with lots of spam.
Active Member
August 11, 2020
Offline
Thank you.. Surely I will go throuh the Power Query.. But I am looking for urgent solution.. A tool with commond button which gives me expected result with a click of button.. with the input which I have on first two sheets... Its needed for bigger data than explained in example format..
Thank you
Regards
Girish
October 5, 2010
Offline
Hi Girish,
Power Query does exactly what you describe and you don't need to do any coding. And it works for data that you add to the table at a later time, you just refresh (re-run) the query - with the click of a button.
This is a classic example of asking for something to be solved in a certain way, when there is a better solution. Why does it have to be VBA?
You say that this is urgent but there are 2 days between your initial post and your reply. In that time you could easily have learned what you need, to understand how Power Query solves your problem.
I strongly encourage you to read our Power Query posts and use it. Start with the oldest ones and work through.
Regards
Phil
Active Member
August 11, 2020
Offline
Hi Phil,
Yes I went throuh the Power Query posts . but this mostly talk about only the file with commont heading in different sheets or files.. but my data is not having the common headers.. also One data is having Product code as Unique feature. and in other data no unique IDs... So I couldn't get this though power query.. if you have any specific video which cover this topic please share..
Thanks
Girish
1 Guest(s)
