$$Excel-Macros$$ Re: AMC Tracker Sheet

[NKworld]

Hi,

Download it in Excel Format -* 
www.XL.NKworld.in
*

Thanks


On Wednesday, July 3, 2013 6:54:24 PM UTC+5:30, vikas khen wrote:
>
> Dear all, 
>  
> Does anybody have AMC Tracker Template/Sheet ?
>  
>  
> Regards
>  
>

-- 
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/groups/opt_out.

Re: $$Excel-Macros$$ Extract Data on basis of different Criterias

[SG]

hi Ashish,
 
thanks for the help.please help me in result as i want only name & accuracy 
to show.

On Wednesday, July 3, 2013 8:49:33 PM UTC+5:30, ashish wrote:

> try the attachment . if ur data is in lakhs best is u use access 
>
> Regards
> Ashish
>
>
>
>
> On Wed, Jul 3, 2013 at 8:42 PM, SG >wrote:
>
>> hi Ashish,
>>  
>> The data is in lakhs & advance filter would allow me to filter only one 
>> criteria.I have atleast 4 filters in this data.
>> plz experts help me with a macro.
>>  
>> On Wednesday, July 3, 2013 8:29:18 PM UTC+5:30, ashish wrote:
>>
>>>  u can do it using advance filter
>>>  
>>>
>>> On Wed, Jul 3, 2013 at 7:55 PM, SG  wrote:
>>>
 thanx for the response.
  
 PFA example.What i want is to filter the data as oer the "Form" sheet & 
 extract name & it's accuracy & paste in the data section.the data is so 
 huge that's why i want it by macro.
  
 On Wednesday, July 3, 2013 7:41:24 PM UTC+5:30, Vabz wrote:

>  HI 
>
> Pl share sample file.
>
> Thanks
>
>
>  On Wed, Jul 3, 2013 at 7:30 PM, SG  wrote:
>
>>  Hi Experts,
>>  
>> I want to create a report in which data would be extracted on basis 
>> of atleast 4 filters from base data sheet.please help me with a macro 
>> example.
>>  
>> Thanks in advance.
>>
>> -- 
>> 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/**discu**ssexcel
>>  
>> 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...@**googlegroups.**com.
>> To post to this group, send email to excel-...@googlegroups.com. 
>>
>> Visit this group at 
>> http://groups.google.com/**group**/excel-macros
>> .
>> For more options, visit 
>> https://groups.google.com/**grou**ps/opt_out
>> .
>>  
>>  
>>
>
>  -- 
 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...@**googlegroups.com.
 To post to this group, send email to excel-...@googlegroups.com.
 Visit this group at 
 http://groups.google.com/**group/excel-macros
 .
 For more options, visit 
 https://groups.google.com/**groups/opt_out
 .
  
  

>>>
>>>
>>>
>>> -- 
>>>  *Regards*
>>> * *
>>> *Ashish Koul*
>>>
>>>
>>>  *Visit*
>>> *My Excel Blog *
>>> Like Us on 
>>> Facebook
>>> Join Us on Facebook 
>>>
>>>
>>> P Before printing, think about the environment.
>>>  
>>>  
>>>
>> -- 
>>  Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
>> It’s =

Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg.

[Anoop K Sharma]

Ok, you can do one thing.. SaveAs your Excel File. While doing this, you
see a dialog box. Click on "Tool" drop down near "Save" button and select
"General Option". In "General Option" dialog box, check on "Always create
backup"...supply password (if you think it is required). Hide this back up
file by changing its properties. This will keep creating backup file in
same folder where your original one is located but it can't be seen as you
will hide it.


On Thu, Jul 4, 2013 at 10:21 AM, Pravin Gunjal  wrote:

> Hi Anoop
>
> I do not want to restrict my folder from unnecessary access instead I want
> it to be used by others.
>
> Regards
> Pravin Gunjal.
>
> -- Forwarded message --
> From: Anoop K Sharma 
> Date: Thu, Jul 4, 2013 at 5:36 AM
> Subject: Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg.
> To: excel-macros@googlegroups.com
>
>
> If you right click on any folder and check its properties, there you can
> see a security tab.
> If you are an administrator or have administrator's right then you can
> restrict your folder from unnecessary access. This can be done on the
> folder in shared shared drive.
>
>
> On Wed, Jul 3, 2013 at 5:27 PM, Pravin Gunjal  wrote:
>
>> *Point No. 1*
>>
>> Please note, in my office computer I have stored a folder (which contains
>> only “xlsb” files) in my roaming profile id; which need to be shared with
>> some other colleagues in the same office. But there no privilege for
>> sharing from one computer to another computer in our office.  Hence it can
>> not be accessed from my computer to my colleagues computer,  as we are
>> using Roaming Profiles in our office.
>>
>>
>>
>> Moreover, we have been given a common drive, which can be accessed by
>> other users. If I put this folder in a common drive then other users can
>> access it.  But we do not have any backup facility for common drive, and
>> hence it is unsafe for using.
>>
>>
>>
>> OR
>>
>>
>>
>> *Point No. 2*
>>
>> If I put my folder in common drive to use others also, is it possible to
>> make auto backup / auto updation somewhere in my computer’s desktop.
>>
>>
>>
>> Can I have good suggestions, how to share the folders / files, in this
>> situation.  Thanks in advance.
>>
>>
>>
>> *With regards,**
>> **Pravin Gunjal*
>>
>> --
>> 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/groups/opt_out.
>>
>>
>>
>
>
>
> --
> Regards,
> Anoop
> Sr. Developer
> Facebook ID - https://www.facebook.com/anooop.k.sharma
>
> --
> 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/groups/opt_out.
>
>
>
>  --
> Ar

Re: $$Excel-Macros$$ Re: AMC Tracker Sheet

[vikas khen]

Hi,

Thanks for the information but I want Annual Maintainace contract tracker.

Regards



On Thu, Jul 4, 2013 at 12:33 PM, NKworld  wrote:

> Hi,
>
> Download it in Excel Format -* 
> www.XL.NKworld.in
> *
>
> Thanks
>
>
> On Wednesday, July 3, 2013 6:54:24 PM UTC+5:30, vikas khen wrote:
>>
>> Dear all,
>>
>> Does anybody have AMC Tracker Template/Sheet ?
>>
>>
>> Regards
>>
>>
>  --
> 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/groups/opt_out.
>
>
>

-- 
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/groups/opt_out.

Fwd: $$Excel-Macros$$ Files / Folders Sharing Query - reg.

