Re: $$Excel-Macros$$ Min based on condtions

2013-10-02 Thread Chandra Shekar
Hello Asish, I tried it and its working fine but I need to know is there any other way to get this result. Regards, Chandra On Wed, Oct 2, 2013 at 12:31 PM, ashish koul wrote: > y dont u try pivot table > > > On Wed, Oct 2, 2013 at 12:28 PM, Chandra Shekar < > chandrashekarb@gmail.com> w

Re: $$Excel-Macros$$ Data Entry Form/Database

2013-10-02 Thread Kishan Reddy, K
Dileep, You can contact me, I am sending my contact details through mail. Regards, Kishan Reddy, K On Wednesday, October 2, 2013 6:34:34 PM UTC+5:30, Bv Dileep wrote: > > Thanks for your quick response. And please do let me know in this forum is > anyone resides in Hyderabad and if you are rea

$$Excel-Macros$$ Re: Access Qurey

2013-10-02 Thread Kishan Reddy, K
> > You can use the the links (linked tables) as like original table. Means, You can directly open the link and paste the data. You can refer the linked table in queries, forms, reports and even macros & modules. Regards, Kishan Reddy, K -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? A

$$Excel-Macros$$ export table to Excel from a link

2013-10-02 Thread asdhhc
link is : https://secure.fundsupermart.com/main/fundinfo/dailyPricesHistory.tpl?id=DBSAUD -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use co

Re: $$Excel-Macros$$ Query on Dashboard(urgent)

2013-10-02 Thread ashwani agnihotri
Hi All, Any update on this? Regards, Ashwani On Wed, Oct 2, 2013 at 7:20 PM, ashwani agnihotri < ashwani.agniho...@gmail.com> wrote: > Hi All, > > I have attached an excel for reference I want to know if I can create a > dashboard werein if I select a team , the rest of the data about the team

$$Excel-Macros$$ Help required in formula.....

2013-10-02 Thread Indrajit $nai
Hi Experts, PFA, kindly let me know is there any formula to sum-up the col B nos into col D. As of now I am doing it manually, but it's very long term process! Kindly let me know is there any way out to do it through any formula. Thanks in advance. -- Indrajit Disclaimer: This electronic mes

Re: $$Excel-Macros$$ Using Userform as Navigation Pane to move between worksheets

2013-10-02 Thread Bipin Singh
Hello Ashish, May I ask you the use of ComboBox1_KeyDown and ComboBox1_KeyPress event in provided solution if *Userform.show* is already inside worksheet change event.. Thanks in advance. Thanks, Regards, BS On Wed, Oct 2, 2013 at 12:41 PM, ashish koul wrote: > try attached file > > > > On

$$Excel-Macros$$ Re: Find Distance and Time between two cities using Google Map In excel

2013-10-02 Thread Aseem Mehta
> > Hello Ashish, > This is great work, it has helped me understand the concept. I would like some help where the cities are more than 2 . I have way points and would like to know the total distance / drive time. for example , http://maps.googleapis.com/maps/api/directions/xml?origin=Boston,MA

$$Excel-Macros$$ Query on Dashboard(urgent)

2013-10-02 Thread ashwani agnihotri
Hi All, I have attached an excel for reference I want to know if I can create a dashboard werein if I select a team , the rest of the data about the team comes automatically. Like I apply data validation on team and select powerteam I want all the employees along with their productivity and qualit

Re: $$Excel-Macros$$ Inserting BMP (Bitmap) Images Into A Predefined Cell Size

2013-10-02 Thread ashish koul
try this see if it helps Sub test() ActiveSheet.Pictures.Insert ("C:\Users\admin\Desktop\Excel Tips & Tricks\01.jpg") With ActiveSheet.Shapes(ActiveSheet.Shapes.Count) .Left = Range("a1").Left .Top = Range("a1").Top .Width = Range("a1").Width .Height = Range("a1").Height End With

$$Excel-Macros$$ Inserting BMP (Bitmap) Images Into A Predefined Cell Size

2013-10-02 Thread Bill Q
Hi, I know how to insert the image. The thing is I want the cell to always be always the same size. Any advice ? Thanks. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.

Re: $$Excel-Macros$$ Data Entry Form/Database

2013-10-02 Thread B V Dileep
Thanks for your quick response. And please do let me know in this forum is anyone resides in Hyderabad and if you are ready to teach VBA. Please let me know On Oct 2, 2013 6:15 PM, "ashish koul" wrote: *try these * *https://app.box.com/s/zxhxpoitad7sih0wpigl * *https://app.box.com/s/szaxukie20xnu

