$$Excel-Macros$$ Need help in macro

2016-08-26 Thread Manju Deva
Hi I need your help to create a macro for the below mentioned scenario. *Scenario* We need two columns namely User, drop down *“IF user enter data in User column(cells) a automatic drop down needs to create in a column B* *Else* *No drop down required”* *And the macro should ru

$$Excel-Macros$$ Re: Introduce Yourself !!

2016-08-26 Thread Manju Keerthi
Hi, I am a beginner in excel i need your help to solve the following scenario i need to create a macro which should does the bellow thing *If user enter the value in Column A, a drop down list needs to create automatically in Column B * *Else No drop down required and once the user start enter

Re: $$Excel-Macros$$ Update / Insert SQL Table from Excel Sheet

2016-08-26 Thread Paul Schreiner
That's really a pretty vague request. It's like stopping to ask for directions and saying:"I'm trying to drive somewhere, how do I get there?" All we really know is:- You have Excel- You want to copy it to a database.  The fact is:  SQL isn't a "database", it's a LANGUAGE(Structured Query Languag