$$Excel-Macros$$ Re: Formulas for predictive analysis and forecasting

2012-09-26 Thread Vabz
Hi Krish, Forecasting is very wide are if you can be specific then we can help further: For trend analysis you can use Trend function.. See Linkhttp://office.microsoft.com/en-us/excel-help/trend-HP005209320.aspx if it helps.. Rgds//Vabs On Tuesday, September 25, 2012 10:40:08 PM UTC+5:30,

Re: $$Excel-Macros$$ Help Need for Vlookup Solution

2012-09-26 Thread amar takale
Hello Vabz Thanks for Logic based on your criterion formula But Can you explain it.What is minus Row 5 Row 10 logic.I cant Understand it.In my data there are 9 column 13 Row but it is different for different name as per. I will use it but not work I use it minus Row 8 in formula But formula

Re: $$Excel-Macros$$ Run-Time Error 3170

2012-09-26 Thread wirelesscellularguy
Hi Swapnil, Thanks for the corrections. I implemented them. I again need your help to pass the Start Date and End Date from the excel to Access Query(as we did for Enter Date Enter Cell, before). In the Criteria, I entered Between [Start Date] And [End Date] but couldn't figure out what the

Re: $$Excel-Macros$$ Run-Time Error 3170

2012-09-26 Thread wirelesscellularguy
Hi Swapnil, With slight modification of the code, i could now pass the Start Date and the End Date Regards, Wireless On Friday, September 14, 2012 1:45:41 PM UTC+5:30, Swapnil Palande wrote: Hi, I don't know exact reason for above error, because when I try to execute code it is giving

$$Excel-Macros$$ Macro running time

2012-09-26 Thread Krishnaraddi V. Madolli
Hi Experts, Can anyone let me know how populate running time of macro. Ex: If I run any macro, At the end of macro I should get how much time it took to complete macro. Regards, Krishnaraddi V Madolli. Data Analytics Team Sedgwick Claims Management Services, Inc. Xchanging Towers, SJR iPark,

Re: $$Excel-Macros$$ Run-Time Error 3170

2012-09-26 Thread Swapnil Palande
try below code: Between cdate('01/08/2012') And cdate('31/08/2012') regards, swapnil. On Wed, Sep 26, 2012 at 2:03 PM, wirelesscellularguy wirelesscellular...@gmail.com wrote: Hi Swapnil, With slight modification of the code, i could now pass the Start Date and the End Date Regards,

Re: $$Excel-Macros$$ Macro running time

2012-09-26 Thread Vabz
Hi Please refer following link for more details: http://www.mrexcel.com/archive/VBA/20164.html Rgds//Vabs On Wednesday, September 26, 2012 3:40:17 PM UTC+5:30, Krishnaraddi V. Madolli wrote: Hi Experts, Can anyone let me know how populate running time of macro. Ex: If I run any

RE: $$Excel-Macros$$ Macro running time

2012-09-26 Thread Krishnaraddi V. Madolli
Thanks, I got it. Regards, Krishnaraddi V Madolli. Data Analytics Team Sedgwick Claims Management Services, Inc. Xchanging Towers, SJR iPark, EPIP Area, Whitefield Bangalore - 560 066. India. Direct Line: +1.800.920.9657 Extn 1915 Switchboard: +90-(0)80-3054 Extn 1915 Email:

Re: $$Excel-Macros$$ Help Need for Vlookup Solution

2012-09-26 Thread Vabz
HI Inn short 5 10 is row no. in which Sam Ram is written. Rgds//Vabs On Wednesday, September 26, 2012 1:31:47 PM UTC+5:30, amar takale wrote: Hello Vabz Thanks for Logic based on your criterion formula But Can you explain it.What is minus Row 5 Row 10 logic.I cant Understand it.In my

RE: $$Excel-Macros$$ circular x axis in excel graph

2012-09-26 Thread Rajan_Verma
Nice Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of David Grugeon Sent: 26 September 2012 6:04 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ circular x axis in

RE: $$Excel-Macros$$ Hiiiiiiiiiii

