Thanks Lovely members.
Thanks & Regards,
*Deba Ranjan P*
On Fri, Jun 8, 2012 at 8:01 PM, dguillett1 wrote:
> Unlock all you want to allow
> lock that one
> protect sheet
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Deba Ranjan
> *Sen
Thanks guys for your support.
I have banned that user.
Regards
Ayush Jain
On Friday, 8 June 2012 21:50:25 UTC+5:30, sandeep chhajer wrote:
> Hi Ayush, Noorain and all mentor,
>
> You all are the best mind in the field of Information Technology. So
> please do needful to stop this type of cro
Hilary from Ghana. A stockbroker. Interest is excel and football.
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Ayush Jain
Sender: excel-macros@googlegroups.com
Date: Fri, 8 Jun 2012 12:21:59
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Ex
Hi Ayush, Noorain and all mentor,
You all are the best mind in the field of Information Technology. So please do
needful to stop this type of cross advertising and abuses.(Happened on today
morning by Viktorija Zukauskiene ). We have an esteemed group so I am urging
every true member of this gr
At any rate it is advertising unrelated to the group.
Date: Fri, 8 Jun 2012 21:47:27 +0530
Subject: Re: $$Excel-Macros$$ RE: FW: hi there...
From: mangesh.da...@gmail.com
To: excel-macros@googlegroups.com
Yes, sure and please think on it how to protect this group from such spams.
Mangesh
On Fr
Yes, sure and please think on it how to protect this group from such spams.
Mangesh
On Fri, Jun 8, 2012 at 9:29 PM, Rajan_Verma wrote:
> It’s a spam I think
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com
It's a spam I think
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: 08 June 2012 9:27
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ RE: FW: hi there...
Pleas
Please post ur query
On Fri, Jun 8, 2012 at 9:18 PM, OfficeVba Trainer <
officevbatrai...@yahoo.com> wrote:
> Thanks to Bed Defense! They saved my sister and I from our buildings
> bedbug infestation!!
> http://socjologia.c0.pl/lastnews/94RichardAlien/
>
> --
> FORUM RULES (986+ members already B
Hi Hilary
You can take idea from this file.
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of hilary lomotey
Sent: 08 June 2012 6:56
To: excel-macros
Subject: $$Excel-Macros$$ Sorting Alphabetically wi
Thanks All for their genuine help !!!
Mangesh.
On Fri, Jun 8, 2012 at 7:53 PM, dguillett1 wrote:
> Create combobox1 in sheet1 and then put this code in the SHEET module
>
> Private Sub Worksheet_Activate()
> Sheet1.ComboBox1.Clear
> Dim sh As Worksheet
> For Each sh In Worksheets
> Sheet1.Com
Unlock all you want to allow
lock that one
protect sheet
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Deba Ranjan
Sent: Friday, June 08, 2012 9:07 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Edit Cell
Dear
Its is possible to Lock a
Yes, Yes, its superb working thanks for the guides...Tnks Hilary &
Noorain and Rest of this members.
Thanks & Regards,
*Deba Ranjan P*
On Fri, Jun 8, 2012 at 7:52 PM, hilary lomotey wrote:
> select all the cells, press ctrl +1 go to the protection tab, uncheck the
> lock button
Dear Deba,
Please check below link..
http://www.lytebyte.com/2009/06/15/how-to-protect-only-certain-cells-columns-or-rows-in-excel/
On Fri, Jun 8, 2012 at 7:50 PM, Deba Ranjan wrote:
> Thanks ,
>
> It is possible for A2:A7 range including with E3,
>
> i mean for E3, its fine, It s possible f
Create combobox1 in sheet1 and then put this code in the SHEET module
Private Sub Worksheet_Activate()
Sheet1.ComboBox1.Clear
Dim sh As Worksheet
For Each sh In Worksheets
Sheet1.ComboBox1.AddItem (sh.Name)
Next
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From
select all the cells, press ctrl +1 go to the protection tab, uncheck the
lock button, click ok, and then select the cell you want to lock and click
on ctrl +1 go to protection tab and check lock. click ok, go to review
ribbon and click on protect , ok, you shd be fine
On Fri, Jun 8, 2012 at 2:17
Thanks ,
It is possible for A2:A7 range including with E3,
i mean for E3, its fine, It s possible for A2 to A7 also the same lock.
Please sir, Explain in details how you did !!!
Thanks & Regards,
*Deba Ranjan P*
On Fri, Jun 8, 2012 at 7:47 PM, NOORAIN ANSARI wrote:
> Hi Deba,
>
>
thanks Noorain for the examples really grateful, however, i noticed that
you still have to use COUNTIF($O$29:$O$44,"<="&O29) in other to be able
to sort,ie the sumproduct etc are all dependent on it.
THE PROBLEM WITH THE SHEET I AM WORKING IN IS THAT IT DOESNT BEGIN WITH 1
IF I USE THE COUNTIF
Hi Deba,
Please check cell no. E3 in Sheet1, It is working fine with me.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Fri, Jun 8, 2012 at 7:43 PM, Deba Ranjan wrote:
> Sir,
>
>The file you have attached is the same that i have attached. P
Sir,
The file you have attached is the same that i have attached. Please
kindly check. Thanks for the same.
Thanks & Regards,
*Deba Ranjan P*
On Fri, Jun 8, 2012 at 7:41 PM, NOORAIN ANSARI wrote:
> Dear Deba,
>
> Please see attached sheet,
>
> If you have any query, Please reply
>
>
Dear Deba,
Please see attached sheet,
If you have any query, Please reply
On Fri, Jun 8, 2012 at 7:37 PM, Deba Ranjan wrote:
> Dear
>
> Its is possible to Lock a particular cell only, I mean user cant
> able to edit this cell only, rest they can able to edit. Even the E3 cell
> should
Dear
Its is possible to Lock a particular cell only, I mean user cant
able to edit this cell only, rest they can able to edit. Even the E3 cell
should not be able to edit, Rest can be edit. Please see the attached.
thank you.
Thanks & Regards,
*Deba Ranjan P*
--
FORUM RULES (98
Así que no te gusta lo nuevo.
On Fri, Jun 8, 2012 at 7:32 PM, Mangesh Vimay wrote:
> Viktorija Zukauskiene ,
>
> You should know at least what u r writing and on what platform. It's
> platform for Excel lovers not the people like u who believes in such things.
>
>
>
> On Fri, Jun 8, 2012 at 5:3
Viktorija Zukauskiene ,
You should know at least what u r writing and on what platform. It's
platform for Excel lovers not the people like u who believes in such things.
On Fri, Jun 8, 2012 at 5:32 PM, Anil Gawli wrote:
> see the attached data for your reference.
> Gawli Anil
>
> On Fri, Jun
Thanks, Dave, but its not working, could you kindly do it in the sheet and
send back? thnks
On Fri, Jun 8, 2012 at 1:36 PM, David Grugeon wrote:
> Hi Hilary
>
> Use the SMALL function starting with 1 and increasing it each time.
>
>
> On 8 June 2012 23:25, hilary lomotey wrote:
>
>> Hi Experts
Hi Hilary,
Please find attached sorting sheet, Which have many example to sorting data
through formula. Hope it will help to you.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Fri, Jun 8, 2012 at 7:06 PM, David Grugeon wrote:
> Hi Hilary
>
> Us
Hi Hilary
Use the SMALL function starting with 1 and increasing it each time.
On 8 June 2012 23:25, hilary lomotey wrote:
> Hi Experts
>
> i am trying to sort alphabetically with a formula in the attached sheet in
> column "O", i tried using COUNTIF($O$29:$O$44,"<="&O29) to get the first
> numb
Thanks Bhai.
Thanks & Regards,
*Deba Ranjan P*
On Fri, Jun 8, 2012 at 6:32 PM, NOORAIN ANSARI wrote:
> See attachment
>
>
> On Fri, Jun 8, 2012 at 6:30 PM, Deba Ranjan wrote:
>
>> i am sorry sir, i can't get you please.
>>
>>
>> On Fri, Jun 8, 2012 at 6:29 PM, NOORAIN ANSARI
>> wro
i am sorry sir, i can't get you please.
On Fri, Jun 8, 2012 at 6:29 PM, NOORAIN ANSARI wrote:
> Dear Deba,
>
> Please check here..
>
>
>
>
> On Fri, Jun 8, 2012 at 4:25 PM, Deba Ranjan wrote:
>
>> Its a awesome design. Can you please tell me , in the sheet, we are
>> unable to view the she
Dear Deba,
Please check here..
On Fri, Jun 8, 2012 at 4:25 PM, Deba Ranjan wrote:
> Its a awesome design. Can you please tell me , in the sheet, we are
> unable to view the sheets, i mean, Even we insert sheet, we are unable to
> see the sheet. Please explain me on this. Its make me ve
Thanks you Dear Anil. thanks.
Thanks & Regards,
*Deba Ranjan P*
On Fri, Jun 8, 2012 at 5:48 PM, Anil Gawli wrote:
> Dear Deba
>
> Goto Options, Advanced and there u'll find Show Sheet Tabs checkbox option
> Regards
> Gawli Anil
>
> On Fri, Jun 8, 2012 at 4:25 PM, Deba Ranjan wrote:
>
Dear Deba
Goto Options, Advanced and there u'll find Show Sheet Tabs checkbox option
Regards
Gawli Anil
On Fri, Jun 8, 2012 at 4:25 PM, Deba Ranjan wrote:
> Its a awesome design. Can you please tell me , in the sheet, we are
> unable to view the sheets, i mean, Even we insert sheet, we ar
I m so sorry for this accident it was fully
2012/6/8 vijayajith VA
> Ban Her.
>
>
> On Fri, Jun 8, 2012 at 5:13 PM, Mangesh Dayne wrote:
>
>> Such people should be ban for lifetime from this group. And I request you
>> to please do needful.
>>
>> Thanks.
>>
>>
>> Mangesh
>>
>>
>> On Fri,
Ban Her.
On Fri, Jun 8, 2012 at 5:13 PM, Mangesh Dayne wrote:
> Such people should be ban for lifetime from this group. And I request you
> to please do needful.
>
> Thanks.
>
>
> Mangesh
>
>
> On Fri, Jun 8, 2012 at 5:08 PM, NOORAIN ANSARI
> wrote:
>
>> Dear Ayush,
>>
>> Please ban belo
Such people should be ban for lifetime from this group. And I request you
to please do needful.
Thanks.
Mangesh
On Fri, Jun 8, 2012 at 5:08 PM, NOORAIN ANSARI wrote:
> Dear Ayush,
>
> Please ban below email ID
> vzukauskien...@gmail.com
>
>
> On Fri, Jun 8, 2012 at 5:07 PM, Deba Ranjan wrote:
Dear Ayush,
Please ban below email ID
vzukauskien...@gmail.com
On Fri, Jun 8, 2012 at 5:07 PM, Deba Ranjan wrote:
> i agree with Mangesh. its seems very critical abuse word.
>
>
> Thanks & Regards,
> *Deba Ranjan P*
>
>
>
>
>
> On Fri, Jun 8, 2012 at 4:50 PM, Mangesh Dayne wrote:
>
>> What
i agree with Mangesh. its seems very critical abuse word.
Thanks & Regards,
*Deba Ranjan P*
On Fri, Jun 8, 2012 at 4:50 PM, Mangesh Dayne wrote:
> What do u say so...
> It shouldn't happen
>
>
> On Fri, Jun 8, 2012 at 4:49 PM, Viktorija Zukauskiene <
> vzukauskien...@gmail.com>
What do u say so...
It shouldn't happen
On Fri, Jun 8, 2012 at 4:49 PM, Viktorija Zukauskiene <
vzukauskien...@gmail.com> wrote:
> fuck off, and never sand that forrever ok?
>
>
> 2012/6/8 Mangesh Dayne
>
>> Hi Friends,
>>
>>
>> I have to add combo box in a sheet that will contain all s
fuck off, and never sand that forrever ok?
2012/6/8 Mangesh Dayne
> Hi Friends,
>
>
> I have to add combo box in a sheet that will contain all sheets name and
> when i select the any sheet name in combo box, it will activate in the
> workbook, means I can able to see the contents of sheet simply
Hi Friends,
I have to add combo box in a sheet that will contain all sheets name and
when i select the any sheet name in combo box, it will activate in the
workbook, means I can able to see the contents of sheet simply by selecting
the sheet from combo box list. Moreover, combo box should automat
Its a awesome design. Can you please tell me , in the sheet, we are
unable to view the sheets, i mean, Even we insert sheet, we are unable to
see the sheet. Please explain me on this. Its make me very interesting
parts. !!
Thanks & Regards,
*Deba Ranjan P*
On Thu, Jun 7, 2012 at 6
Thanks All !!!
On Fri, Jun 8, 2012 at 3:27 PM, Anoop K Sharma wrote:
> Follow Noorain's method...
>
>
> On Fri, Jun 8, 2012 at 11:07 AM, NOORAIN ANSARI
> wrote:
>
>> Yes, Sure Vivek it is possible..
>> Please use
>>
>> =vlookup(Lookup value,Index File refernce,File No.,0)
>>
>> it will better i
Follow Noorain's method...
On Fri, Jun 8, 2012 at 11:07 AM, NOORAIN ANSARI wrote:
> Yes, Sure Vivek it is possible..
> Please use
>
> =vlookup(Lookup value,Index File refernce,File No.,0)
>
> it will better if you share a sample workbook with group
>
>
>
> On Fri, Jun 8, 2012 at 10:12 AM, vivek
42 matches
Mail list logo