[Pravin Gunjal]

Hi Anoop,

Thank you for valuable information.  Is there any option to create a
back-up / auto up-dation in some other location, and not in the same folder.

Regards
Pravin Gunjal.

-- Forwarded message --
From: Anoop K Sharma 
Date: Thu, Jul 4, 2013 at 1:28 PM
Subject: Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg.
To: excel-macros@googlegroups.com


Ok, you can do one thing.. SaveAs your Excel File. While doing this, you
see a dialog box. Click on "Tool" drop down near "Save" button and select
"General Option". In "General Option" dialog box, check on "Always create
backup"...supply password (if you think it is required). Hide this back up
file by changing its properties. This will keep creating backup file in
same folder where your original one is located but it can't be seen as you
will hide it.


On Thu, Jul 4, 2013 at 10:21 AM, Pravin Gunjal  wrote:

> Hi Anoop
>
> I do not want to restrict my folder from unnecessary access instead I want
> it to be used by others.
>
> Regards
> Pravin Gunjal.
>
> -- Forwarded message --
> From: Anoop K Sharma 
> Date: Thu, Jul 4, 2013 at 5:36 AM
> Subject: Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg.
> To: excel-macros@googlegroups.com
>
>
>  If you right click on any folder and check its properties, there you can
> see a security tab.
> If you are an administrator or have administrator's right then you can
> restrict your folder from unnecessary access. This can be done on the
> folder in shared shared drive.
>
>
> On Wed, Jul 3, 2013 at 5:27 PM, Pravin Gunjal  wrote:
>
>> *Point No. 1*
>>
>> Please note, in my office computer I have stored a folder (which contains
>> only “xlsb” files) in my roaming profile id; which need to be shared with
>> some other colleagues in the same office. But there no privilege for
>> sharing from one computer to another computer in our office.  Hence it can
>> not be accessed from my computer to my colleagues computer,  as we are
>> using Roaming Profiles in our office.
>>
>>
>>
>> Moreover, we have been given a common drive, which can be accessed by
>> other users. If I put this folder in a common drive then other users can
>> access it.  But we do not have any backup facility for common drive, and
>> hence it is unsafe for using.
>>
>>
>>
>> OR
>>
>>
>>
>> *Point No. 2*
>>
>> If I put my folder in common drive to use others also, is it possible to
>> make auto backup / auto updation somewhere in my computer’s desktop.
>>
>>
>>
>> Can I have good suggestions, how to share the folders / files, in this
>> situation.  Thanks in advance.
>>
>>
>>
>> *With regards,**
>> **Pravin Gunjal*
>>
>> --
>> 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/groups/opt_out.
>>
>>
>>
>
>
>
> --
> Regards,
> Anoop
> Sr. Developer
> Facebook ID - https://www.facebook.com/anooop.k.sharma
>
> --
> 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
> "M

Message Recall Failure: Recall: $$Excel-Macros$$ Re: Subtract dates

[Chandra Gupta Maurya]

<>

$$Excel-Macros$$ Re: Introduce Yourself !!

[Prince]

Hi Sandeep welcom on group.

Regards
Prince

On Thursday, 27 June 2013 10:57:28 UTC+5:30, sandeep shivpujan singh wrote:
>
> Hi Everyone,
>
> I am Sandeep S Singh from India > Hyderabad. I am a Software Engineer 
> working with Cognizant. I have just now joined this group & It is my first 
> post.
> I work on QTP and Excel Macros. looking forward to interact with everyone 
> here. have a good day :-)
>
> Thank,
> Sandeep Singh
>
> On Saturday, 9 June 2012 00:51:59 UTC+5:30, Ayush Jain wrote:
>>
>> Hey all new and current posters,
>>  
>> Welcome to excel group,one of the largest online community of excel Fans!
>>  
>> I hope you enjoy your time here & find this forum to be a friendly and 
>> knowledgeable community. Please feel free to post a small introduction, a 
>> friendly hello or tell us a bit about yourself. Why not tell us where are 
>> you from, what you do, what your interests are, how old you are, which is 
>> your favourite excel site or blog is or anything else that comes to mind!
>>
>> Thanks for your time
>> Ayush Jain
>> Group Manager
>> Microsoft MVP
>>
>

-- 
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/groups/opt_out.

$$Excel-Macros$$ Re: Query in For Each Next

[Prince]

No , It Is not refering each cell in the * Range("A1:D5") *.For getting 
each cell you have to change the code like

*Sub Upper_()*

*For Each x In Range("A1:D5").cells*
*x.Value = UCase(x.Value)*
*Next*
*
*
*Regards*
*Prince*



On Wednesday, 3 July 2013 10:41:21 UTC+5:30, Prafull Jadhav wrote:
>
> Dear All,
>
> Good Morning..
>
>
> I got below macro from net ..Can you explain me what "x" stand here...
>
>
>
> *Sub Upper_()*
>
> *For Each x In Range("A1:D5")*
> *'For Each x In Range("A1:D5")*
> *
> *
> *x.Value = UCase(x.Value)*
> *'x.Value = UCase(x.Value)*
> *
> *
> *Next*
> *
> *
> *Thanks in Advance.*
> *Regards,*
> *Prafull Jadhav.*
> *
> *
>

-- 
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/groups/opt_out.

$$Excel-Macros$$ Error in Excel Report

[Manoj Kumar]

Dear Expert,

Please help to sove my Quiry file attached in mail.

i need fill all data with "p" how many count in header.

Regard
Manoj

-- 
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/groups/opt_out.

Re: $$Excel-Macros$$ Error in Excel Report

[Manoj Kumar]

On Thu, Jul 4, 2013 at 4:47 PM, Manoj Kumar  wrote:

>
> Dear Expert,
>
> Please help to sove my Quiry file attached in mail.
>
> i need fill all data with "p" how many count in header.
>
> Regard
> Manoj
>
> --
> 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/groups/opt_out.
>
>
>

-- 
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/groups/opt_out.




Book1.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Error in Excel Report

[xlstime]

Please  elaborate some more

.

Enjoy
Team XLS



On Thu, Jul 4, 2013 at 4:49 PM, Manoj Kumar  wrote:

>
>
>
>
> On Thu, Jul 4, 2013 at 4:47 PM, Manoj Kumar  wrote:
>
>>
>> Dear Expert,
>>
>> Please help to sove my Quiry file attached in mail.
>>
>> i need fill all data with "p" how many count in header.
>>
>> Regard
>> Manoj
>>
>> --
>> 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/groups/opt_out.
>>
>>
>>
>
>  --
> 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/groups/opt_out.
>
>
>

