I need a snippet of VBA code to do the following for BOTH tabs on the uploaded spreadsheet. So thats form1 AND form2.
Part 1
1. Search Column A for "***TURN*** [yy]"
2. This cell will need to be edited to insert data from the CORRELATING***FLOP***[xx xx xx] which will be the first instance of ***FLOP***[xx xx xx] ABOVE the searched TURN cell
2. The ***TURN*** [yy] will then have the _flopBracket_ inserted to the cell. So that "***TURN*** [yy]" becomes "***TURN*** [xx xx xx] [yy]"
Part 2
1. Search for ***River*** [zz] within column A
2. Find correlating ***TURN*** [xx xx xx] [yy]
3. Edit corrrelatining turn bracket contents to become [xx xx xx yy]
4. Insert [xx xx xx yy] within ***RIVER*** as so ***RIVER [xx xx xx yy] [zz]
NOTE: [xs] [ys] [zs] will always be different. the contents of these brackets should remain the same in all instances.
Thanks
Part 1
1. Search Column A for "***TURN*** [yy]"
2. This cell will need to be edited to insert data from the CORRELATING***FLOP***[xx xx xx] which will be the first instance of ***FLOP***[xx xx xx] ABOVE the searched TURN cell
2. The ***TURN*** [yy] will then have the _flopBracket_ inserted to the cell. So that "***TURN*** [yy]" becomes "***TURN*** [xx xx xx] [yy]"
Part 2
1. Search for ***River*** [zz] within column A
2. Find correlating ***TURN*** [xx xx xx] [yy]
3. Edit corrrelatining turn bracket contents to become [xx xx xx yy]
4. Insert [xx xx xx yy] within ***RIVER*** as so ***RIVER [xx xx xx yy] [zz]
NOTE: [xs] [ys] [zs] will always be different. the contents of these brackets should remain the same in all instances.
Thanks