Hi Anil
find attach workbook to unprotect worksheet
HTH
Mahesh
On Sat, Oct 8, 2011 at 2:58 AM, ChilExcel wrote:
> hi Dilip
>
>
> straxx password ,,does not work, this discontinued
> Chilexcel
>
>
> 2011/10/7 ChilExcel
>
>> Please see attachment
>>
>>
>>
>>
>>
>>
>> 2011/10/7 Bé Trần Vă
I believe the forum is not able to comprehend what 'can i get excel to read
a menu with selections using "X" in a cell' is trying to convey. Maybe you
want to rephrase it, or share an example of what you are trying to do.
Sam
On Fri, Oct 7, 2011 at 10:55 PM, Monizri wrote:
> Hi, I have the foll
Hi, I have the following code that searches for data based on what i
type in it (in this case it is "FHCX") and posts it in a new sheet.
How can i get excel to read a menu with selections using "X" in a cell
and feed it into the code below to produce results on a new tab?
Sub ServiceReport()
'
Hi, Karan,
Not a good one, but try this Array Formula,
If you are using XL 2003 or prior,
=MAX(IF(ISNUMBER(MID(SUBSTITUTE(A2,"
",""),ROW(INDIRECT("1:"&LEN(A2))),{6,7})+0),MID(SUBSTITUTE(A2,"
",""),ROW(INDIRECT("1:"&LEN(A2))),{6,7})+0))
If you are on XL 2007 or later,
=MAX(IFERROR(MID(SUBSTIT
hi Dilip
straxx password ,,does not work, this discontinued
Chilexcel
2011/10/7 ChilExcel
> Please see attachment
>
>
>
>
>
>
> 2011/10/7 Bé Trần Văn
>
>>
>>
>> 2011/10/7 Dilip Pandey
>>
>>> Hi Anil,
>>>
>>> see the below link.
>>> www.straxx.com/excel/password.html
>>>
>>> Regards,
>
Please see attached
for unlock sheets..
2011/10/7 ChilExcel
> that is what you need???
>
> remove password of book?
> or unlock leaves?
>
>
> Please attach file
>
>
> chilexcel
>
> 2011/10/7 GoldenLance
>
>> To unprotect sheet / workbook structure protection, th
Please see attachment
2011/10/7 Bé Trần Văn
>
>
> 2011/10/7 Dilip Pandey
>
>> Hi Anil,
>>
>> see the below link.
>> www.straxx.com/excel/password.html
>>
>> Regards,
>> DILIPandey
>> On 7 Oct 2011 13:12, "anil kumar" wrote:
>>
>>> Hello everybody,
>>>
>>> I have a excel file in which i
that is what you need???
remove password of book?
or unlock leaves?
Please attach file
chilexcel
2011/10/7 GoldenLance
> To unprotect sheet / workbook structure protection, this should help.
> however, this will not open the workbook, if you have protected the
> file.
>
> http://www.strax
2011/10/7 Dilip Pandey
> Hi Anil,
>
> see the below link.
> www.straxx.com/excel/password.html
>
> Regards,
> DILIPandey
> On 7 Oct 2011 13:12, "anil kumar" wrote:
>
>> Hello everybody,
>>
>> I have a excel file in which i use protect op. but I have forgot password.
>> becoz i use this file so
Excellent! Thank you Haseeb, that works like a charm. Thank you for you
help.
John
On Fri, Oct 7, 2011 at 2:02 PM, Haseeb Avarakkan wrote:
> Hi John,
>
> Try these,
>
> K3, copy down.
>
> =LOOKUP(LOOKUP(9E+300,C3:J3),N3:X3,N$2:X$2)
>
> L3, copy down.
>
> =LOOKUP(LOOKUP(9E+300,C3:J3),Z3:AJ3
Hi John,
Try these,
K3, copy down.
=LOOKUP(LOOKUP(9E+300,C3:J3),N3:X3,N$2:X$2)
L3, copy down.
=LOOKUP(LOOKUP(9E+300,C3:J3),Z3:AJ3,Z$2:AJ$2)
This will look the last entered value.
HTH
Haseeb
--
--
Some important
*2011* * * PictOld *Achievement (1-10)* PictOld *Improvement
(0-9)* *Jan-Mar* *Apr-Jun* *July-Aug* *Jul-Dec* *Jul11-Mar12* 100.00%
100.00% 100.00% 10 9
Yes, I want the formula to pick up the last entered value on the right (the
next period would be blank like the BLUE cell above).
You are welcome John.
In order to include next set of data we can use defined name(s) but for this
to work, we need to create a locator cell, refrencing which Excel can
understand which period to pick up as I am not sure if you want right most
data to be picked up always.
Share your thoughts and
And if that doesn't work, from my experience, this normally goes away once
you've restarted the operating system.
Regards,
Sam
On Fri, Oct 7, 2011 at 4:05 PM, Paul Schreiner wrote:
> You said that it stops at a "random" point.
> It it the same point every time? or a different ("random") point?
Sam,
Thanks for your solution. I got it to work and with the modification
suggested by DILIPandey, it does what I wanted. I just have to be
careful that my user enters "5%" and not "=5%".
The "track changes", while interesting and will be used in the future,
didn't fit because the formulas can be
Dear all,
Sometimes I work with large data, if i want to find some data,
normally I type the key word in find option, I want to highlight the
cell with some colour to view it clearly, which cell is highlighted.
Normally it goes to cell but i have some problem ( eye sight).
Thanks in advance
--
GoldenLance,
I attached the example. It was detailed in the attachment.
John
On Fri, Oct 7, 2011 at 8:53 AM, GoldenLance wrote:
> You might want to clarify 'I need the formula for the GREEN cells to
> lookup the value in the appropriate table', with an example.
>
> On Oct 7, 5:44 pm, "John A.
Hello Ashish,
Thanks a lot its working fine may I know is there any materials to learn
macros based on powerpoint and msword.
Thanks in advance.
Regards,
Chandra Shekar B
On Fri, Oct 7, 2011 at 7:48 AM, Chandra Shekar wrote:
> Hello Ashish,
>
> Thanks a lot its working fine may I know is t
http://www.box.net/shared/q6id1k3plhn3avp7q6gt
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.
http://www.box.net/shared/q6id1k3plhn3avp7q6gt/1/122013897/969991807
HI
Here is the file of the Grade 8 schedule which I want to generate the same
stats as the Grade 9 sheet does
Yours sincerely
Shane
--
--
Some
http://www.box.net/shared/q6id1k3plhn3avp7q6gt/1/122013897/969991807
Here is the grade 8 file I want to generate the same Stats as the grade 9
file
--
--
Some important links for excel users:
1. Follow us on TWITT
You might want to clarify 'I need the formula for the GREEN cells to
lookup the value in the appropriate table', with an example.
On Oct 7, 5:44 pm, "John A. Smith" wrote:
> I need the formula to lookup a value in a table and return the table column
> header value. Please see attached spread she
I need the formula to lookup a value in a table and return the table column
header value. Please see attached spread sheet.
Thank you for your kind help.
John
--
--
Some important links for excel users:
1. Follow u
http://www.box.net/shared/q6id1k3plhn3avp7q6gt
Hi
Here is the link above to the files I was talking about, I need a formula to
work the stats for me for Grade 8 just like the grade 9 sheet does
--
--
Some impo
http://www.box.net/shared/q6id1k3plhn3avp7q6gt
Here is the link, I want the stats to worked out for Grade 8 the same as it
is done for Grade 9. .PLEASE assist.
Yours sincerely
Shane
--
--
Some important li
You said that it stops at a "random" point.
It it the same point every time? or a different ("random") point?
I've encountered something similar, it's as if a breakpoint is being saved.
Even when I exit Excel and re-open the file.
When it stops, I was able to select Debug-> Clear_All_Breakpoints
Hi Anil,
see the below link.
www.straxx.com/excel/password.html
Regards,
DILIPandey
On 7 Oct 2011 13:12, "anil kumar" wrote:
> Hello everybody,
>
> I have a excel file in which i use protect op. but I have forgot password.
> becoz i use this file some time not daily.
> If we can unprotect sheet
To unprotect sheet / workbook structure protection, this should help.
however, this will not open the workbook, if you have protected the
file.
http://www.straxx.com/excel/password.xla
Regards,
Sam
On Oct 7, 12:41 pm, anil kumar wrote:
> Hello everybody,
>
> I have a excel file in which i use
Hello everybody,
I have a excel file in which i use protect op. but I have forgot password.
becoz i use this file some time not daily.
If we can unprotect sheet than tell soon.
Anil
--
--
Some important links for e
check the below mentioned linked
regards
sanjib
http://office.microsoft.com/en-us/excel-help/extracting-numbers-from-alphanumeric-strings-HA001154901.aspx
On Fri, Oct 7, 2011 at 11:37 AM, karan 1237 wrote:
> Dear All,
>
> Hope you all are doing well !
>
> I need your assistance to sort out my
30 matches
Mail list logo