-- 
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/groups/opt_out.

Re: $$Excel-Macros$$ Error in Excel Report

[De Premor]

On cell C5, paste this =IF($B5=C$3,REPT("p",C$3),0)

Rgds,
[dp]
Pada 04/07/2013 18:19, Manoj Kumar menulis:





On Thu, Jul 4, 2013 at 4:47 PM, Manoj Kumar > wrote:



Dear Expert,

Please help to sove my Quiry file attached in mail.

i need fill all data with "p" how many count in header.

Regard
Manoj
-- 
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/groups/opt_out.



--
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/groups/opt_out.




--
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/groups/opt_out.

Re: Message Recall Failure: Recall: $$Excel-Macros$$ Re: Subtract dates

[Anil Kumar]

file is not open





 From: Chandra Gupta Maurya 
To: excel-macros@googlegroups.com 
Sent: Thursday, 4 July 2013 2:33 PM
Subject: Message Recall Failure: Recall: $$Excel-Macros$$ Re: Subtract dates

-- 
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/groups/opt_out.

Re: $$Excel-Macros$$ Error in Excel Report

[Anil Kumar]

 From: Manoj Kumar 
To: excel-macros@googlegroups.com 
Sent: Thursday, 4 July 2013 4:49 PM
Subject: Re: $$Excel-Macros$$ Error in Excel Report
 








On Thu, Jul 4, 2013 at 4:47 PM, Manoj Kumar  wrote:


>
>Dear Expert,
>
>
>Please help to sove my Quiry file attached in mail.
>
>
>i need fill all data with "p" how many count in header.
>
>
>Regard
>Manoj
-- 
>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/groups/opt_out.
> 
> 
>

-- 
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/groups/opt_out.

-- 
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/groups/opt_out.




Copy of Book1.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Error in Excel Report

[Manoj Kumar]

please see the example what i need


On Thu, Jul 4, 2013 at 5:02 PM, De Premor  wrote:

>  On cell C5, paste this =IF($B5=C$3,REPT("p",C$3),0)
>
> Rgds,
> [dp]
>  Pada 04/07/2013 18:19, Manoj Kumar menulis:
>
>
>
>
>
> On Thu, Jul 4, 2013 at 4:47 PM, Manoj Kumar  wrote:
>
>>
>> Dear Expert,
>>
>>  Please help to sove my Quiry file attached in mail.
>>
>>  i need fill all data with "p" how many count in header.
>>
>>  Regard
>> Manoj
>>  --
>> 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/groups/opt_out.
>>
>>
>>
>
>  --
> 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/groups/opt_out.
>
>
>
>
>  --
> 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/groups/opt_out.
>
>
>

-- 
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 thei

Fwd: $$Excel-Macros$$ Files / Folders Sharing Query - reg.

[Pravin Gunjal]

Can I get some more suggestions on this topic..  Thanks.

Regards
Pravin Gunjal.

-- Forwarded message --
From: Pravin Gunjal 
Date: Thu, Jul 4, 2013 at 2:14 PM
Subject: Fwd: $$Excel-Macros$$ Files / Folders Sharing Query - reg.
To: excel-macros@googlegroups.com


Hi Anoop,

Thank you for valuable information.  Is there any option to create a
back-up / auto up-dation in some other location, and not in the same folder.

Regards
Pravin Gunjal.

-- Forwarded message --
From: Anoop K Sharma 
 Date: Thu, Jul 4, 2013 at 1:28 PM
Subject: Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg.
To: excel-macros@googlegroups.com


 Ok, you can do one thing.. SaveAs your Excel File. While doing this, you
see a dialog box. Click on "Tool" drop down near "Save" button and select
"General Option". In "General Option" dialog box, check on "Always create
backup"...supply password (if you think it is required). Hide this back up
file by changing its properties. This will keep creating backup file in
same folder where your original one is located but it can't be seen as you
will hide it.


On Thu, Jul 4, 2013 at 10:21 AM, Pravin Gunjal  wrote:

> Hi Anoop
>
> I do not want to restrict my folder from unnecessary access instead I want
> it to be used by others.
>
> Regards
> Pravin Gunjal.
>
> -- Forwarded message --
> From: Anoop K Sharma 
> Date: Thu, Jul 4, 2013 at 5:36 AM
> Subject: Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg.
> To: excel-macros@googlegroups.com
>
>
>  If you right click on any folder and check its properties, there you can
> see a security tab.
> If you are an administrator or have administrator's right then you can
> restrict your folder from unnecessary access. This can be done on the
> folder in shared shared drive.
>
>
> On Wed, Jul 3, 2013 at 5:27 PM, Pravin Gunjal  wrote:
>
>> *Point No. 1*
>>
>> Please note, in my office computer I have stored a folder (which contains
>> only “xlsb” files) in my roaming profile id; which need to be shared with
>> some other colleagues in the same office. But there no privilege for
>> sharing from one computer to another computer in our office.  Hence it can
>> not be accessed from my computer to my colleagues computer,  as we are
>> using Roaming Profiles in our office.
>>
>>
>>
>> Moreover, we have been given a common drive, which can be accessed by
>> other users. If I put this folder in a common drive then other users can
>> access it.  But we do not have any backup facility for common drive, and
>> hence it is unsafe for using.
>>
>>
>>
>> OR
>>
>>
>>
>> *Point No. 2*
>>
>> If I put my folder in common drive to use others also, is it possible to
>> make auto backup / auto updation somewhere in my computer’s desktop.
>>
>>
>>
>> Can I have good suggestions, how to share the folders / files, in this
>> situation.  Thanks in advance.
>>
>>
>>
>> *With regards,**
>> **Pravin Gunjal*
>>
>> --
>> 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/groups/opt_out.
>>
>>
>>
>
>
>
> --
> Regards,
> Anoop
> Sr. Developer
> Facebook ID - https://www.facebook.com/anooop.k.sharma
>
> --
> 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

Re: $$Excel-Macros$$ Extract Data on basis of different Criterias

[ashish koul]

delete the columns u don't want using vba


On Thu, Jul 4, 2013 at 1:19 PM, SG  wrote:

