I would like to have a macro or something to copy one column to a new sheet while changing some of the text, skipping a few rows, and adding a few.
This would be done over and over restarting each time an "!" is found.
I have attached a sample of what I need.
Source:
sheet 1 column A (Pasted input)
!
interface Vlan728
description Connection to VLAN 728
ip address 192.19.134.131 255.255.255.128
ip access-group any in
ip helper-address 192.19.160.6
no ip redirects
no ip unreachables
shutdown
standby ip 192.19.134.129
standby timers 1 3
standby priority 110
standby preempt delay minimum 3 sync 3
ip pim sparse-dense-mode
!
interface Vlan729
description Connection to VLAN 729
ip address 192.19.135.131 255.255.255.128
ip access-group any in
ip helper-address 192.19.135.6
no ip redirects
no ip unreachables
shutdown
standby ip 192.19.160.129
standby timers 1 3
standby priority 110
standby preempt delay minimum 3 sync 3
ip pim sparse-dense-mode
!
interface Vlan730
description Connection to VLAN 730
ip address 192.19.136.131 255.255.255.128
ip access-group any in
ip helper-address 192.19.160.6
no ip redirects
no ip unreachables
shutdown
standby ip 192.19.136.129
standby timers 1 3
standby priority 110
standby preempt delay minimum 3 sync 3
ip pim sparse-dense-mode
!
interface Vlan731
description Connection to VLAN 731
ip address 192.19.135.131 255.255.255.128
ip access-group any in
ip helper-address 192.19.135.6
no ip redirects
no ip unreachables
shutdown
standby ip 192.19.160.129
standby timers 1 3
standby priority 110
standby preempt delay minimum 3 sync 3
ip pim sparse-dense-mode
!


Result:
Sheet 2 column A (Result)
#
interface Vlan-interface728
description Connection to VLAN 728
ip address 192.19.134.131 255.255.255.128
ip access-group any in
udp-helper server 192.19.160.6
no ip redirects
no ip unreachables
shutdown
vrrp vrid 728 virtual-ip 192.19.134.129
vrrp vrid 728 priority 110
pim sm
#
interface Vlan-interface729
description Connection to VLAN 729
ip address 192.19.135.131 255.255.255.128
ip access-group any in
udp-helper server 192.19.135.6
no ip redirects
no ip unreachables
shutdown
vrrp vrid 729 virtual-ip 192.19.160.129
vrrp vrid 729 priority 110
pim sm
#
interface Vlan-interface730
description Connection to VLAN 730
ip address 192.19.136.131 255.255.255.128
ip access-group any in
udp-helper server 192.19.160.6
no ip redirects
no ip unreachables
shutdown
vrrp vrid 730 virtual-ip 192.19.136.129
vrrp vrid 730 priority 110
pim sm
#
interface Vlan-interface731
description Connection to VLAN 731
ip address 192.19.135.131 255.255.255.128
ip access-group any in
udp-helper server 192.19.135.6
no ip redirects
no ip unreachables
shutdown
vrrp vrid 731 virtual-ip 192.19.160.129
vrrp vrid 731 priority 110
pim sm
#