2012-09-26 Thread Rajan_Verma
You can visit here http://excelpoweruser.wordpress.com/2011/07/20/embaded-flash-object-in-excel / Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: 26 September 2012

$$Excel-Macros$$ Sumif Based on First Number of a Date Range Help Needed

2012-09-26 Thread Matty
I need to sum up a range of data based on multiple criteria using only the first number in a date string. For example I have a range of data I have to sum attached to specific dates. I need to sum the total product for the month and I am trying to base that criteria on the first number in the

RE: $$Excel-Macros$$ Sumif Based on First Number of a Date Range Help Needed

2012-09-26 Thread Rajan_Verma
Would be good if you provide a sample file Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Matty Sent: 26 September 2012 8:07 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Sumif Based

Re: $$Excel-Macros$$ Re: Calculated Field not Working

2012-09-26 Thread SG
any update plz... plz help me to understand this. On Monday, September 24, 2012 9:06:59 PM UTC+5:30, SG wrote: hi Vabz, Still i'm not able to find the difference.Though i have also used the same formula in calculated field in my sheet. Plz let me know...so that i would be able to help it

Re: $$Excel-Macros$$ Sumif Based on First Number of a Date Range Help Needed

2012-09-26 Thread Matty
Here it is. I hope this helps. Using Sheet 2 for the source data to display on Sheet 1. I believe I got as far as I could with the function but also believe it will show you what I am trying to do. I tried using the LEFT function but can't figure out a way to make it work. I am trying to

$$Excel-Macros$$ Urgent required IBM Websphere MQ Consultant - NewYork city

2012-09-26 Thread Gurjan Singh
*Position:*IBM Websphere MQ Consultant *Location: *New York city *Duration:*Long term *Responsibilities * 1. IBM Websphere MQ Series administration and system experience is a must 2. Wide hands-on project experience with MQ Series and Message Broker administration and system on Windows 2003

$$Excel-Macros$$ Urgent required L2 Support Network Engineer - Redmond, WA

2012-09-26 Thread Gurjan Singh
-- Forwarded message -- From: Gurjan Singh garry...@gmail.com Date: Wed, Sep 26, 2012 at 9:49 PM Subject: Urgent required L2 Support Network Engineer - Redmond, WA To: g...@hmgamerica.com, Gurjan Singh garry...@gmail.com *Position: *L2 Support Network Engineer * Location:

RE: $$Excel-Macros$$ Sumif Based on First Number of a Date Range Help Needed

