Excel programming

[khushbu.bhandari]

Hi All,

I have a flow chart and would like this to be automated in excel. for example when i click on yes I should be able to choose from various options and select one or more, then submit the request and whatever actions i have chosen should be automatically exported on another worksheet with controlled access.

Any thoughts?

 

[venkat1926]

post a small database and explain what you want

 

[Ruddles]

Is this the same sort of thing as discussed in this thread?

 

[khushbu.bhandari]

Hi Venkat,

I have sent the excel to your gmail ID.

Please let me know.

Thanks for all your help.

 

[khushbu.bhandari]

Hi Ruddles,

Its kinda easy yet difficult at the same time.

when I open the excel there are numbers (1-7)- These are my inputs

1. Order Number
2. Select Any of the states(Contains Hyperlink)
3. Sheet (2) that leads to a some categories (Max 4) -Check Boxes
4. Enter Additional comments
5. Submit
6. Clear

So first of all when I submit all the steps (1-max 7) it should be captured on sheet 3 and then when i hit the clear button it should erase only the data that i entered in Sheet 1 and Sheet 2.

Input two has various hyperlinks that lead to sheet 2 that contains options and I check the options available whenever i choose them.

 

[khushbu.bhandari]

Hi Both,

This is how the excel looks