Automation in excel

[sreekanthvs]

Hi All,

I'm a basic excel user and dont know how to automate my requirement using excel. I know excel is powerful and as i dont have programming background i'm not able to understand the vba. Can someone help me here.

My requirement is I have few questions where I get answers from users.

For eg:

What is the name of your application - App1
Service provided by this application - Financial service
Any Modules - 2
Module name - mod1, mod2
Enabled capabilities? - 2
Capability Names - Cap1, Cap2
How many environments? 3
Environments - Prod, Test, Acc
managed by - ABC company
owner - XYZ
owning business - abc

Based on the above input (requirements)

1 The excel should provide me the naming standards like below

Application Name - App1
Service Name - Financial Service
Offerings - App1_Cap1 and App1_Cap2
Instances - App1_Prod, App1_Test, App1_Acc
managed by - ABC company
owner - XYZ
owning business - abc
Server Name - Ser1
Router Name- R1

2. Relationships data

App1 consumes App1_Prod
App1 consumes App1_Test
App1 consumes App1_Acc
Financial Service contains App1_Cap1
Financial Service contains App1_Cap2
App1_Cap1 depends on App1_Prod
App1_Cap2 depends on App1_Prod
App1_Prod depends on Ser1
Ser1 depends on R1

3. Populate this data to Visio


Not sure how to attache pic here.

 

[sreekanthvs]

Can anyone please help me on this?