2012-09-26 Thread Rajan_Verma
Hi Use this See the attached =SUMPRODUCT(N(MONTH(Sheet1!$A$3:$A$122)=MONTH(Sheet2!$A61))*OFFSET(INDEX(Sh eet1!$B$2:$R$121,,MATCH(1,N((LEFT(Sheet1!$B$2:$Q$2,LEN(Sheet2!B$4))*1)=B$4), 0)),1,,,SUM(N((LEFT(Sheet1!$B$2:$Q$2,LEN(Sheet2!B$4))*1)=B$4 Regards Rajan verma +91 7838100659

$$Excel-Macros$$ Re: If data validation removed! possible.

2012-09-26 Thread Vabz
Hi, Yes you can do that.. Rgds//Vabs On Wednesday, September 26, 2012 5:27:23 PM UTC+5:30, Mohammed Muneer wrote: Dear Ashish, Can we run the same formula without validation by manual entry into the cells, F5-G5-H5. Please help needed again with small

$$Excel-Macros$$ Re: Urgent required IBM Websphere MQ Consultant - NewYork city

2012-09-26 Thread Vabz
Job posting is prohibited, can we ban him.. On Wednesday, September 26, 2012 9:15:46 PM UTC+5:30, Gurjan Singh wrote: *Position:*IBM Websphere MQ Consultant *Location: *New York city *Duration:*Long term *Responsibilities * 1. IBM Websphere MQ Series administration and system

Re: $$Excel-Macros$$ Sumif Based on First Number of a Date Range Help Needed

2012-09-26 Thread Matty
Genius! Thank you so much! On Wednesday, September 26, 2012 12:31:04 PM UTC-4, Rajan_Verma wrote: *Hi* *Use this* *See the attached* * * *

$$Excel-Macros$$ Urgent required MS Access Developer - METRO AREA,DC

2012-09-26 Thread Gurjan Singh
One of our client is looking for a MS Access Developer The description is: Build an Access DB that will collect and report Mortgage Servicing information. Skill level: Senior (7+ yrs) Skills: - Experience Connecting with external Sybase/Oracle databases - EXTENSIVE MS Access Development -

Re: $$Excel-Macros$$ circular x axis in excel graph

2012-09-26 Thread David Grugeon
I think you can make a list of all 360 points and leave those without data blank Regards David Grugeon On 27 September 2012 03:03, Christi Jacob christi.ja...@gmail.com wrote: Hello Rajan, the result is close to the requirement although it looks like the radar has been rotated by some angle.

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

2012-09-26 Thread Indrajit $nai
*@ Krishna, Sir I'm waiting for your reply. :)* On Tue, Sep 25, 2012 at 11:16 PM, Indrajit $nai talk2indra...@gmail.comwrote: *@ Krishna, thanks for the reply, It working now, but some issue;* * * *1. Through this Master file I'm able to create the slave files, but it's not opening,

Re: $$Excel-Macros$$ read sap ECC6 table content to excel using VBA

2012-09-26 Thread Paul
Hi Don, Is there an address that contains your solution as it does not display in either of the below URLs: http://x61.ch/ee9a3f (google home page) *http://tinyurl.com/85lubjc* (google search using original post title) Thanks. Paul On Saturday, 31 March 2012 13:55:49 UTC+11, George cui

Re: $$Excel-Macros$$ Hiiiiiiiiiii

2012-09-26 Thread VBA VABZ
hi Really nice.. Rgds On Tue, Sep 25, 2012 at 10:41 AM, Amit Desai (MERU) amit.de...@merucabs.com wrote: To all my dear friends, ** ** Nice Excel filewith ABCD on Friendship... Please see the attachment and click on flowers. Best Regards, Amit

Re: $$Excel-Macros$$ Re: need guidance in learning macros and VBA

2012-09-26 Thread vba
Hi Prince, Itz really great source of info. Thanks for sharing.. Cheerz Rgds//Vabs Sent on my BlackBerry® from Vodafone -Original Message- From: Prince Dubey prince141...@gmail.com Sender: excel-macros@googlegroups.com Date: Sun, 23 Sep 2012 06:13:37 To:

Re: $$Excel-Macros$$ Magicc!! juz for fun..

2012-09-26 Thread VBA VABZ
Hi.. I mean u can do this on any excel file.. Rgds On Sat, Sep 22, 2012 at 2:55 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *File??* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com]

$$Excel-Macros$$ VSTO

2012-09-26 Thread joseph . camill
Hi, Does anyone have any VSTO tutorial. Thanks, Joseph Sent on my BlackBerry® from Vodafone -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread

$$Excel-Macros$$ Re: WAV FILES DURATION FINDER

2012-09-26 Thread reshma shri
Hi Bhasker I too am a medical transcriptionist and if its not too much for me to ask can u give the tool u use to find wav file length in XL and explain how to use it. Regards Reshma On Friday, July 9, 2010 6:26:11 PM UTC+5:30, Bhasker wrote: Hi I am a medical transcriptionist by

$$Excel-Macros$$ Help for VBA code (Excel Table copy to word)

2012-09-26 Thread amar takale
Hi All Experts I need VBA code for Excel table paste in word on one click.If I Select Table or range for one or more table Then click Button then automatically Table paste in word with format which format in excel. Regards Amar -- Join official facebook page of this forum @

Re: $$Excel-Macros$$ VBA Macro

2012-09-26 Thread Swapnil Palande
Hi Shrinivas, Can u provide code. Regards, Swapnil. On Thu, Sep 27, 2012 at 9:14 AM, Shrinivas Shevde shrinivas...@gmail.comwrote: Dear All Some days back I was trying to write macro and I could write small macro. While practising many times I found Error messagr Like Run Time Error 402