> hi Ashish,
>
> thanks for the help.please help me in result as i want only name &
> accuracy to show.
>
> On Wednesday, July 3, 2013 8:49:33 PM UTC+5:30, ashish wrote:
>
>> try the attachment . if ur data is in lakhs best is u use access
>>
>> Regards
>> Ashish
>>
>>
>>
>>
>> On Wed, Jul 3, 2013 at 8:42 PM, SG  wrote:
>>
>>> hi Ashish,
>>>
>>> The data is in lakhs & advance filter would allow me to filter only one
>>> criteria.I have atleast 4 filters in this data.
>>> plz experts help me with a macro.
>>>
>>> On Wednesday, July 3, 2013 8:29:18 PM UTC+5:30, ashish wrote:
>>>
  u can do it using advance filter


 On Wed, Jul 3, 2013 at 7:55 PM, SG  wrote:

> thanx for the response.
>
> PFA example.What i want is to filter the data as oer the "Form" sheet
> & extract name & it's accuracy & paste in the data section.the data is so
> huge that's why i want it by macro.
>
> On Wednesday, July 3, 2013 7:41:24 PM UTC+5:30, Vabz wrote:
>
>>  HI
>>
>> Pl share sample file.
>>
>> Thanks
>>
>>
>>  On Wed, Jul 3, 2013 at 7:30 PM, SG  wrote:
>>
>>>  Hi Experts,
>>>
>>> I want to create a report in which data would be extracted on basis
>>> of atleast 4 filters from base data sheet.please help me with a macro
>>> example.
>>>
>>> Thanks in advance.
>>>
>>> --
>>> 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...@**googlegroups.**c**om.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>>
>>> Visit this group at http://groups.google.com/**group
>>> /excel-macros .
>>> For more options, visit https://groups.google.com/**grou
>>> ps/opt_out .
>>>
>>>
>>>
>>
>>  --
> 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/**discu**ssexcel
>
> 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...@**googlegroups.**com.
> To post to this group, send email to excel-...@googlegroups.com.
> Visit this group at 
> http://groups.google.com/**group**/excel-macros
> .
> For more options, visit 
> https://groups.google.com/**grou**ps/opt_out
> .
>
>
>



 --
  *Regards*
 * *
 *Ashish Koul*


  *Visit*
 *My Excel Blog *
 Like Us on 
 Facebook
 Join Us on Facebook 

Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg.

[vba]

hey

PFA attach file with macro to backup folder.

Thanks!!


On Thu, Jul 4, 2013 at 6:09 PM, Pravin Gunjal  wrote:

> Can I get some more suggestions on this topic..  Thanks.
>
> Regards
> Pravin Gunjal.
>
> -- Forwarded message --
> From: Pravin Gunjal 
> Date: Thu, Jul 4, 2013 at 2:14 PM
> Subject: Fwd: $$Excel-Macros$$ Files / Folders Sharing Query - reg.
> To: excel-macros@googlegroups.com
>
>
> Hi Anoop,
>
> Thank you for valuable information.  Is there any option to create a
> back-up / auto up-dation in some other location, and not in the same folder.
>
> Regards
> Pravin Gunjal.
>
> -- Forwarded message --
> From: Anoop K Sharma 
>  Date: Thu, Jul 4, 2013 at 1:28 PM
> Subject: Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg.
> To: excel-macros@googlegroups.com
>
>
>  Ok, you can do one thing.. SaveAs your Excel File. While doing this, you
> see a dialog box. Click on "Tool" drop down near "Save" button and select
> "General Option". In "General Option" dialog box, check on "Always create
> backup"...supply password (if you think it is required). Hide this back up
> file by changing its properties. This will keep creating backup file in
> same folder where your original one is located but it can't be seen as you
> will hide it.
>
>
> On Thu, Jul 4, 2013 at 10:21 AM, Pravin Gunjal  wrote:
>
>> Hi Anoop
>>
>> I do not want to restrict my folder from unnecessary access instead I
>> want it to be used by others.
>>
>> Regards
>> Pravin Gunjal.
>>
>> -- Forwarded message --
>> From: Anoop K Sharma 
>> Date: Thu, Jul 4, 2013 at 5:36 AM
>> Subject: Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg.
>> To: excel-macros@googlegroups.com
>>
>>
>>  If you right click on any folder and check its properties, there you can
>> see a security tab.
>> If you are an administrator or have administrator's right then you can
>> restrict your folder from unnecessary access. This can be done on the
>> folder in shared shared drive.
>>
>>
>> On Wed, Jul 3, 2013 at 5:27 PM, Pravin Gunjal  wrote:
>>
>>> *Point No. 1*
>>>
>>> Please note, in my office computer I have stored a folder (which
>>> contains only “xlsb” files) in my roaming profile id; which need to be
>>> shared with some other colleagues in the same office. But there no
>>> privilege for sharing from one computer to another computer in our office.
>>> Hence it can not be accessed from my computer to my colleagues computer,
>>>  as we are using Roaming Profiles in our office.
>>>
>>>
>>>
>>> Moreover, we have been given a common drive, which can be accessed by
>>> other users. If I put this folder in a common drive then other users can
>>> access it.  But we do not have any backup facility for common drive, and
>>> hence it is unsafe for using.
>>>
>>>
>>>
>>> OR
>>>
>>>
>>>
>>> *Point No. 2*
>>>
>>> If I put my folder in common drive to use others also, is it possible to
>>> make auto backup / auto updation somewhere in my computer’s desktop.
>>>
>>>
>>>
>>> Can I have good suggestions, how to share the folders / files, in this
>>> situation.  Thanks in advance.
>>>
>>>
>>>
>>> *With regards,**
>>> **Pravin Gunjal*
>>>
>>> --
>>> 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/groups/opt_out.
>>>
>>>
>>>
>>
>>
>>
>> --
>> Regards,
>> Anoop
>> Sr. Developer
>> Facebook ID - https://www.facebook.com/anooop.k.sharma
>>
>> --
>> 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 N

Re: $$Excel-Macros$$ Functions name in Calculated field of Pivot

[Vijay Kr. Aggarwal]

Thanks Vijay :)


On Wed, Jul 3, 2013 at 10:23 PM, P.VIJAYKUMAR  wrote:

> Respected Vijay,
>
> Please find the attached file.You can also search the following links
>
> http://office.microsoft.com/en-in/excel-help/summary-functions-available-in-pivottable-and-pivotchart-reports-HP005203116.aspx
>
> http://office.microsoft.com/en-in/excel-help/calculate-values-in-a-pivottable-report-HP010096323.aspx
>
>
>
> Regards,
> Vijaykumar
>
>
> On Wed, Jul 3, 2013 at 6:55 PM, Ahmed Honest wrote:
>
>> Dear...
>>
>> Search the youtube or just google it with the keywords that you have
>> posted here in the group you shall get plenty of examples and videos to
>> understand you will find helping yourself...​
>>
>>
>> On Wed, Jul 3, 2013 at 4:20 PM, Vijay Kr. Aggarwal <
>> vjaggarwal2...@gmail.com> wrote:
>>
>>> I want to know that can we use function like Sum, Count Max and Min in
>>> Calculated field? If yes please provide me examples.
>>>
>>> thanks in advance.
>>>
>>>
>>> On Tue, Jul 2, 2013 at 7:43 PM, Vijay Kr. Aggarwal <
>>> vjaggarwal2...@gmail.com> wrote:
>>>
 Hi Experts,

 I want to know the Functions name, which we can use in Calculated field
 of Pivot table. If possible, please provide me some example as well.

 I searched a lot through google, but could not find out anything useful.

 --
 Regards,
 Vijay

 --
 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/groups/opt_out.



>>>
>>>
>>>
>>> --
>>> Regards,
>>> Vijay Kumar Aggarwal
>>>
>>> --
>>> 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/groups/opt_out.
>>>
>>>
>>>
>>
>>
>>
>> --
>> *Ahmed Bawazir*
>> *احمد باوزير*
>>
>> --
>> 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 workb

Re: $$Excel-Macros$$ Problem with searching through rows and their associated columns

[ashish koul]

can u share the sample file with us

Regards
Ashish


On Thu, Jul 4, 2013 at 7:07 AM, Brian Yam  wrote:

> Dear All,
>
> I am new to VBA programming
> I happen to need great and urgent help on a project that I am currently
> working on
> I would like to search through the worksheet, and find "N" or "TR" on row 6
> Then, For every cell in the column of "N" or "TR"
> if all the cells are blank, then delete/ hide the column
> if the cells are not blank, highlight the cells that are in blank
> This sounds easy but I think it requires two for loops.
> I appreciate any contributions!
>
>
>  Sub checkandhide()
> Set r = Range("6:6")
> Rows("7:7").Select
> For Each Cell In r
>  Selection.Find(What:="N", After:=ActiveCell, LookIn:=xlFormulas,
> LookAt _
> :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
> MatchCase:= _
> False, MatchByte:=False, SearchFormat:=False).Activate
> 'search for N
> Application.Run "deletecolumn"
> Next
> End Sub
> *Sub deletecolumn()
> ActiveCell.Offset(6, 0).Select
> Range(Selection, Selection.End(xlDown)).Select
> For Each Cell.Value In Selection
> If Cell.Value = "" Then
> 'some code that let the loop goes on
> Else
> ActiveCell.Columns.Delete
> End If
> Next
> End Sub*
>
> 
>
> --
> 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/groups/opt_out.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*My Excel Blog *
Like Us on 
Facebook
Join Us on Facebook 


P Before printing, think about the environment.

-- 
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/groups/opt_out.

Re: $$Excel-Macros$$ required Result on Conditions

[Anil Kumar]

 From: Rakesh Kumar Sharma 
To: MS EXCEL AND VBA MACROS  
Sent: Thursday, 4 July 2013 11:42 AM
Subject: $$Excel-Macros$$ required Result on Conditions
 


Dear Experts,
I want Result on  conditions. 
Pls find the attachment. 

-- 

Regards,

Rakesh Kumar Sharma
Contact: +91-9971024741

 
-- 
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/groups/opt_out.

-- 
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/groups/opt_out.




Book1.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ required Result on Conditions

[ashish koul]

try this code -
Sub test()
Dim i As Long
For i = 3 To Range("AG4").Column
Range(Cells(5, i), Cells(5 + Cells(4, i) - 1, i)).Value = "p"
Next
End Sub

see if it helps





On Thu, Jul 4, 2013 at 10:18 PM, Anil Kumar  wrote:

>
>   --
>  *From:* Rakesh Kumar Sharma 
> *To:* MS EXCEL AND VBA MACROS 
> *Sent:* Thursday, 4 July 2013 11:42 AM
> *Subject:* $$Excel-Macros$$ required Result on Conditions
>
> Dear Experts,
> I want Result on  conditions.
> Pls find the attachment.
>
> --
> Regards,
>
> Rakesh Kumar Sharma
> Contact: +91-9971024741
>
>  --
> 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/groups/opt_out.
>
>
>
>
>   --
> 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/groups/opt_out.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*My Excel Blog *
Like Us on 
Facebook
Join Us on Facebook 


P Before printing, think about the environment.

-- 
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/groups/opt_out.

Re: $$Excel-Macros$$ Error in Excel Report

[Anil Kumar]

 From: Manoj Kumar 
To: excel-macros@googlegroups.com 
Sent: Thursday, 4 July 2013 4:47 PM
Subject: $$Excel-Macros$$ Error in Excel Report
 




Dear Expert,

Please help to sove my Quiry file attached in mail.

i need fill all data with "p" how many count in header.

Regard
Manoj
-- 
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/groups/opt_out.

-- 
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/groups/opt_out.




Book1.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg.

[Anoop K Sharma]

VBA...given good idea..I havn't tried it. Yet, you can write below code. It
will SaveAs your backup file automatically every time you close your main
workbook to the destination of your choice by overwriting previous one.
Just copy and paste below in "ThisWorkbook" module. Change the path
highlighted below.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
'Saves the current file to a backup folder and the default folder
'Note that any backup is overwritten
Application.DisplayAlerts = False
ActiveWorkbook.SaveCopyAs FileName:="C:\Anoop\" &
ActiveWorkbook.Name  'You Can Change path here to the backup file
ActiveWorkbook.Save
Application.DisplayAlerts = True
End Sub

Anoop
Sr. Developer


On Thu, Jul 4, 2013 at 8:04 PM, vba  wrote:

