Follow Noorain's method...
On Fri, Jun 8, 2012 at 11:07 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
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
Thanks All !!!
On Fri, Jun 8, 2012 at 3:27 PM, Anoop K Sharma aks.sharm...@gmail.comwrote:
Follow Noorain's method...
On Fri, Jun 8, 2012 at 11:07 AM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Yes, Sure Vivek it is possible..
Please use
=vlookup(Lookup value,Index File
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
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
fuck off, and never sand that forrever ok?
2012/6/8 Mangesh Dayne mangesh.da...@gmail.com
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
Dear Ayush,
Please ban below email ID
vzukauskien...@gmail.com
On Fri, Jun 8, 2012 at 5:07 PM, Deba Ranjan drdeva...@gmail.com 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
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 noorain.ans...@gmail.comwrote:
Dear Ayush,
Please ban below email ID
vzukauskien...@gmail.com
On Fri, Jun 8, 2012 at 5:07 PM,
Ban Her.
On Fri, Jun 8, 2012 at 5:13 PM, Mangesh Dayne mangesh.da...@gmail.comwrote:
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
noorain.ans...@gmail.comwrote:
I m so sorry for this accident it was fully
2012/6/8 vijayajith VA vijayajith...@gmail.com
Ban Her.
On Fri, Jun 8, 2012 at 5:13 PM, Mangesh Dayne mangesh.da...@gmail.comwrote:
Such people should be ban for lifetime from this group. And I request you
to please do needful.
Thanks.
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 drdeva...@gmail.com wrote:
Its a awesome design. Can you please tell me , in the sheet, we are
unable to view the sheets, i mean, Even we
Dear Deba,
Please see attached sheet,
If you have any query, Please reply
On Fri, Jun 8, 2012 at 7:37 PM, Deba Ranjan drdeva...@gmail.com 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
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 noorain.ans...@gmail.comwrote:
Dear Deba,
Please see attached sheet,
If you have any
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 drdeva...@gmail.com wrote:
Sir,
The file you have attached is the same that i
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
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
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
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 drdeva...@gmail.com wrote:
Thanks ,
It is possible for A2:A7 range including with E3,
i mean for E3, its fine,
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 resp...@gmail.com wrote:
select all the cells, press ctrl +1 go to the protection tab, uncheck
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
Thanks All for their genuine help !!!
Mangesh.
On Fri, Jun 8, 2012 at 7:53 PM, dguillett1 dguille...@gmail.com 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
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
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 BANNED
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 rajanverma1...@gmail.comwrote:
It’s a spam I think
** **
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
** **
*From:*
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
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
Hilary from Ghana. A stockbroker. Interest is excel and football.
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Ayush Jain jainayus...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Fri, 8 Jun 2012 12:21:59
To: excel-macros@googlegroups.com
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 cross
Thanks Lovely members.
Thanks Regards,
*Deba Ranjan P*
On Fri, Jun 8, 2012 at 8:01 PM, dguillett1 dguille...@gmail.com wrote:
Unlock all you want to allow
lock that one
protect sheet
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
*From:* Deba
28 matches
Mail list logo