Convert config file, copy to new sheet while making some changes, may include variabl

[kldailey]

I would like to have a macro or something to copy one column to a ne
sheet while changing some of the text, skipping a few rows, and adding
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


+-------------------------------------------------------------------
|Filename: config.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=578
+-------------------------------------------------------------------