Hi
I have an Excel VBA problem and I need to know whether a solution is practically possible, so would really appreciate you're help.
I have a worksheet that contains two columns:
column A (hostnames) | Column B (Applications)
host1 | 00001 - App1; 00002 - App2
host2 | 00002 - App2; 03 - App3
host3 | 345 - App345; 3939 - App768 FedEx; 9876 - App243
host4 | 00001 - App1
As you can see there can be either a 1-1 relationship between host and App OR a 1-n relationship between host or App.
As you can also see, the AppID can be of varying length, as can the App Name (however, and importanty I think, where there is a 1-n relationship the Apps are always separated by a semicolon ";", and separated from the App Name by a dash "-")
I need to search through each hostname in my worksheet:
column A (hostnames) | Column B (Applications)
host1 | 00001
host1 | 00002
host2 | 00002
host2 | 03
host3 | 345
host3 | 3939
host3 | 9876
host4 | 00001
Perhaps someone kind enough would be able to post the script to achieve this???
P.S. I could use this in a hurry...
Thanks in advance
Shane
I have an Excel VBA problem and I need to know whether a solution is practically possible, so would really appreciate you're help.
I have a worksheet that contains two columns:
- a unique list of hostnames
- a list of applications assocaited with each hostname
column A (hostnames) | Column B (Applications)
host1 | 00001 - App1; 00002 - App2
host2 | 00002 - App2; 03 - App3
host3 | 345 - App345; 3939 - App768 FedEx; 9876 - App243
host4 | 00001 - App1
As you can see there can be either a 1-1 relationship between host and App OR a 1-n relationship between host or App.
As you can also see, the AppID can be of varying length, as can the App Name (however, and importanty I think, where there is a 1-n relationship the Apps are always separated by a semicolon ";", and separated from the App Name by a dash "-")
I need to search through each hostname in my worksheet:
- Where there is a 1-1 relationship I need to add that hostname and AppID (NOTE - NOT THE Application Name) to a new worksheet (Column A for the hostname, column B for the Application ID.
- Where there is a 1-n relationship I need put a row in the new worksheet for each Application ID.
column A (hostnames) | Column B (Applications)
host1 | 00001
host1 | 00002
host2 | 00002
host2 | 03
host3 | 345
host3 | 3939
host3 | 9876
host4 | 00001
Perhaps someone kind enough would be able to post the script to achieve this???
P.S. I could use this in a hurry...
Thanks in advance
Shane