Single text file imported to multiple worksheets
I have a single text file with many different pieces of data that I'd like
divided into individual worksheets. The text file looks like this:
Server - test1 O/S Version
oracle5 HP-UX B.10.20
oracle7 HP-UX B.10.20
Server - test 2 O/S Version
whmz HP-UX B.10.20
Server - test 3 O/S Version
saturn HP-UX B.11.
oracle5 HP-UX B.10.20
pluto HP-UX B.10.20
As shown each new worksheet would start with the "Server - description"
field. I'd like to have that description also be the tab name if that's
possible.
|