Re: $$Excel-Macros$$ vba code for listing folder name and file name

[Kat]

Hi Mandeep, 

The revision time in my snapshot is the one I use writing. The real code 
isn't showing. It's not showing the folder name and file name as well. In 
terms of revision times,  it's fine if the changes are done in certain 
interval. 



On Monday, 11 January 2016 15:34:15 UTC+8, Mandeep Baluja wrote:
>
> Revision time ?? I have not heard about this while searching it on the 
> internet I found this 
> http://excel.tips.net/T002868_Using_Revision_Tracking.html 
> 
>  
> which track the changes done workbook shared on network. Is revision time 
> being noted anywhere in your workbook your snapshot is not showing what is 
> the revision time you have entered 6,7 etc. 
>
> This is a bit difficult but not impossible,What i assumed is you each 
> sheet in Excel having the History sheet which tracks the changes with the 
> last line "The history ends with the changes saved on 11-01-2016 at 13:01." 
> after certain interval
>  
> Confirm this first !!
>
>
> Regards,
> Mandeep baluja
>
>
>
>
>

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

FORUM RULES

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

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


correct folder name.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ QUESTION FOR DAYS DIFFERENCE

[Abhishek Jain]

When you are subtracting, you are excluding the start date.



On Mon, Jan 11, 2016 at 10:30 AM, Izhar  wrote:

> Please open the attachment see the question.
> 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+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ vba code for listing folder name and file name

[Abhishek Jain]

Please elaborate what do you mean by "revision times". Do you want to show
the time when it was most recently updated or you want to show how many
times has it been updated?



On Mon, Jan 11, 2016 at 9:52 AM, Kat  wrote:

> Hi all,
>
> I want to create a xlsm file which list out the folder name, file name and
> revision times with its corresponding date modified. When there is new file
> updated, i hope it can be updated automatically in the workbook. may I know
> how can I achieve this?
>
> Thanks in advanced.
>
>
> Cheers
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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

$$Excel-Macros$$ vba code for listing folder name and file name

[Kat]

Hi all, 

I want to create a xlsm file which list out the folder name, file name and 
revision times with its corresponding date modified. When there is new file 
updated, i hope it can be updated automatically in the workbook. may I know 
how can I achieve this?

Thanks in advanced.


Cheers

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

FORUM RULES

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

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

$$Excel-Macros$$ QUESTION FOR DAYS DIFFERENCE

[Izhar]

Please open the attachment see the question.
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+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ vba code for listing folder name and file name

[Abhishek Jain]

Please see if this solves your purpose -

http://www.vbaexpress.com/kb/getarticle.php?kb_id=837

On Mon, Jan 11, 2016 at 11:55 AM, Kat  wrote:

> Hi Abhi,
>
> In terms of revision times, I want to show all the current revision times.
> Also, in the future, if there is any revision times being updated in the
> folder, I want it to be automatically being added in the excel sheet as
> well. Please see below the file situation and excel print screen as the
> result I want it to be shown. Let me know if you have any further issue.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> On Monday, January 11, 2016 at 1:26:07 PM UTC+8, Abhi wrote:
>>
>> Please elaborate what do you mean by "revision times". Do you want to
>> show the time when it was most recently updated or you want to show how
>> many times has it been updated?
>>
>>
>> On Mon, Jan 11, 2016 at 9:52 AM, Kat  wrote:
>>
>>> Hi all,
>>>
>>> I want to create a xlsm file which list out the folder name, file name
>>> and revision times with its corresponding date modified. When there is new
>>> file updated, i hope it can be updated automatically in the workbook. may I
>>> know how can I achieve this?
>>>
>>> Thanks in advanced.
>>>
>>>
>>> Cheers
>>>
>>> --
>>> 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 https://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ vba code for listing folder name and file name

[Kat]

Hi Abhi,

Unfortunately, the code doesn't apply for my case.


