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

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

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

> > 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

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)

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.....

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

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

> > 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)

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

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

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

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

*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

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

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

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

> > 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

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

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

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

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

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

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

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

=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

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

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

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

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

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

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

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

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

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