Complex copy paste

[sroysroy]

Case A I have two words (horse and cow) or two sentences ("x is good" and "y is fine but....")

There are many rows between them with text (word or sentences) or numeric nunmbers. Even empty rows.

If Case A is correct then copy the content between case A in a single cell in B200 with "Case" word in A200.

[alansidman]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[sroysroy]

Please find the attachment.

[sroysroy]

Any solution ?

[jindon]

Only for the data provided.

Please Login or Register  to view this content.

[sroysroy]

JINDON I want to run the code in all sheets of the excel workbook except SheetA and SheetB.

[sroysroy]

Jindon the code has issue if i am changing it from txt = Join(Filter(ws.[transpose(if(a1:a50<>"",a1:a50,char(2)))], Chr(2), 0), vbLf)
to txt = Join(Filter(ws.[transpose(if(a1:a500<>"",a1:a500,char(2)))], Chr(2), 0), vbLf)

[jindon]

Only for the data provided.

......................................

[sroysroy]

But its a mock data

[jindon]

That means nothing in this case.

It is not a mock data, it's a lazy data, so I only worked with that specific data.

[sroysroy]

Anyway Thank you very much as you tried to help me. You are a valuable contributor to this forum.
I marked this thread as solved.

[sroysroy]

jindon help me with this please.