> hey
>
> PFA attach file with macro to backup folder.
>
> Thanks!!
>
>
> On Thu, Jul 4, 2013 at 6:09 PM, Pravin Gunjal  wrote:
>
>> Can I get some more suggestions on this topic..  Thanks.
>>
>> Regards
>> Pravin Gunjal.
>>
>> -- Forwarded message --
>> From: Pravin Gunjal 
>> Date: Thu, Jul 4, 2013 at 2:14 PM
>> Subject: Fwd: $$Excel-Macros$$ Files / Folders Sharing Query - reg.
>> To: excel-macros@googlegroups.com
>>
>>
>> Hi Anoop,
>>
>> Thank you for valuable information.  Is there any option to create a
>> back-up / auto up-dation in some other location, and not in the same folder.
>>
>> Regards
>> Pravin Gunjal.
>>
>> -- Forwarded message --
>> From: Anoop K Sharma 
>>  Date: Thu, Jul 4, 2013 at 1:28 PM
>> Subject: Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg.
>> To: excel-macros@googlegroups.com
>>
>>
>>  Ok, you can do one thing.. SaveAs your Excel File. While doing this, you
>> see a dialog box. Click on "Tool" drop down near "Save" button and select
>> "General Option". In "General Option" dialog box, check on "Always create
>> backup"...supply password (if you think it is required). Hide this back up
>> file by changing its properties. This will keep creating backup file in
>> same folder where your original one is located but it can't be seen as you
>> will hide it.
>>
>>
>> On Thu, Jul 4, 2013 at 10:21 AM, Pravin Gunjal  wrote:
>>
>>> Hi Anoop
>>>
>>> I do not want to restrict my folder from unnecessary access instead I
>>> want it to be used by others.
>>>
>>> Regards
>>> Pravin Gunjal.
>>>
>>> -- Forwarded message --
>>> From: Anoop K Sharma 
>>> Date: Thu, Jul 4, 2013 at 5:36 AM
>>> Subject: Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg.
>>> To: excel-macros@googlegroups.com
>>>
>>>
>>>  If you right click on any folder and check its properties, there you
>>> can see a security tab.
>>> If you are an administrator or have administrator's right then you can
>>> restrict your folder from unnecessary access. This can be done on the
>>> folder in shared shared drive.
>>>
>>>
>>> On Wed, Jul 3, 2013 at 5:27 PM, Pravin Gunjal  wrote:
>>>
 *Point No. 1*

 Please note, in my office computer I have stored a folder (which
 contains only “xlsb” files) in my roaming profile id; which need to be
 shared with some other colleagues in the same office. But there no
 privilege for sharing from one computer to another computer in our office.
 Hence it can not be accessed from my computer to my colleagues computer,
  as we are using Roaming Profiles in our office.



 Moreover, we have been given a common drive, which can be accessed by
 other users. If I put this folder in a common drive then other users can
 access it.  But we do not have any backup facility for common drive, and
 hence it is unsafe for using.



 OR



 *Point No. 2*

 If I put my folder in common drive to use others also, is it possible
 to make auto backup / auto updation somewhere in my computer’s desktop.



 Can I have good suggestions, how to share the folders / files, in this
 situation.  Thanks in advance.



 *With regards,**
 **Pravin Gunjal*

 --
 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

Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg.

[De Premor]

To keep in Track, we can add some user environment in filename

'=
Dim fName As String, fPath as string, fTag as String

fPath = "\\your-computer-name\my-shared-folder\"   '<--  Set This 
to Your Full Path Of Your Shared Folder to Create Backup
fName = Environ("computername") & "(" & Environ("username") & ") " 
& Format(Now(), "yymmddhhmm") & " "

fTag = "BeforeEdit"
ThisWorkbook.SaveCopyAs fPath & fNameStr & fTag & " - " & 
ThisWorkbook.Name

ThisWorkbook.Save
'=

That code will save backup file named 
"EDITORCOMPUTERNAME(EDITORUSERNAME) YYMMDDHHMM BeforeEdit - 
SomeWorkbook.xlsm"

Ex: *MCMRWKS-ICT(Premor)**1307050837**BeforeEdit - Someworkbook.xlsm*
1307050837 => Year Month Date Hour Minutes (In Two Digit each)

If We want to create backup before user make some change in workbook, 
put that on Workbook_Open event
If we want to create backup while saving workbook, then put that code to 
Workbook_BeforeSave, and change fTag to "AfterEdit"


That tag will make us more clearly to identify the file, from where that 
file edited, by who, and when the do that


Thanks,
[dp]

On 05/07/2013 7:56, Anoop K Sharma wrote:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As 
Boolean)

'Saves the current file to a backup folder and the default folder
'Note that any backup is overwritten
Application.DisplayAlerts = False
ActiveWorkbook.SaveCopyAs FileName:="C:\Anoop\" & 
ActiveWorkbook.Name  'You Can Change path here to the backup file

ActiveWorkbook.Save
Application.DisplayAlerts = True
End Sub


--
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/groups/opt_out.

$$Excel-Macros$$ Re: SAVE As file name

[Vabz]

Hi

You can try this code:

Sub SaveFileAs()
 
Dim FName   As String
Dim FPath   As String
 
FPath = ThisWorkbook.Path '"C:"
FName = ABC(Range("A2").Value, Range("B2").Value, Range("C2").Value)
'FName = Sheets("Sheet1").Range("A1").Text
ThisWorkbook.SaveAs Filename:=FPath & "\" & FName
 
End Sub

Function ABC(strText1 As String, strText2 As String, strText3 As String)

ABC = strText1 & "-" & strText2 & "-" & strText3
End Function


HTH//Thanks

On Friday, July 5, 2013 9:41:01 AM UTC+5:30, Pankaj wrote:
>
> Dear All,
>
> Please help to SAVE As file name as per record entered.
>
>
> [image: Inline image 1]
>
> -- 
>  
> Thanks
> Pankaj Kumar
> 9910075248
>

-- 
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/groups/opt_out.

$$Excel-Macros$$ Re: SAVE As file name

[sandeep shivpujan singh]

Hi,

You can use below code also. I think you want to save a blank sheet with 
the  required name.

1. Code to save one sheet with the data given in cells 2.

Dim strPath As String
strPath = ActiveWorkbook.Path & "\"
ActiveSheet.Copy
ActiveWorkbook.SaveAs Filename:=strPath & Cells(2, 1) & "-" & Cells(2, 2) & 
"-" & Cells(2, 4) & ".xls"
ActiveWorkbook.Close
MsgBox "done"


2. based on number of rows you have.. each row data can be used and saved 
as a new sheet.

'for saving each row value as new xls you can try this.

Dim i, j As Integer
i = 4 ' i can be any number of row you want.

For j = 2 To i 'two is for starting from 2nd row as 1st row is heading.
ActiveSheet.Copy
ActiveWorkbook.SaveAs Filename:=strPath & Cells(j, 1) & "-" & Cells(j, 2) & 
"-" & Cells(j, 4) & ".xls"
ActiveWorkbook.Close
Next j


