Forum Discussion
Fairly new excel question
HeatherK Can almost follow you! But, could you upload your workbook (or part of it, without any confidential information). Would make it a lot easier to help.
Riny_van_Eekelen Ok. So on sheet 1 is the master copy of all the products/codes for each. One product and multiple codes associated.
2nd sheet is the database export, where it tells me codes are missing for those certain products. However, it's not just one code - I need to find those products from sheet 1, and ensure each code is aligned with that on sheet 2. I am separately going to get all this data imported back to the database we use.
HeatherK I attach your workbook with a (not very elegant) solution. It's a three step process where you (1) identify the missing codes, (2) insert rows and copy/paste and (3) copy and paste the end result as values. I added som fake codes, to the Master to be able to demonstrate.
It all depends on how often you would need to do this and how many missing codes you have. If this is a one-time effort or to be performed infrequently and with not too many missing codes that have to be matched with many products in the Master, I could certainly live with this one, and avoid investing time in an automatic approach.
Otherwise, VBA (or perhaps Power Query) could offer a better solution. VBA requires a bit of programming, but I haven't gone so far yet. Power Query is something I can not help you with. I'm working on a Mac and the functionality is, unfortunately, not available on that platform. But, there are several contributors in this forum who are very good at it. Perhaps they can give it a try.
Riny_van_Eekelen hi yes, exactly that! I really appreciate your help, enjoy dinner! 🙂
HeatherK Do I understand correctly that e.g."Hillbrush - Banister Hand Brush 317mm Medium" could have 4 colour codes in your master list (although they are not in the example you provided). And you would want to find all these codes and expand the "missing codes" list for this product so that it shows 4 rows "Hillbrush ......." each with a different colour code? Sorry, if I'm slow. Approaching dinner time in my part of the world. Will be away for the evening.