Hello,

I could use some advice on the following:

I have a parent file out of which I copy data into multiple child files, using vba. The files contain our company's articles and are used as stock lists for different languages and price categories. As my colleague, who has no knowledge of vba, regularly wants to add rules (new articles) to the lists, I have stated the ranges that are to be copied and pasted in cells that are called by the macro so that they can be changed manually. For child a, b and c I copy one range out of the parent file, for d and e I copy 2 ranges out of the parent file.

Now my colleague wants to add a csv file to our system as well. The 'problem' with this file is that there are items in it that the other lists (including the current parent) do not have and that there are no blank lines between article groups (which the other lists do have). I have thought about making the csv file the parent, by adding the missing items to the other lists as well and hiding the rules. This would however mean that I have to copy/paste 28 different article groups in to the child files. And also, that I have to specify the ranges of these groups into cells so that my colleague can alter them when she adds lines (articles). I guess that when she adds a line to one group, all the succeeding article group ranges have to be altered as well? And this for every child list... Making the csv file a child of the current parent file would mean doing the same thing with the 28 article groups, but for one list only.

There must be an easier way to do this, at least I hope so. I could use some input

Thanks!