Thanks,
Sandeep

On Friday, 5 July 2013 09:41:01 UTC+5:30, Pankaj wrote:
>
> Dear All,
>
> Please help to SAVE As file name as per record entered.
>
>
> [image: Inline image 1]
>
> -- 
>  
> Thanks
> Pankaj Kumar
> 9910075248
>

-- 
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/groups/opt_out.

Re: $$Excel-Macros$$ Re: SAVE As file name

[R Swarup]

pl tell how to exit out of this group?


On Fri, Jul 5, 2013 at 10:28 AM, sandeep shivpujan singh <
mandy07s...@gmail.com> wrote:

> Hi,
>
> You can use below code also. I think you want to save a blank sheet with
> the  required name.
>
> 1. Code to save one sheet with the data given in cells 2.
>
> Dim strPath As String
> strPath = ActiveWorkbook.Path & "\"
> ActiveSheet.Copy
> ActiveWorkbook.SaveAs Filename:=strPath & Cells(2, 1) & "-" & Cells(2, 2)
> & "-" & Cells(2, 4) & ".xls"
> ActiveWorkbook.Close
> MsgBox "done"
>
>
> 2. based on number of rows you have.. each row data can be used and saved
> as a new sheet.
>
> 'for saving each row value as new xls you can try this.
>
> Dim i, j As Integer
> i = 4 ' i can be any number of row you want.
>
> For j = 2 To i 'two is for starting from 2nd row as 1st row is heading.
> ActiveSheet.Copy
> ActiveWorkbook.SaveAs Filename:=strPath & Cells(j, 1) & "-" & Cells(j, 2)
> & "-" & Cells(j, 4) & ".xls"
> ActiveWorkbook.Close
> Next j
>
>
> Thanks,
> Sandeep
>
>
> On Friday, 5 July 2013 09:41:01 UTC+5:30, Pankaj wrote:
>>
>> Dear All,
>>
>> Please help to SAVE As file name as per record entered.
>>
>>
>> [image: Inline image 1]
>>
>> --
>>
>> Thanks
>> Pankaj Kumar
>> 9910075248
>>
>  --
> 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/groups/opt_out.
>
>
>



-- 
Regards
Ram
Chartered Accountant
9990484446

-- 
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/groups/opt_out.

Re: $$Excel-Macros$$ Re: SAVE As file name

[vba]

You may click..

https://groups.google.com/groups/opt_out

Thanks
On 5 Jul 2013 10:51, "R Swarup"  wrote:

> pl tell how to exit out of this group?
>
>
> On Fri, Jul 5, 2013 at 10:28 AM, sandeep shivpujan singh <
> mandy07s...@gmail.com> wrote:
>
>> Hi,
>>
>> You can use below code also. I think you want to save a blank sheet with
>> the  required name.
>>
>> 1. Code to save one sheet with the data given in cells 2.
>>
>> Dim strPath As String
>> strPath = ActiveWorkbook.Path & "\"
>> ActiveSheet.Copy
>> ActiveWorkbook.SaveAs Filename:=strPath & Cells(2, 1) & "-" & Cells(2, 2)
>> & "-" & Cells(2, 4) & ".xls"
>> ActiveWorkbook.Close
>> MsgBox "done"
>>
>>
>> 2. based on number of rows you have.. each row data can be used and saved
>> as a new sheet.
>>
>> 'for saving each row value as new xls you can try this.
>>
>> Dim i, j As Integer
>> i = 4 ' i can be any number of row you want.
>>
>> For j = 2 To i 'two is for starting from 2nd row as 1st row is heading.
>> ActiveSheet.Copy
>> ActiveWorkbook.SaveAs Filename:=strPath & Cells(j, 1) & "-" & Cells(j, 2)
>> & "-" & Cells(j, 4) & ".xls"
>> ActiveWorkbook.Close
>> Next j
>>
>>
>> Thanks,
>> Sandeep
>>
>>
>> On Friday, 5 July 2013 09:41:01 UTC+5:30, Pankaj wrote:
>>>
>>> Dear All,
>>>
>>> Please help to SAVE As file name as per record entered.
>>>
>>>
>>> [image: Inline image 1]
>>>
>>> --
>>>
>>> Thanks
>>> Pankaj Kumar
>>> 9910075248
>>>
>>  --
>> 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/groups/opt_out.
>>
>>
>>
>
>
>
> --
> Regards
> Ram
> Chartered Accountant
> 9990484446
>
>
>  --
> 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/groups/opt_out.
>
>
>

-- 
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.

$$Excel-Macros$$ Need Formula

[Prabhakar S H]

Hi Team,
 
I need your help to get details with formula in attached file.
 
Rgds,
Prabhakar

-- 
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/groups/opt_out.




Testing.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Need Access help

[Rakesh Sharma]

Dear Experts


i have two queries in acess 2010 screen shot attached which have data
mention below

i just want to sum both of two queries. pl help

query 1   query 2


name   count  name count


rakesh  1 rakesh9

mukesh 3 Mohit  2

pooja9 raman6

mohit   10

raman  3


requirement

sum of both queries.

Name count
rakesh 10
Mukesh 3
Pooja9
Mohit12
Raman  9

Thanks in advance...!!!

**
RAKESH SHARMA
NPI –Team
Ericsson India Pvt. Ltd.
4th Floor, Gupta Towers, Commercial Block, Rail Head
Jammu & Kashmir, INDIA
Phone 01912477440/ 01912477473/441
Fax 01912477442
Mobile +91 9906115140
rakesh.kumar.d.sha...@ericsson.com
www.ericsson.com

“If You fall, fall like a seed to germinate, not like a leaf to die.”

-- 
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/groups/opt_out.


<>

Re: $$Excel-Macros$$ Need Access help

[अनिल नारायण गवली]

Dear Rakesh,

Pl find attached herewith.

Warm Regards,
Gawli Anil.


On Fri, Jul 5, 2013 at 12:02 PM, Rakesh Sharma wrote:

