Search for any Text String in specific range and copy + offset + move

Hello,

I searched thru the forum but I didn't see any thread which discussed about searching for ANY TEXT VALUE string (NOT specific words) within a delimited range of cells then copy these TEXT strings + offset paralele data and move to specific bottom ranges. Please helps. I have jointed a excel sample with this thread.

The text string value contains alphanumneric or special characters but not $ sign or currency format.
The offset value contains currency values but no alpha.

Thanks in advance,

Thanks for yr. interest to my request.

In my example file, I want to search on the Range("F11:F39") to find any text string value. The text string value can be any alpha-numerical string but can't be a currency value or format, so in my example, the Range("F16:F19") and Range("F21:F22") is the text strings value which I would like to find.

Once the text strings are found then I would like to use the function "Offset" to select the currency values located in paralele Range("J16:J19") and Range("J21:J22") as per my example file. Blank cells are to be skipped.

Finally, move found values (Range("F16:F19") and Range("F21:F22")) and its Offset value (Range("J16:J19") and Range("J21:J22") ) to J46 & K46 and down rows respectively. Blank cells are not move.

I hope my explanation are clear.

Regards,

Hello Leith,

Yr. code is working fine with a small problem as my text string values must only contains a text value or a combination of text & number values or a text & signs values or a text & number & signs values but can't be only containing a single value as currency value or number value or sign value.

Regards,

Hello Leith,

Please see the attached file for sample.

I just want to adjust the RegExp so that don't pickup any data that contain SINGLE values as currency, munerical or special characters.

Regards,

Hello Leith,

OK, The file is in sheet2 but I just want to know how-to only create a RegExp that only extract text string value

Regards

Hello Leith,

No I want any text string [a-z] or any combination of text string with number [a-z][0-0] or any combination of text string, number and special characters [a-z][0-9][.*/?%,...]

But I don't want any single numerical value [0-9] as 178 or any combination of special characters as .*/?%,... alone.

My string value may contains text + % or + 5,6,7

Regards,

Hello Leith,

Any helps for the last point pending for this request???

Regards,

Hello Leith,

Sorry for late reply.

Yr. lastest code is working as I want. Thanks you very much.

FN2010