Hello,
I need to create a macro who can search for a partial string (ex: TAR-WKS or TAR_LCD) on the H,J,I and K columns and if a string with that name it's found it should:
1. Insert a new line below the line where the string it's found.
2. Copy the content of the A,B,C,D and E columns from the line where the search string was found and paste them on the new line inserted at point 1, using same location - A on A, B on B, .., E on E.
3. CUT the found string along with the rest of the text (ex: TAR-WKS152 or TAR_LCD668) to the new line created as follows:
test environment, copy/paste it to an excel file.
<tbody>
</tbody>
I need to create a macro who can search for a partial string (ex: TAR-WKS or TAR_LCD) on the H,J,I and K columns and if a string with that name it's found it should:
1. Insert a new line below the line where the string it's found.
2. Copy the content of the A,B,C,D and E columns from the line where the search string was found and paste them on the new line inserted at point 1, using same location - A on A, B on B, .., E on E.
3. CUT the found string along with the rest of the text (ex: TAR-WKS152 or TAR_LCD668) to the new line created as follows:
- if it's TAR-WKS"a number" it should be pasted on the new line, column F.
- if it's TAR_LCD"a number" it should be pasted on the new line, column G.
test environment, copy/paste it to an excel file.
ID | Owner | Current Project | Project's platform | PC | Monitor | Others1 | Others2 | Others3 | Others4 | |
532110 | Will Smith1 | Project 1 | Platform 1 | mail 1 | TAR-WKS134 | TAR_LCD649 | TAR_LCD669 | TAR-WKS152 | TAR_LCD668 | |
532111 | Will Smith2 | Project 2 | Platform 2 | mail 2 | TAR-WKS135 | TAR_LCD650 | TAR-WKS149 | TAR_LCD665 | ||
532112 | Will Smith3 | Project 3 | Platform 3 | mail 3 | TAR-WKS136 | TAR_LCD651 | TAR-WKS144 | TAR_LCD666 | ||
532113 | Will Smith4 | Project 4 | Platform 4 | mail 4 | TAR-WKS137 | TAR_LCD652 | TAR-WKS150 | TAR_LCD660 | ||
532114 | Will Smith5 | Project 5 | Platform 5 | mail 5 | TAR-WKS138 | TAR_LCD653 | TAR-WKS146 | TAR_LCD661 | ||
532115 | Will Smith6 | Project 6 | Platform 6 | mail 6 | TAR-WKS139 | TAR_LCD654 | TAR-WKS146 | TAR_LCD659 | TAR-WKS147 | |
532116 | Will Smith7 | Project 7 | Platform 7 | mail 7 | TAR-WKS140 | TAR_LCD655 | TAR_LCD664 | TAR_LCD670 | TAR-WKS151 | |
532117 | Will Smith8 | Project 8 | Platform 8 | mail 8 | TAR-WKS141 | TAR_LCD656 | TAR_LCD663 | TAR-WKS145 | TAR-WKS146 | |
532118 | Will Smith9 | Project 9 | Platform 9 | mail 9 | TAR-WKS142 | TAR_LCD657 | TAR-WKS147 | TAR_LCD667 | ||
532119 | Will Smith10 | Project 10 | Platform 10 | mail 10 | TAR-WKS143 | TAR_LCD658 | TAR_LCD662 | TAR-WKS148 |
<tbody>
</tbody>