> Dear Experts
>
>
> i have two queries in acess 2010 screen shot attached which have data
> mention below
>
> i just want to sum both of two queries. pl help
>
> query 1   query 2
>
>
> name   count  name count
>
>
> rakesh  1 rakesh9
>
> mukesh 3 Mohit  2
>
> pooja9 raman6
>
> mohit   10
>
> raman  3
>
>
> requirement
>
> sum of both queries.
>
> Name count
> rakesh 10
> Mukesh 3
> Pooja9
> Mohit12
> Raman  9
>
> Thanks in advance...!!!
>
> **
> RAKESH SHARMA
> NPI –Team
> Ericsson India Pvt. Ltd.
> 4th Floor, Gupta Towers, Commercial Block, Rail Head
> Jammu & Kashmir, INDIA
> Phone 01912477440/ 01912477473/441
> Fax 01912477442
> Mobile +91 9906115140
> rakesh.kumar.d.sha...@ericsson.com
> www.ericsson.com
>
> “If You fall, fall like a seed to germinate, not like a leaf to die.”
>
>  --
> 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/groups/opt_out.
>
>
>



-- 
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd

-- 
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/groups/opt_out.




Book1.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Re: Need Access help

[Prince]

Just do this


select t.name sum(t.count)

From
(

Select * from qry1

union

select * from qry2
) as t


Regards
Prince

On Friday, July 5, 2013 12:02:00 PM UTC+5:30, rk sharma wrote:
>
> Dear Experts 
>
>
> i have two queries in acess 2010 screen shot attached which have data 
> mention below 
>
> i just want to sum both of two queries. pl help
>
> query 1   query 2 
> 
>
> name   count  name count   
>
>
> rakesh  1 rakesh9 
>
> mukesh 3 Mohit  2 
>
> pooja9 raman6 
> 
> mohit   10 
>
> raman  3  
>
>
> requirement 
>
> sum of both queries.
>
> Name count
> rakesh 10
> Mukesh 3
> Pooja9
> Mohit12
> Raman  9
>
> Thanks in advance...!!!
>
> **
> RAKESH SHARMA
> NPI –Team
> Ericsson India Pvt. Ltd.
> 4th Floor, Gupta Towers, Commercial Block, Rail Head
> Jammu & Kashmir, INDIA
> Phone 01912477440/ 01912477473/441
> Fax 01912477442 
> Mobile +91 9906115140
> rakesh.kum...@ericsson.com 
> www.ericsson.com  
>
> “If You fall, fall like a seed to germinate, not like a leaf to die.”
>
> 

-- 
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/groups/opt_out.

$$Excel-Macros$$ Re: Need Access help

[Prince]

select t.name sum(t.count)

From
(

Select * from qry1

union

select * from qry2
) as t

*Group By t.name*




Regards
Prince

On Friday, July 5, 2013 12:25:30 PM UTC+5:30, Prince wrote:
>
> Just do this
>
>
> select t.name sum(t.count)
>
> From
> (
>
> Select * from qry1
>
> union
>
> select * from qry2
> ) as t
>
>
> Regards
> Prince
>
> On Friday, July 5, 2013 12:02:00 PM UTC+5:30, rk sharma wrote:
>>
>> Dear Experts 
>>
>>
>> i have two queries in acess 2010 screen shot attached which have data 
>> mention below 
>>
>> i just want to sum both of two queries. pl help
>>
>> query 1   query 2 
>> 
>>
>> name   count  name count 
>>  
>>
>> rakesh  1 rakesh9 
>>
>> mukesh 3 Mohit  2 
>>
>> pooja9 raman6 
>> 
>> mohit   10   
>>  
>> raman  3  
>>
>>
>> requirement 
>>
>> sum of both queries.
>>
>> Name count
>> rakesh 10
>> Mukesh 3
>> Pooja9
>> Mohit12
>> Raman  9
>>
>> Thanks in advance...!!!
>>
>> **
>> RAKESH SHARMA
>> NPI –Team
>> Ericsson India Pvt. Ltd.
>> 4th Floor, Gupta Towers, Commercial Block, Rail Head
>> Jammu & Kashmir, INDIA
>> Phone 01912477440/ 01912477473/441
>> Fax 01912477442 
>> Mobile +91 9906115140
>> rakesh.kum...@ericsson.com
>> www.ericsson.com  
>>
>> “If You fall, fall like a seed to germinate, not like a leaf to die.”
>>
>> 

-- 
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/groups/opt_out.

$$Excel-Macros$$ Re: Need Access help

[Prince]

another way


select t.name sum(t.count)
From
(
Write your first qry1
union
Write your second qry2
) as t
*Group By t.name*

Regards
Prince



On Friday, July 5, 2013 12:26:48 PM UTC+5:30, Prince wrote:
>
>
> select t.name sum(t.count)
>
> From
> (
>
> Select * from qry1
>
> union
>
> select * from qry2
> ) as t
>
> *Group By t.name*
>
>
>
>
> Regards
> Prince
>
> On Friday, July 5, 2013 12:25:30 PM UTC+5:30, Prince wrote:
>>
>> Just do this
>>
>>
>> select t.name sum(t.count)
>>
>> From
>> (
>>
>> Select * from qry1
>>
>> union
>>
>> select * from qry2
>> ) as t
>>
>>
>> Regards
>> Prince
>>
>> On Friday, July 5, 2013 12:02:00 PM UTC+5:30, rk sharma wrote:
>>>
>>> Dear Experts 
>>>
>>>
>>> i have two queries in acess 2010 screen shot attached which have data 
>>> mention below 
>>>
>>> i just want to sum both of two queries. pl help
>>>
>>> query 1   query 2   
>>>   
>>>
>>> name   count  name count 
>>>  
>>>
>>> rakesh  1 rakesh9   
>>>  
>>> mukesh 3 Mohit  2   
>>>  
>>> pooja9 raman6   
>>>   
>>> mohit   10   
>>>  
>>> raman  3  
>>>
>>>
>>> requirement 
>>>
>>> sum of both queries.
>>>
>>> Name count
>>> rakesh 10
>>> Mukesh 3
>>> Pooja9
>>> Mohit12
>>> Raman  9
>>>
>>> Thanks in advance...!!!
>>>
>>> **
>>> RAKESH SHARMA
>>> NPI –Team
>>> Ericsson India Pvt. Ltd.
>>> 4th Floor, Gupta Towers, Commercial Block, Rail Head
>>> Jammu & Kashmir, INDIA
>>> Phone 01912477440/ 01912477473/441
>>> Fax 01912477442 
>>> Mobile +91 9906115140
>>> rakesh.kum...@ericsson.com
>>> www.ericsson.com  
>>>
>>> “If You fall, fall like a seed to germinate, not like a leaf to die.”
>>>
>>> 

-- 
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/groups/opt_out.