On Monday, January 11, 2016 at 2:52:34 PM UTC+8, Abhi wrote:
>
> Please see if this solves your purpose -
>
> http://www.vbaexpress.com/kb/getarticle.php?kb_id=837
>
> On Mon, Jan 11, 2016 at 11:55 AM, Kat  
> wrote:
>
>> Hi Abhi,
>>
>> In terms of revision times, I want to show all the current revision 
>> times. Also, in the future, if there is any revision times being updated in 
>> the folder, I want it to be automatically being added in the excel sheet as 
>> well. Please see below the file situation and excel print screen as the 
>> result I want it to be shown. Let me know if you have any further issue. 
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> On Monday, January 11, 2016 at 1:26:07 PM UTC+8, Abhi wrote:
>>>
>>> Please elaborate what do you mean by "revision times". Do you want to 
>>> show the time when it was most recently updated or you want to show how 
>>> many times has it been updated?
>>>
>>>
>>> On Mon, Jan 11, 2016 at 9:52 AM, Kat  wrote:
>>>
 Hi all, 

 I want to create a xlsm file which list out the folder name, file name 
 and revision times with its corresponding date modified. When there is new 
 file updated, i hope it can be updated automatically in the workbook. may 
 I 
 know how can I achieve this?

 Thanks in advanced.


 Cheers

 -- 
 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 https://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.

>>>
>>>
>

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ vba code for listing folder name and file name

[Mandeep Baluja]

Revision time ?? I have not heard about this while searching it on the 
internet I found 
this http://excel.tips.net/T002868_Using_Revision_Tracking.html which track 
the changes done workbook shared on network. Is revision time being noted 
anywhere in your workbook your snapshot is not showing what is the revision 
time you have entered 6,7 etc. 

This is a bit difficult but not impossible,What i assumed is you each sheet 
in Excel having the History sheet which tracks the changes with the last 
line "The history ends with the changes saved on 11-01-2016 at 13:01." 
after certain interval
 
Confirm this first !!


Regards,
Mandeep baluja




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

FORUM RULES

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

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

$$Excel-Macros$$ Required Missing Date

[Ahmed Emam]

Dear All members,

I have an excel sheet which being extracted from a fingerprints device that
shows all dates employees had put their fingers already to prove their
presence.

My request is how to make equation that shows to me the other dates
employees didn't put their fingerprints in the device.

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+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Required Missing Date

[Abhishek Jain]

Hi

Plz share a sample workbook.



On Sunday, January 10, 2016, Ahmed Emam  wrote:

> Dear All members,
>
> I have an excel sheet which being extracted from a fingerprints device
> that shows all dates employees had put their fingers already to prove their
> presence.
>
> My request is how to make equation that shows to me the other dates
> employees didn't put their fingerprints in the device.
>
> 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+unsubscr...@googlegroups.com
> 
> .
> To post to this group, send email to excel-macros@googlegroups.com
> .
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Correction required in highlet cell & refresh d15 automatically when last any entry of any raw change

[Pankaj Sharma]

in Conditional formatting use formula:

=AND($F5>=TODAY(),$F5<=TODAY()+14)

Applied to :
=$A$5:$AI9



and secondly in Function GetConcat formula coding use :

Application.Volatile

for Auto refresh





*Pankaj Sharma  *

*MIS Analyst*

*Greater Kailash-1, New Delhi*

*Email   *
*p ankaj123...@gmail.com *
*Skype**   pankaj.sharma_pj*




On Sun, Jan 10, 2016 at 1:27 PM, Pankaj Sharma 
wrote:

> Check it !
>
>
> *Pankaj Sharma  *
>
> *MIS Analyst*
>
> *Greater Kailash-1, New Delhi*
>
> *Email   *
> *p ankaj123...@gmail.com
> **Skype**   pankaj.sharma_pj*
>
>
>
>
> -- Forwarded message --
> From: big smile 
> Date: Sun, Jan 10, 2016 at 11:19 AM
> Subject: $$Excel-Macros$$ Correction required in highlet cell & refresh
> d15 automatically when last any entry of any raw change
> To: excel-macros@googlegroups.com
>
>
>
>
>
> Respected All
>
> I have attached excel files too  It has some still issue . I think there
> is some correction required   in the formula  1]  When  F column falls
> under 15 days before today -- only that time full raw should be yellow  Today
> is 9/1/2016  so any date from 9/1/2016 to 24/1/16 -- then only full raw
> should be yellow  But at present it happens even if due date is before
> today also -- ex  f6 is  15/12/2015  then also it become yellow 2] In
> Cell - D 15  not work according to my question  If I make any changes in
> any cell   ex -- If I make the change in Raw 9 In stead of mediclaim I
> put shop in e9 also  change in R 9 -- some change  Then all the details
> pertaining -- respectively  change in D 15 at present it not change for D
> 15 3] I have to refesh my cell entry then It show change I want that if I
> make any changes in any raw  then last updated raw details  then it
> should automatically updates all  details of that raw  & show it on Cell
> D15 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+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>

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

