Hello, im new to macros and was wondering if its possible to re arrange sheet 1 to look like sheet 2 in the file attached. So something like:



If any text string in column A looks like "chain" then put this into cell 1 Column A<--so running something like this should put "Chain: 12345678" into the first cell in column A since thats the only text value on the excel doc with the word "chain in it" (See sheet 2 for reference".

Attached Files

goodsample.xlsx (14.5 KB, 14 views)

Im surprised this hasnt been answered yet. Yes this is possible to do. The only clarification needed is when you say the word chain do you mean literally the word chain or a text string you can change as needed. This would be completed with a simple loop however it appears that your data has been copied and pasted from somewhere else hence all of the white space between fields ( This can be removed using the function "trim") so with that we would also need to know if the data you paste in will keep getting bigger or if it is just this set of data so we know where to cut the loop off.

Again yes this is possible

I am sorry for re-activating an old thread the 2013 didnt quite register this morning. Sorry