Using the example below, how can I create a macro to select everything from the server name in A1 (BOMDirector04) to B12(cell to right of "Done")and name the range selection to match the server name from A1?
Thanks much for any suggestions!!
A B
BOMDirector04
Collection Monitor
---------- -------
w2k_Memory CommittedBytes
Universal ncustom: c:/tivoli/scripts/cleanperf.pl
w2k_NetworkInterface OutputQueLen
w2k_Memory PgFltsPerSec
w2k_Memory PagesPerSec
w2k_PhysicalDisk PrcDskTime
w2k_Processor PrcIntTime
w2k_Processor IntsPerSec
Done
BOMPORTAL01
Collection Monitor
---------- -------
Universal appStatus
w2k_System SysCallsPerSec
w2k_Processor PrcPrivTime
w2k_Processor PrcUsrTime
w2k_Processor PrcUsrTime
Done
BOMPORTAL02
Collection Monitor
---------- -------
Universal appStatus
w2k_System SysCallsPerSec
w2k_Processor PrcUsrTime
Done
Thanks much for any suggestions!!
A B
BOMDirector04
Collection Monitor
---------- -------
w2k_Memory CommittedBytes
Universal ncustom: c:/tivoli/scripts/cleanperf.pl
w2k_NetworkInterface OutputQueLen
w2k_Memory PgFltsPerSec
w2k_Memory PagesPerSec
w2k_PhysicalDisk PrcDskTime
w2k_Processor PrcIntTime
w2k_Processor IntsPerSec
Done
BOMPORTAL01
Collection Monitor
---------- -------
Universal appStatus
w2k_System SysCallsPerSec
w2k_Processor PrcPrivTime
w2k_Processor PrcUsrTime
w2k_Processor PrcUsrTime
Done
BOMPORTAL02
Collection Monitor
---------- -------
Universal appStatus
w2k_System SysCallsPerSec
w2k_Processor PrcUsrTime
Done