Automation in excel

sreekanthvs

New Member
Joined
Sep 20, 2019
Messages
3
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.
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Forum statistics

Threads
1,213,543
Messages
6,114,237
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top