KlayontKress
Board Regular
- Joined
- Jan 20, 2016
- Messages
- 67
- Office Version
- 2016
- Platform
- Windows
I'm looking for a macro to look for a specific Text String in a column and then append the value in another column. We have a program that exports out to a template in excel to do generate a pricing quote for our customers and We have someone manually doing adding values to the name of the product to reflect it's modifications.
For example, the column I want to search is Column E and the value I want to Append is Column A. I need a macro to search Column E for "ID=15" and then add ID15 to the end of the value in column A. I need the macro to search the entire column of E and do the Modifications as there isn't a set length to the data though it rarely goes past 30 line items.
A picture of the sheet is below. I need to be able to do this with several different values but a basic Macro to do the above will allow me to adapt it to my needs.
<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>
Thanks in advance,
For example, the column I want to search is Column E and the value I want to Append is Column A. I need a macro to search Column E for "ID=15" and then add ID15 to the end of the value in column A. I need the macro to search the entire column of E and do the Modifications as there isn't a set length to the data though it rarely goes past 30 line items.
A picture of the sheet is below. I need to be able to do this with several different values but a basic Macro to do the above will allow me to adapt it to my needs.
A | B | C | D | E |
Description | Customer Description | Qty | Options | Modifications |
ACM8 | 1.00 | |||
B33 SS1 BUTT | 1.00 | |||
B39 SS1 | 2.00 | |||
BTK8 PRT | 2.00 | |||
CM8 BLD | 1.00 | |||
CM8 WD | 1.00 | |||
SHM8 BLD | 2.00 | |||
UF2 | 2.00 | |||
UF3 | 1.00 | |||
UF342 | 1.00 | |||
UM8 BLD | 3.00 | |||
UM8 WD | 3.00 | |||
W3036 BUTT | 1.00 | FEDEP;UPBOX | IND12~ID=15 | |
W3342 BUTT | 1.00 | |||
W3624 BUTT | 1.00 | |||
W3942 | 2.00 | |||
W3036 BUTT | 1.00 | IND12~ID=15 | ||
SM8 WD | 1.00 |
<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>
Thanks in advance,