IMNEWTOEXCEL
New Member
- Joined
- Apr 26, 2018
- Messages
- 5
Hi,
this is my first post and totally new to excel, I have conditional formatted data it looks for any data which has these words (interface TenGigabitEthernet), (ip address) and (interface Bundle) and highlights it in Yellow, i want to move only this data to another sheet. example below. there are 6000 lines in total and only 50 lines which are highlighted after the conditional formatting and those i need moved.
<colgroup><col></colgroup><tbody>
</tbody>interface TenGigabitEthernet3/3/0
ip address 1.16.1.1 255.255.255.252
interface Bundle1
ip address 1.16.1.1 255.255.255.252
Thanks for the help
this is my first post and totally new to excel, I have conditional formatted data it looks for any data which has these words (interface TenGigabitEthernet), (ip address) and (interface Bundle) and highlights it in Yellow, i want to move only this data to another sheet. example below. there are 6000 lines in total and only 50 lines which are highlighted after the conditional formatting and those i need moved.
interface Modular-Cable3/3/2:11 |
description Node 1 |
cable bundle 1 |
cable rf-bandwidth-percent 30 |
<colgroup><col></colgroup><tbody>
</tbody>
ip address 1.16.1.1 255.255.255.252
interface Bundle1
ip address 1.16.1.1 255.255.255.252
Thanks for the help