Re: $$Excel-Macros$$ Subtotal function

[Abdelrahman Noaman]

On 12 May 2017 at 06:58, Izhar  wrote:

> rking in s


hi
Change it from =SUBTOTAL(9,J2:J1399*1*)  to =SUBTOTAL(9,J2:J1399*0*)


Thanks & Best Regards

 *Abdelrahman Gomaa | *Supervisor Receivable Accountant* | *Cancun Beach
Resort & Spa

Address: 102 KM Suez - Zafarana Road, Ain Sokhna, Egypt

Tel: +20 (14) 445 9611/2/3 *|* Fax: +20 (62) 339 4330 *|* Mobile: +20
(0)1144459596

Reservation Hotline:
*19156 *E-mail: *|* receivablecan...@amer-group.com

 Website: www.amer-group.com , www.portoworldhotels.com

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ repeat values

[Abdelrahman Noaman]

Hi satendra

many thanks for your quick reply

i need the result in column F&G  by using data  in column B&C


*Thanks & Best regards*



*Abdelrahman Gomaa*

Income Audit Supervisor



*Sol Y Mar Naama Bay*

*Jaz Hotels, Resorts & Cruises*

Naama Bay, Sharma El Sheikh, South Sinai, Egypt

Cell phone: +201009799117

Email:   inc...@solymarnaamabay.com

www.jaz.travel



[image: Description: cid:image001.gif@01CF8A56.DD66B4F0]
<https://twitter.com/Jaz_Hotels>[image: Description:
cid:image002.gif@01CF8A56.DD66B4F0]
<http://www.linkedin.com/profile/view?id=107486006&trk=tab_pro> [image:
Description: cid:image003.gif@01CF8A56.DD66B4F0]
<https://www.facebook.com/pages/Jaz-Buzz/155475354509871?ref=hl> [image:
Description: cid:image004.gif@01CF8A56.DD66B4F0]
<http://www.youtube.com/user/JazHotelsandResorts>

[image: cid:image005.jpg@01CFA29E.4CD90FE0]

[image: Generic Footer Jan] <http://jaz.travel/offers.aspx>

   ­­

On 13 July 2015 at 07:29, Satendra kumar  wrote:

> Hi Abdelrahman,
>
> find the attachment with formula for repeated value.
>
>
>
> thanks
> satendra kumar
>
> On Mon, Jul 13, 2015 at 3:09 AM, Abdelrahman Noaman <
> abdelrahman.go...@gmail.com> wrote:
>
>> ​Hello Expert
>>
>> i need formula to repeat values as attached file
>>
>> *Thanks & Best regards*
>>
>>
>>
>> *Abdelrahman Gomaa*
>>
>> Income Audit Supervisor
>>
>>
>>
>> *Sol Y Mar Naama Bay*
>>
>> *Jaz Hotels, Resorts & Cruises*
>>
>> Naama Bay, Sharma El Sheikh, South Sinai, Egypt
>>
>> Cell phone: +201009799117
>>
>> Email:   inc...@solymarnaamabay.com
>>
>> www.jaz.travel
>>
>>­­
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
> Thanks & Regards
> Satendra Kumar
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussex

$$Excel-Macros$$ repeat values

[Abdelrahman Noaman]

​Hello Expert

i need formula to repeat values as attached file

*Thanks & Best regards*



*Abdelrahman Gomaa*

Income Audit Supervisor



*Sol Y Mar Naama Bay*

*Jaz Hotels, Resorts & Cruises*

Naama Bay, Sharma El Sheikh, South Sinai, Egypt

Cell phone: +201009799117

Email:   inc...@solymarnaamabay.com

www.jaz.travel

   ­­

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


repeat values.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Amazing... Excel Menu Bar... Try it... you will like it

[Abdelrahman Noaman]

it is very useful
thank you

Thanks & Best regards
Abdel Rahman Gomaa
Night Auditor
B & G  Hotels And Resorts
Calimera Habiba Beach
Marsa Alam
Email: income.habibama...@balbaagroup.com
Web Site : www.balbaagroup.com
Tel : 010-09799117
Tel : 065-3380105 - 110
Fax : 065-3380124



On 10 February 2012 08:35, Darwin Chan  wrote:

> Dear Noorain,
>
> Thanks for your support!!
>
>
> 2012/2/7 NOORAIN ANSARI 
>
>> Add-In Excel 2003 Version
>>
>>
>> On Thu, Feb 2, 2012 at 5:24 PM, NOORAIN ANSARI 
>> wrote:
>>
>>> Dear Darwin/ Bé Trần Văn,
>>>
>>> Recently it will available in Excel Version 2003.
>>>
>>>
>>>
>>>
>>> On Thu, Feb 2, 2012 at 5:18 PM, Bé Trần Văn 
>>> wrote:
>>>


 2012/2/2 Excel_Lover 

