|Please take the following in the spirit it is intended:|
Do you now see why I kept asking for more details related to your requirements?
VBA code can't "guess" at anything. It has to be very specific to the actual layout of the worksheet as well as specific to the process that the user has set up.
Earlier you said:
"So I basically only want to cut paste rows containing "country" and "juice" or "water" - no other assumptions."
We now know that there were assumptions that had to be made and that those assumptions were wrong.
For example, you posted example data that led us to assume that you had country names in a column. You don't. You have formulas in a column. As far as VBA is concerned, those are 2 very different things. Had you mentioned that earlier, I would have offered different code.
You also said:
"Would there be a macro in the way "If Italy and Juice" cut paste whole row in a different workbook? "
In reality, that's not what you want. What you want is the values from the row to be pasted. Had you mentioned that earlier, I would have offered different code.
"We also have no idea how you will specify the criteria that the code will search for. Will be entered in cells? Will be entered via InputBoxes? Will it be hard coded into the actual macros?"
You never answered that question, however you are now asking "3. Saying I would like to add more countries than just "Italy", could you show me an example of how to do that?"
No, I cannot offer an example until you answer my original question:
How do you plan to tell the code what countries you want to search for? InputBoxes? Values in cells? Hardcoded in the macro? Something else?
Do you mean more countries need to be copied to the same sheet, e.g. Italy and Slovakia should both be copied to Workbooks("TESTIN").Sheets(1) or are they to be copied to different sheets? It's all about the details, my friend, the details.
I don't mean to sound harsh - although I'm sure that I do - but I didn't ask for more details way back in my very first response for no reason.
Without the exact details related to your layout and process, I'm just wasting my time - and yours - writing code that doesn't fit your needs.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.