Re: $$Excel-Macros$$ Fwd: Need help on a formula

2012-08-25 Thread ashish koul
see if it helps On Sun, Aug 26, 2012 at 9:40 AM, hemant shah wrote: > Dear Experts, > > I haven't yet received solution for my query below. > > Please help. > > Regards, > > -- Forwarded message -- > From: hemant shah > Date: Sun, Aug 19, 2012 at 12:56 PM > Subject: Need help

Re: $$Excel-Macros$$ Fwd: Need help on data

2012-05-10 Thread Lokesh Loki
> Wishing you a great day! > > Asa > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Bé Tr?n Van > *Sent:* Wednesday, May 09, 2012 8:40 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$

RE: $$Excel-Macros$$ Fwd: Need help on data

2012-05-09 Thread Asa Rossoff
! Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Bé Tr?n Van Sent: Wednesday, May 09, 2012 8:40 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Fwd: Need help on data 2012/5/9 Lokesh Loki Hai Anil, Thanks for resolving

Re: $$Excel-Macros$$ Fwd: Need help on data

2012-05-09 Thread Bé Trần Văn
2012/5/9 Lokesh Loki > Hai Anil, > > Thanks for resolving the query and thanks for advising me about the user > form. > > Once again thank a lot experts. > > Regards > Lokesh.M > > On Wed, May 9, 2012 at 2:42 PM, Anil Gawli wrote: > >> Attached is the workbook and go to Calculation worksheet. >>

Re: $$Excel-Macros$$ Fwd: Need help on data

2012-05-09 Thread Lokesh Loki
Hai Anil, Thanks for resolving the query and thanks for advising me about the user form. Once again thank a lot experts. Regards Lokesh.M On Wed, May 9, 2012 at 2:42 PM, Anil Gawli wrote: > Attached is the workbook and go to Calculation worksheet. > > > > > > > On Wed, May 9, 2012 at 6:01 AM,

Re: $$Excel-Macros$$ Fwd: Need help on data

2012-05-08 Thread David Grugeon
Hi Lokesh I do not think you will get a reply from this group to to your question as it is. What you are asking for is more in the nature of application design and that is not a quick and simple answer to a question. This group exists to help people who are having problems with VBA in Excel. Whi

RE: $$Excel-Macros$$ Fwd: Need help on data

2012-05-08 Thread Asa Rossoff
Hello Lokesh, You may want to try Debra Dalgleish and Dave Petersen's method detailed here: http://contextures.com/exceldataentryupdateform.html Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Lokesh Loki Sent: Tuesday, May 08, 2012 7:30 AM To: e

Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba

2012-02-03 Thread Darwin Chan
*From:* excel-macros@googlegroups.com [mailto: >>> excel-macros@googlegroups.com] *On Behalf Of *rekha siri >>> *Sent:* Jan/Sun/2012 04:47 >>> *To:* excel-macros@googlegroups.com >>> *Subject:* Re: $$Excel-Macros$$ Fwd: Need help in building pivot usi

Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba

2012-01-22 Thread rekha siri
>> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *rekha siri >> *Sent:* Jan/Sun/2012 04:47 >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$ Fwd: Need help in building pivot

Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba

2012-01-22 Thread rekha siri
marySheet.. > > Rajan. > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *rekha siri > *Sent:* Jan/Sun/2012 04:47 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Fwd: Need help in building piv

RE: $$Excel-Macros$$ Fwd: Need help in building pivot using vba

2012-01-22 Thread Rajan_Verma
Hi rekha. I clearly mention that don't delete the summarySheet.. Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of rekha siri Sent: Jan/Sun/2012 04:47 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Fwd: Need help in building

Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba

2012-01-22 Thread rekha siri
Rajan, i Tried removing the sheets and tried executing this macro bt it is not executing. Please fix this... Thanks alot for your help in this concern. On Sun, Jan 22, 2012 at 3:13 PM, Rajan_Verma wrote: > Hi Rekha > > See the attached sheet.. > > Don’t delete SUmmarySheet > > ** *

Re: $$Excel-Macros$$ Fwd: Need Help

2011-04-06 Thread Prathima R
Thanks alot Daniel On Mon, Apr 4, 2011 at 2:38 PM, Daniel wrote: > Hi, > > Paste this macro in the first workbook. Open it manually and run the “Test” > macro. > > > > Sub test() > > Dim lgRow As Long, sh As Worksheet, c As Range, rg As Range > > Const strPath As String = "D:\Donnees\Daniel\mpfe

RE: $$Excel-Macros$$ Fwd: Need Help

2011-04-04 Thread Daniel
Hi, Paste this macro in the first workbook. Open it manually and run the “Test” macro. Sub test() Dim lgRow As Long, sh As Worksheet, c As Range, rg As Range Const strPath As String = "D:\Donnees\Daniel\mpfe\Prathima R\" 'to be modified Dim inCalculationMode As Integer Application.ScreenUp

Re: $$Excel-Macros$$ Fwd: need help

2011-01-19 Thread lucky singh
thanx ashish will try this code i also wanted formula to extract only the 10 digit mobile numbers from the data list + 022-2 Ex-6432341 ~+ 9870188646 + 022-2 Ex-6487723 + 022-2 Ex-6658518 ~+ 9821916656 + 022-2 Ex-6795123 + 0251- Ex-2311543 ~+ 9869478989 ~+ 2311543 +91 (022) 99

Re: $$Excel-Macros$$ Fwd: need help

2011-01-18 Thread lucky singh
sorry ashish, the file is not working when i click on update it opens a pop up says read only, notify & cancel... Regards, On Tue, Jan 18, 2011 at 8:56 PM, ashish koul wrote: > check the attachment > > On Tue, Jan 18, 2011 at 12:20 PM, lucky singh wrote: > >> >> Hello, >> >> Guys Need you

Re: $$Excel-Macros$$ Fwd: need help

2011-01-18 Thread ashish koul
check the attachment On Tue, Jan 18, 2011 at 12:20 PM, lucky singh wrote: > > Hello, > > Guys Need your help urgently > > please > > Regrads > > -- Forwarded message -- > From: lucky singh > Date: Tue, Jan 18, 2011 at 10:51 AM > Subject: need help > To: excel-macros@googleg

Re: $$Excel-Macros$$ Fwd: need help

2011-01-08 Thread Prathima R
Thanks alot ashish its excellent.. On Sat, Jan 8, 2011 at 3:10 PM, ashish koul wrote: > check the attachment see if it helps > > > On Sat, Jan 8, 2011 at 11:12 AM, Rajasekhar Praharaju < > rajasekhar.prahar...@gmail.com> wrote: > >> Please find the attached sheet i could able to b

Re: $$Excel-Macros$$ Fwd: need help

2011-01-08 Thread ashish koul
check the attachment see if it helps On Sat, Jan 8, 2011 at 11:12 AM, Rajasekhar Praharaju < rajasekhar.prahar...@gmail.com> wrote: > Please find the attached sheet i could able to build formula for single > line item > > But i want if the criteria is having mulitple line items the results should

Re: $$Excel-Macros$$ Fwd: need help

2011-01-07 Thread Rajasekhar Praharaju
Please find the attached sheet i could able to build formula for single line item But i want if the criteria is having mulitple line items the results should display as Date description, Date description, Date description. Please help me in this concern, Thanks, Raj On Sat, Jan 8, 2011 at 10:4