Re: $$Excel-Macros$$ Data Entry Form/Database

2013-10-02 Thread ashish koul
*try these * *https://app.box.com/s/zxhxpoitad7sih0wpigl * *https://app.box.com/s/szaxukie20xnutka8f3e* * https://www.facebook.com/photo.php?fbid=525682004167816&set=a.209740072428679.47011.15180389897&type=1&theater * On Wed, Oct 2, 2013 at 6:13 PM

Re: $$Excel-Macros$$ Data Entry Form/Database

2013-10-02 Thread B V Dileep
Hi, could please send me any tutorial link or document. That would be great. On Oct 2, 2013 5:32 PM, wrote: > ** > Use excel as front end and access as back end to store information > > Create an access database with tables , etc save it in a share folder > > Create userform in excel and connect

$$Excel-Macros$$ Re: total Fridays in a range

2013-10-02 Thread asdhhc
On Tuesday, October 1, 2013 10:18:15 PM UTC+8, asd...@gmail.com wrote: > > vba returns total Fridays in A2:A6. If A2:A6 all are Fridays. The value > should be 5. > Plse refer to the attached example. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,

$$Excel-Macros$$ Re: total Fridays in a range

2013-10-02 Thread asdhhc
On Tuesday, October 1, 2013 10:18:15 PM UTC+8, asd...@gmail.com wrote: > > vba returns total Fridays in A2:A6. If A2:A6 all are Fridays. The value > should be 5. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of

$$Excel-Macros$$ Re: Cognos Developer - Only GC, Citizens

2013-10-02 Thread Kalpana Muppana
> > 123trainings provides the best Cognos Online > Trainingfrom > Hyderabad.. we have dedicated faculty who can guide the students in > the best way.. our faculty has more than 5 years of Experience and they are > working from top MNC

Re: $$Excel-Macros$$ Re: total Fridays in a range

2013-10-02 Thread koul . ashish
Can u explain it in detail Sent on my BlackBerry® from Vodafone -Original Message- From: asd...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 2 Oct 2013 01:22:20 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: total Fridays in a range On Wed

Re: $$Excel-Macros$$ Data Entry Form/Database

2013-10-02 Thread koul . ashish
Use excel as front end and access as back end to store information Create an access database with tables , etc save it in a share folder Create userform in excel and connect it with access db using ado Regards Ashish Sent on my BlackBerry® from Vodafone -Original Message- From: B V Di

$$Excel-Macros$$ Re: Build your carrier in BI Developer/MIS reporting

2013-10-02 Thread Kalpana Muppana
123trainings provides the best MSBI Online Training from Hyderabad.. we have dedicated faculty who can guide the students in the best way.. our faculty has more than 5 years of Experience and they are working from top MNCs.. Our motto is t

Re: $$Excel-Macros$$ Periodic Formula help

2013-10-02 Thread Avinash Patil
Awesome man it's working thanks a TON! Regards, Avinash Sent from my iPhone On Oct 2, 2013, at 2:03 PM, ashish koul wrote: =IF(B3=1,"PR -1 ",IF(AND(MOD(B2,4)=0,MOD(B3,4)<>0),"PR - "& RIGHT(E2,LEN(E2)-4)+1,E2)) On Wed, Oct 2, 2013 at 1:43 PM, Avinash Patil wrote: > Every 4 weeks are consider

Re: $$Excel-Macros$$ Data Entry Form/Database

2013-10-02 Thread B V Dileep
Hi, Just now I heard that creating forms and bit of VB code will work is it true? On Oct 2, 2013 4:21 PM, "xlstime" wrote: > no its not possible with only excel... need to create another database > like ..ms access or sql > > . > > Enjoy > Team XLS > > > > On Wed, Oct 2, 2

Re: $$Excel-Macros$$ Data Entry Form/Database

2013-10-02 Thread xlstime
no its not possible with only excel... need to create another database like ..ms access or sql . Enjoy Team XLS On Wed, Oct 2, 2013 at 3:53 PM, Bv Dileep wrote: > Hi Experts, > > We have 10 associates, they are updating the data in different excel > workbooks. at the

$$Excel-Macros$$ Data Entry Form/Database

2013-10-02 Thread Bv Dileep
Hi Experts, We have 10 associates, they are updating the data in different excel workbooks. at the end of the day i have to collate all those workbooks into one. is there any way if we provide them one workbook with share mode. If they update the data in the sheet. Only i have to get the updat

