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

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

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

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

Re: $$Excel-Macros$$ Fetching Data from excel based on current date

Thanks Paul, it worked. On Thursday, August 4, 2016 at 6:19:20 PM UTC+5:30, Paul Schreiner wrote: > > Mr. Emamuddin, > I'd be glad to help you with this. > I think there's quite a bit I can do to streamline this macro. > I've spent quite some time trying to create a sample file to try to follow

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

Dear Friends, I'm New to excel VBA, I'm trying to update/insert Sql Table from Excel. That is whenever i insert or update Excel Table it should automatically update/insert to SQL. Thanks, 7092063444 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Sumif multiple column

thanks a ton! On Fri, Aug 26, 2016 at 11:24 AM, 'ravinder negi' via MS EXCEL AND VBA MACROS wrote: > PFA > > > On Friday, August 26, 2016 10:52 AM, Deepak Rawat > wrote: > > > Hi, > > Need sumif function to sum multiple columns > > sample