> great, Thanks for sharing..
>
>
> On Wed, Feb 1, 2012 at 12:39 PM, Darwin Chan <
> darwin.chankaw...@gmail.com> wrote:
>
>> Noorain,
>>
>> Is there any version for Excel 97 - 2003?
>>
>> Thanks~
>>
>>
>> 2012/2/1 NOORAIN ANSARI 
>>
>>> In Excel 2007 Version
>>>
>>> On Wed, Feb 1, 2012 at 2:21 PM, Abdulgani Shaikh <
>>> itpabdulg...@gmail.com> wrote:
>>>
 in which Excel version it will work ?


 On Wed, Feb 1, 2012 at 1:55 PM, NOORAIN ANSARI <
 noorain.ans...@gmail.com> wrote:

> Dear Abdul,
>
> PFA
>
>  -- Forwarded message --
> From: ITP Abdulgani Shaikh 
> Date: Wed, Feb 1, 2012 at 11:28 AM
> Subject: Re: $$Excel-Macros$$ Amazing... Excel Menu Bar... Try
> it... you will like it
> To: excel-macros@googlegroups.com
>
>
>  I am unable to download the Add in, can you please email it to
> me.
> Regards
>
>  On Mon, Jan 30, 2012 at 9:09 PM, NOORAIN ANSARI <
> noorain.ans...@gmail.com> wrote:
>
>> Dear Group,
>>
>> Find attached the Excel add-ins, which simply fantastic in our
>> routine work.
>> Just open the attachment in excel file and you can see there is
>> an additional menu appears to your excel tab “My Menu”
>> develop by one of our Group member Mr. Ashish Koul
>>
>> You can see almost all the functions we use are available in the
>> menu
>>
>>
>> http://www.excelvbamacros.com/2012/01/my-menu-functions-and-help.html
>>
>>
>> --
>>
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>>  
>> *http://excelmacroworld.blogspot.com/*
>> *http://noorain-ansari.blogspot.com/*
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like
>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and 
>> Need
>> Advice will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any
>> security measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this
>> forum in signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a
>> workbook. Forum owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to
>> excel-macros@googlegroups.com
>>
>
>
>
> --
> Shaikh AbdulGani A R
> ITP, STP, TRP, STRP
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and 
> Need
> Advice will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any
> security measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this
> forum in signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a
> workbook. Forum owners and members are not responsible for any loss.
>
>
> 

Re: $$Excel-Macros$$ !!!!!HELP : URGENT !!!!!!!

[abdelrahman noaman]

Hi All It is very esey just go to excel option and disabl the macro and
check dont trust all vba cod and passwrod request will not work than sheet
will open and go to refrance pswlist and you will show all pass and than go
to vba auditor and show code and user form
thx and best wishes
gomaa.

On 2 June 2011 14:24, karan 1237  wrote:

> Thnx a lot Rajan. You are most helpful persongreat... :)
>
>
> *---
> кαяαηη*
>
>
>
> On Thu, Jun 2, 2011 at 5:37 PM, Rajan_Verma wrote:
>
>>  Hi Karan,
>>
>> I think it has been Complete Now….
>>
>>
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *karan 1237
>> *Sent:* Thursday, June 02, 2011 4:21 PM
>>
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ !HELP : URGENT !!!
>>
>>
>>
>> Thnx a lot Rajan but I want one more thing that is it possible to make
>> input box character like dis *. If it is possible so please help.
>>
>>
>> Thnx
>>
>> *---
>> кαяαηη*
>>
>>
>>
>>  On Thu, Jun 2, 2011 at 11:59 AM, Rajan_Verma 
>> wrote:
>>
>> HI Karan
>>
>> See it help
>>
>>
>>
>> Rajan
>>
>>
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Vishal Gupta
>> *Sent:* Wednesday, June 01, 2011 8:05 PM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ !HELP : URGENT !!!
>>
>>
>>
>> *Dear кαяαηη,*
>>
>> *Greetings for the day!!!*
>>
>> *to protect your sheet or workbook go to review pane in office 2007, then
>> protect sheet, then limit of protection. by doing this u can protect ur
>> project with a password.*
>>
>>
>>
>> Regards
>>
>> Vishal Gupta
>>
>>
>>
>> On Wed, Jun 1, 2011 at 3:58 PM, karan 1237  wrote:
>>
>>
>>
>> Hello Expert
>>
>>
>> I need your help to to create conditions & password protection in my
>> project. I'v attached the file & my problems in attached file. Pls see &
>> Help.
>>
>>
>> Thnx in advance
>>
>> *
>> кαяαηη*
>>
>>
>>
>>
>>
>> --
>>
>> --
>> 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.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>>
>>
>> --
>>
>> --
>> 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.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>>
>>
>> --
>>
>> --
>> 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.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>> --
>>
>> --
>> 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.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for t