FORUM RULES

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

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

$$Excel-Macros$$ Refresh d15 automatically when last any entry of any raw change

[big smile]

 Respected All Thanks  a lot  High light  Raw works properly  But still
Second option do not work

Enclosed file for details  1] In Cell - D 15  not work according to my
question  If I make any changes in any cell   ex -- If I make the change
any other raw  Then all the details pertaining -- respectively raw  change
in D 15 at present it comes only I change raw 9 To be more precise if I
make the changes in raw 8  then what  ever is in D8 should come in D 15 If
make the changes in raw 6 then what  ever is in D6 should come in D 15 I
want that if I make any changes in any raw  then last updated raw details  then
it should automatically updates all  details of that raw  & show it on Cell
D15 Thanks in advance








On 10 January 2016 at 14:18, Pankaj Sharma  wrote:

> in Conditional formatting use formula:
>
> =AND($F5>=TODAY(),$F5<=TODAY()+14)
>
> Applied to :
> =$A$5:$AI9
>
>
>
> and secondly in Function GetConcat formula coding use :
>
> Application.Volatile
>
> for Auto refresh
>
>
>
>
>
> *Pankaj Sharma  *
>
> *MIS Analyst*
>
> *Greater Kailash-1, New Delhi*
>
> *Email   *
> *p ankaj123...@gmail.com
> **Skype**   pankaj.sharma_pj*
>
>
>
>
> On Sun, Jan 10, 2016 at 1:27 PM, Pankaj Sharma 
> wrote:
>
>> Check it !
>>
>>
>> *Pankaj Sharma  *
>>
>> *MIS Analyst*
>>
>> *Greater Kailash-1, New Delhi*
>>
>> *Email   *
>> *p ankaj123...@gmail.com
>> **Skype**   pankaj.sharma_pj*
>>
>>
>>
>>
>> -- Forwarded message --
>> From: big smile 
>> Date: Sun, Jan 10, 2016 at 11:19 AM
>> Subject: $$Excel-Macros$$ Correction required in highlet cell & refresh
>> d15 automatically when last any entry of any raw change
>> To: excel-macros@googlegroups.com
>>
>>
>>
>>
>>
>> Respected All
>>
>> I have attached excel files too  It has some still issue . I think there
>> is some correction required   in the formula  1]  When  F column falls
>> under 15 days before today -- only that time full raw should be yellow  Today
>> is 9/1/2016  so any date from 9/1/2016 to 24/1/16 -- then only full raw
>> should be yellow  But at present it happens even if due date is before
>> today also -- ex  f6 is  15/12/2015  then also it become yellow 2] In
>> Cell - D 15  not work according to my question  If I make any changes in
>> any cell   ex -- If I make the change in Raw 9 In stead of mediclaim I
>> put shop in e9 also  change in R 9 -- some change  Then all the details
>> pertaining -- respectively  change in D 15 at present it not change for
>> D 15 3] I have to refesh my cell entry then It show change I want that
>> if I make any changes in any raw  then last updated raw details  then it
>> should automatically updates all  details of that raw  & show it on Cell
>> D15 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+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>>
> --
> 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 

Fwd: $$Excel-Macros$$ Refresh d15 automatically when last any entry of any raw change

[Pankaj Sharma]

use this:


Private Sub Worksheet_Change(ByVal Target As Range)
Dim r As Long: r = Target.Row
If r >= 5 And r < Sheet1.Range("A" & Rows.Count).End(xlUp).Row Then
r = r - 3
Range("C15").FormulaR1C1 = "=OFFSET(R[-12]C[1]," & r & ",0)"
End If
End Sub



*Pankaj Sharma  *

*MIS Analyst*

*Greater Kailash-1, New Delhi*

*Email   *
*p ankaj123...@gmail.com *
*Skype*
*   pankaj.sharma_pj**Facebook  www.facebook.com/dude.pj
*




-- Forwarded message --
From: big smile 
Date: Sun, Jan 10, 2016 at 6:18 PM
Subject: $$Excel-Macros$$ Refresh d15 automatically when last any entry of
any raw change
To: excel-macros@googlegroups.com


Respected All Thanks  a lot  High light  Raw works properly  But still
Second option do not work