Re: $$Excel-Macros$$ Periodic Formula help

2013-10-02 Thread ashish koul
=IF(B3=1,"PR -1 ",IF(AND(MOD(B2,4)=0,MOD(B3,4)<>0),"PR - "& RIGHT(E2,LEN(E2)-4)+1,E2)) On Wed, Oct 2, 2013 at 1:43 PM, Avinash Patil wrote: > Every 4 weeks are considered as 1 period that is the logic. And weeks are > starting from sun to sat. > This year was started on tuesday so last year's 2

Re: $$Excel-Macros$$ Re: total Fridays in a range

2013-10-02 Thread asdhhc
On Wednesday, October 2, 2013 4:07:13 PM UTC+8, ashish wrote: > > can u share hw wuld u like to see thn > > if SUM((WEEKDAY(A2:A6)=6)) = 5 then .. > > On Wed, Oct 2, 2013 at 1:01 PM, > wrote: > >> >> >> On Tuesday, October 1, 2013 10:18:15 PM UTC+8, asd...@gmail.com wrote: >>> >>>

Re: $$Excel-Macros$$ Periodic Formula help

2013-10-02 Thread Avinash Patil
Every 4 weeks are considered as 1 period that is the logic. And weeks are starting from sun to sat. This year was started on tuesday so last year's 2 days are also considered in this calculations. Sent from my iPhone On Oct 2, 2013, at 10:17 AM, ashish koul wrote: can u explain how what logic y

Re: $$Excel-Macros$$ Re: total Fridays in a range

2013-10-02 Thread ashish koul
can u share hw wuld u like to see thn On Wed, Oct 2, 2013 at 1:01 PM, wrote: > > > On Tuesday, October 1, 2013 10:18:15 PM UTC+8, asd...@gmail.com wrote: >> >> vba returns total Fridays in A2:A6. If A2:A6 all are Fridays. The value >> should be 5. >> > > run your vba, the result as shown on Sna

Re: $$Excel-Macros$$ Using Userform as Navigation Pane to move between worksheets

2013-10-02 Thread Jewel Sharma
Brilliant mate. Works very well. On Wednesday, October 2, 2013 3:11:27 PM UTC+8, ashish wrote: > > try attached file > > > On Wed, Oct 2, 2013 at 12:01 PM, Jewel Sharma > > wrote: > >> Hi Ashish, >> This is great, but doesn't meet my need. Allow me to explain: >> >> The workbook will have certain

$$Excel-Macros$$ Re: total Fridays in a range

2013-10-02 Thread asdhhc
On Tuesday, October 1, 2013 10:18:15 PM UTC+8, asd...@gmail.com wrote: > > vba returns total Fridays in A2:A6. If A2:A6 all are Fridays. The value > should be 5. > run your vba, the result as shown on Snap2.png is not I wanted. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wa

Re: $$Excel-Macros$$ Re: Pie chart

2013-10-02 Thread ashish koul
please share the chart On Wed, Oct 2, 2013 at 12:39 PM, joseph camill wrote: > Can anyone help me with a code > On Sep 24, 2013 9:11 PM, "joseph camill" wrote: > >> Thanks for your response. I know to do it manually but my charts gets >> updated very often. So I am looking for an automation. >>

Re: $$Excel-Macros$$ Using Userform as Navigation Pane to move between worksheets

2013-10-02 Thread ashish koul
try attached file On Wed, Oct 2, 2013 at 12:01 PM, Jewel Sharma wrote: > Hi Ashish, > This is great, but doesn't meet my need. Allow me to explain: > > The workbook will have certain "hidden" sheets that the user does not need > to interact with. That is why I'm hiding the *.* So, I need a > "N

Re: $$Excel-Macros$$ Re: Pie chart

2013-10-02 Thread joseph camill
Can anyone help me with a code On Sep 24, 2013 9:11 PM, "joseph camill" wrote: > Thanks for your response. I know to do it manually but my charts gets > updated very often. So I am looking for an automation. > On Sep 24, 2013 6:54 PM, "Johnnyboy5" wrote: > >> Goto the pie chart - double click on

Re: $$Excel-Macros$$ Min based on condtions

2013-10-02 Thread ashish koul
y dont u try pivot table On Wed, Oct 2, 2013 at 12:28 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello Asish, > > Please find attached file I have got this result using SUM and IF formula > is there any other way to get the same result. > > Regards, > > Chandra > > On Wed, Oct 2