Macro To Find DataDec 10, 2009
I am looking to create a macro that finds the data "Supplier Name :" then moves 3 cells across from this found cell and combines the text in the two cells to the right of the current cell.
So for example my supplier name should read MrExcel Ltd, but is spilt between two cells as MrExc and then el Ltd
I would like this then to loop down to the bottom of the spreadsheet doing the same thing each time "Supplier Name :" is found.
I have tried to find this on other posts but can't seem to get the right code combined from other posts.