Enclosed file for details  1] In Cell - D 15  not work according to my
question  If I make any changes in any cell   ex -- If I make the change
any other raw  Then all the details pertaining -- respectively raw  change
in D 15 at present it comes only I change raw 9 To be more precise if I
make the changes in raw 8  then what  ever is in D8 should come in D 15 If
make the changes in raw 6 then what  ever is in D6 should come in D 15 I
want that if I make any changes in any raw  then last updated raw details  then
it should automatically updates all  details of that raw  & show it on Cell
D15 Thanks in advance








On 10 January 2016 at 14:18, Pankaj Sharma  wrote:

> in Conditional formatting use formula:
>
> =AND($F5>=TODAY(),$F5<=TODAY()+14)
>
> Applied to :
> =$A$5:$AI9
>
>
>
> and secondly in Function GetConcat formula coding use :
>
> Application.Volatile
>
> for Auto refresh
>
>
>
>
>
> *Pankaj Sharma  *
>
> *MIS Analyst*
>
> *Greater Kailash-1, New Delhi*
>
> *Email   *
> *p ankaj123...@gmail.com
> **Skype**   pankaj.sharma_pj*
>
>
>
>
> On Sun, Jan 10, 2016 at 1:27 PM, Pankaj Sharma 
> wrote:
>
>> Check it !
>>
>>
>> *Pankaj Sharma  *
>>
>> *MIS Analyst*
>>
>> *Greater Kailash-1, New Delhi*
>>
>> *Email   *
>> *p ankaj123...@gmail.com
>> **Skype**   pankaj.sharma_pj*
>>
>>
>>
>>
>> -- Forwarded message --
>> From: big smile 
>> Date: Sun, Jan 10, 2016 at 11:19 AM
>> Subject: $$Excel-Macros$$ Correction required in highlet cell & refresh
>> d15 automatically when last any entry of any raw change
>> To: excel-macros@googlegroups.com
>>
>>
>>
>>
>>
>> Respected All
>>
>> I have attached excel files too  It has some still issue . I think there
>> is some correction required   in the formula  1]  When  F column falls
>> under 15 days before today -- only that time full raw should be yellow  Today
>> is 9/1/2016  so any date from 9/1/2016 to 24/1/16 -- then only full raw
>> should be yellow  But at present it happens even if due date is before
>> today also -- ex  f6 is  15/12/2015  then also it become yellow 2] In
>> Cell - D 15  not work according to my question  If I make any changes in
>> any cell   ex -- If I make the change in Raw 9 In stead of mediclaim I
>> put shop in e9 also  change in R 9 -- some change  Then all the details
>> pertaining -- respectively  change in D 15 at present it not change for
>> D 15 3] I have to refesh my cell entry then It show change I want that
>> if I make any changes in any raw  then last updated raw details  then it
>> should automatically updates all  details of that raw  & show it on Cell
>> D15 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+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit 

$$Excel-Macros$$ Fwd: Need Help

[Pankaj Sharma]

use this:

Sub Reporting()
Dim abc As Long: abc = Sheet1.Range("A" & Rows.Count).End(xlUp).Row
Sheet1.Range("B7:B" & abc).FormulaR1C1 =
"=IF(RC1=,,TEXT(RC1,""mmm"")&""-""(RC1,""yy""))"
End Sub



*Pankaj Sharma  *

*MIS Analyst*

*Greater Kailash-1, New Delhi*

*Email   *
*p ankaj123...@gmail.com *
*Skype**   pankaj.sharma_pj*




-- Forwarded message --
From: Debottam Roy 
Date: Sun, Jan 10, 2016 at 5:18 PM
Subject: Need Help
To: Excel Prince 


Hello Sir,

I have attached one file. I faced one problem Please suggest.

I have tried multiple times but still I got partial correct result. Please
help me as early as possible.

Thanks and Regards:

Dev
Contact No: 9958975076

-- 
You received this message because you are subscribed to the Google Groups
"Excel Prince" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excelprince+unsubscr...@googlegroups.com.
To post to this group, send email to excelpri...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/excelprince/CADhaybARRbxSffkFiUk3nZVqUL22uLvVvLPYWgtW8WOEeWWHcQ%40mail.gmail.com

.
For more options, visit https://groups.google.com/d/optout.

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

FORUM RULES

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

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


Book1(test).xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12