I know the numbers on your picture are not steps - but WHAT ARE THE STEPS! I can't help and write code if you don't have rules for the data to be handled - you pictures are no help, because I have no idea what the data shown is, nor what you want it to do - how then am I to help???

What I'm trying to point out is that your original post is not clear enough in the details for me to be able to understand what you want - I'm asking that you clarify it for me so that I can see if I can help.

Please see my previous post, and try to use a similar format to state the rules that you are trying to follow - If you can provide that information, I can maybe try to help you - without that information, I don't see how I can, sorry!


Let me give you an example of what I mean:

From the images you posted I will use the example of (1) - I can see that you want the last part of Cell A to be moved across to the Word document. I can do that because I can see it. But, how am I to tell Word and Excel to recognise that?

Cell A145 = Igerc - [Ravne na Koroskem-Center Ravne] - You want to see ONLY [Center Ravne] moved to the Word document.

Cell A148 = [HOTEL DIANA 100kg] - What, if anything, is going to move from this cell? - How am I supposed to know that? How is EXCEL supposed to know that?

So by what rules do you want to move [Center Ravne], but NOT [HOTEL DIANA 100kg]? OR do you WANT to move [HOTEL DIANA 100kg]? Is there something that shows excel that the cell contains valid text for the move (a special character, for example)? Or maybe you only want cells with [Center Ravne] to be included in the move, and so all the rest can be ignored!

Please remember that none of us here has any idea what this data relates to, nor how it is all supposed to work! You MUST be clear and detailed in your wants and needs if you want us to be able to understand and respond!

I hope this helps clarify things, and that you can now clarify things for us!