Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 13Messages in 9 Topics

2010-10-06 Thread kurt . brannigan
Sent via BlackBerry by AT&T -Original Message- From: excel-macros+nore...@googlegroups.com Sender: excel-macros@googlegroups.com Date: Wed, 06 Oct 2010 23:25:47 To: Digest Recipients Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Digest for excel-macros@googlegroups.co

Re: $$Excel-Macros$$ Re: Need next number with a twist

2010-10-06 Thread None
If the max function gets me the results I want, I'm certainly open to it.  :)  From: Paul Schreiner To: excel-macros@googlegroups.com Sent: Wed, October 6, 2010 4:17:15 AM Subject: Re: $$Excel-Macros$$ Re: Need next number with a twist I cannot see how there

$$Excel-Macros$$ Macro VBA help - Dynamic Range & limit to last cell

2010-10-06 Thread DaveK
Attached is the macro code I need help with. I want to define the end of the range (to the last occupied cell) in the code. currently the range is fixed based upon the initial use of code.(I attached a listing of the code to reference). Can anyone assist? Thx in advance! Dave Sub Macro_PMT() ' '

$$Excel-Macros$$ Hi Sir, I need your Help

2010-10-06 Thread neil johnson
Hi Pandey Sir, We are very lucky and we would like to appreciate to you because we are getting more solution from you of any query in excel. Sir I need your help I want to make dashboard in excel . Can you suggest me or send me excel sheet .( dashboard excel sheet). Thanks -- ---

Re: $$Excel-Macros$$ write to end of page to foot total

2010-10-06 Thread P.VIJAYKUMAR
Hello, You can link the total of the first page to the following page by keeping = and selecting the previous page total to next page opening balance total. this is Explained by the attached sheet. Regards, VIJAY KUMAR -- -

$$Excel-Macros$$ write to end of page to foot total

2010-10-06 Thread fill brain
Hi Genius of Excel , I have a list and that list have more or less 10.000 rows data and 5 columns.. that list headers are, 1- ID 2- Name 3- Surname 4 - Total Dept 5 - Current Month Payment and i have to print that list but i have to add to foot total of page's foot and i have to show up of foll

RE: $$Excel-Macros$$ Excel Advance Formula Reference Guide

2010-10-06 Thread عمر
It makes excel stop working From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Deepak Rai Sent: Tuesday, October 05, 2010 9:07 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Excel Advance Formula Reference Guide Hi All, I would like to s

Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 20 10

2010-10-06 Thread NOORAIN ANSARI
Dear Ayush, You really deserve for this great achievment. Pls accept my hearty Congratulations. Noorain Ansari On Sun, Oct 3, 2010 at 3:17 AM, Ayush wrote: > Dear Group, > > I am proud to announce that I am awarded Microsoft Most Valuable > Professional MVP on October 01, 2010 for providing t

$$Excel-Macros$$ Re: Ayush Jain – Microsoft MVP 20 10

2010-10-06 Thread Yogesh Kudva
Hi Ayush, Heartiest Congratulations Regards, Yogesh Kudva On Oct 3, 3:17 pm, Ayush wrote: > Dear Group, > > I am proud to announce that I am awarded Microsoft Most Valuable > Professional MVP on October 01, 2010 for providing technical expertise > in Excel technical communities for past on

$$Excel-Macros$$ Re: VBA Passward

2010-10-06 Thread Jacob
Push Alt + F11 to open VBE in VBE go to Tools -> VBA Project Properties -> Click on the Protection tab -> Enter password twice. Click the box "Lock project for viewing" if you don't want someone to see your code. Click ok. Save the workbook and close out. The next you come back in the VBA Project

Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 20 10

2010-10-06 Thread Dilip Pandey
Well deserved. . . Heartiest congratulations. Keep up the good show :) My best wishes to you. Best Regards, DILIPandey On 10/3/10, Ayush wrote: > Dear Group, > > I am proud to announce that I am awarded Microsoft Most Valuable > Professional MVP on October 01, 2010 for providing technical exper

Re: $$Excel-Macros$$ Top Poster of the month(Sep10) :- Dilip Pandey and Paul Schreiner

2010-10-06 Thread Dilip Pandey
Hey Ayush, Many Thanks to you n "Group" . . . . :) Warmest Regards, DILIPandey On 10/5/10, Ayush wrote: > Dear Group, > > I am very happy to announce that Dilip and Paul are the top poster for > the month of September'10. They are the joint winners with 22 post > each. They both are all time p

Re: $$Excel-Macros$$ pipe (|) delimited text file filtered country wise

2010-10-06 Thread Paul Schreiner
How about the some of the (|) delimeted source file? I don't need to bring it into Excel... Paul > >From: SUMIT VYAS >To: excel-macros@googlegroups.com >Sent: Wed, October 6, 2010 7:36:10 AM >Subject: Re: $$Excel-Macros$$ pipe (|) delimited text file filtered country wise > > > > >On 10/6/10,

Re: $$Excel-Macros$$ VBA Passward

2010-10-06 Thread SUMIT VYAS
Dear SX0123456789X On 10/6/10, Jai wrote: > > > I need VBA Passward in Excel , Because When Anybody open in excel file he > want VBA Passward . > > > Thaks in Advance > > > > -- > Thanks For Mail. > > > -- > > -- >

Re: $$Excel-Macros$$ Re: Need next number with a twist

2010-10-06 Thread Paul Schreiner
I cannot see how there could be a formula option because it needs to iterate (loop) through the previous values to check for duplicates. Now, if instead it were acceptable to use the max() function, then  it would be possible to get unique values, but depending on the sort state of the data, the

Re: $$Excel-Macros$$ pipe (|) delimited text file filtered country wise

2010-10-06 Thread Paul Schreiner
Can you send us a few lines of the file? I can write the code to split the file. Paul > >From: pankaj gmail account >To: excel-macros@googlegroups.com >Sent: Wed, October 6, 2010 1:27:29 AM >Subject: Re: $$Excel-Macros$$ pipe (|) delimited text file filtered country wise > > >Please help > >Pa

$$Excel-Macros$$ VBA Passward

2010-10-06 Thread Jai
I need VBA Passward in Excel , Because When Anybody open in excel file he want VBA Passward . Thaks in Advance -- Thanks For Mail. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tr

$$Excel-Macros$$ Re: Microsoft Excel help needed for newbe

2010-10-06 Thread anandydr
Dear Dean Brown, We would be glad to provide whatever support we can. Please feel free to post your queries. Warm regards, Anand Kumar On Oct 5, 11:53 am, Dean Brown wrote: > Hi group. > > I'm by no means a programmer. I'm trying to knock together a (what > should be) simple spreadsheet in Micr