$$Excel-Macros$$ Access 2007 Tutorials

[Mr excel]

Dear all,

First of all sorry for posting in the wrong forum. Pls give me any
information on learning Access.i had Access 2007 installed on my computer.I
want the Detailed learning notes / Tutorials on it.


Kindly post any tutorials,links with examples on access..



Thanks In Advance
keechak.

-- 
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Access 2007 Tutorials

[Mr excel]

Thanks for the reply..Mr.Vijay...


On Mon, Jun 10, 2013 at 1:32 PM, P.VIJAYKUMAR  wrote:

> Respected Mr Excel,
>
> You can check the following links.
> http://allenbrowne.com/tips.html
> http://www.baycongroup.com/access2007/
> http://www.gcflearnfree.org/access2007
> http://ms-access-tips.blogspot.in/p/advanced-access-2007-tutorials.html
> http://inpics.net/tutorials/access2007/basics.html
> http://www.tutorialspoint.com/listtutorials/ms-access/1
>
> There are also plenty other sites and pdf 's on access .try googling and
> download them
> Regards,
> VIJAYKUMAR.
>
>
>
> On Mon, Jun 10, 2013 at 12:11 PM, Mr excel  wrote:
>
>> Dear all,
>>
>> First of all sorry for posting in the wrong forum. Pls give me any
>> information on learning Access.i had Access 2007 installed on my computer.I
>> want the Detailed learning notes / Tutorials on it.
>>
>>
>> Kindly post any tutorials,links with examples on access..
>>
>>
>>
>> Thanks In Advance
>> keechak.
>>
>> --
>> 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?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>
>
> --
>
>
>
>
>
>
>
>
>
> P.VIJAY KUMAR
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> 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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Movie Collection Manager

[Mr excel]

Nice & good example dude...

On Tue, Mar 6, 2012 at 1:19 PM, Abhishek Jain wrote:

> Anyone...?
>
>
> On Thu, Mar 1, 2012 at 6:57 PM, Abhishek Jain wrote:
>
>> Hi friends,
>>
>> For the sake of learning I just keep doing some thing or the other,
>> mostly in excel. Once something occurred to me and this is what I have
>> accomplished so far -
>>
>> http://www.youtube.com/watch?v=-NT6IYrTqew
>>
>> Please view the video to understand what exactly I am talking about
>> (recommended in full screen for better view).
>>
>> As can be viewed, whenever I need to add a movie details in this file I
>> have to manually enter the same. Before this, I tried several movie manager
>> softwares, but none of them seemed perfect (due to one or the other
>> problem). These movie manager sofwares use scripts (PHP or Sql, may be, I
>> have no idea) to connect to different movie database sites (imdb, amazon,
>> etc.) and then to automatically download the details, covers, etc.
>>
>> My question - is there any way we can make some thing similar to those
>> scripts OR incorporate one of them in VBA to retrieve these details via
>> Excel only.
>>
>> The reason why am I asking this - I have 1200+ Hollywood movies, 200+
>> Bollywood movies, 300+ Documentaries, Over 40 seasons of various serials
>> (Prison Break, Two and a Half Men, I dream of jeannie, Lie to me, Big bang
>> theory, How I met your mother, etc.) and some other stuff. Now you all can
>> easily understand that I would loose all my hair if I had to update all
>> these.manually.
>>
>> Any and all ideas are welcome.
>>
>> I would be happy to share further details if anyone is interested in
>> working with me on this.
>>
>> Thanks & regards,
>>
>> Abhishek
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Userform Filter

[Mr excel]

try using the vlookup function or DLOOKUP function on the form.

On Sat, Mar 3, 2012 at 11:15 AM, Deba Ranjan  wrote:

> *
> *
>
>
>
>
> *Regards*
>
> *Deba Ranjan P**
> *
> *[image: http://www.fileden.com/files/2008/8/21/2058970/greatday.gif]***
>
> ^^ஜ۩۞۩ஜ▬▬▬ ▬^^
>
> * *
> *
> *
>
>
>
> -- Forwarded message --
> From: Deba Ranjan 
> Date: Thu, Mar 1, 2012 at 5:58 PM
> Subject: $$Excel-Macros$$ Userform Filter
> To: NOORAIN ANSARI , David Grugeon <
> grug...@gmail.com>
> Cc: excel-macros@googlegroups.com
>
>
> Dear Sir,
>
>Please help me in creating user for filter. i mean :- for eg.
>
> 1. customer name:- Ranjan lawran
> 2. Mobile:- 6587459874
> 3. state:- delhi.
>
>
>   Above data is just an example, in user form, when i click ranjan Lawran,
> his particular number *6587459874* as well as his state should come. can
> u please do for me that in urgent basis. PLease.
>
>
>
> *Regards*
>
> *Deba Ranjan P**
> *
> *[image: http://www.fileden.com/files/2008/8/21/2058970/greatday.gif]***
>
> ^^ஜ۩۞۩ஜ▬▬▬ ▬^^
>
> * *
> *
> *
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<>

$$Excel-Macros$$ Show Image on Form

[Mr excel]

hi forum,
  Is it possible to show an image on the userform based on the selection of
a check box.Say for example i had four countries like
Australia,Newzealand,England & West Indies.I had created four check boxes
for these four countries.I want to show their Country Flags based on the
selection of each Country opposite to the check box...Kindly help.

Thanks & regards...

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ how to populate combobox on another combobox in excel userform.

[Mr excel]

Pls update my requirement.i want to display items with the headings in the
second combo box with the criteria based on first combobox.

For example

Col A (COMBO BOX 1)   COL B (COMBO BOX 2)

ASIA ASIA HEADING
AUSTRALIA   india
 srilanka
 Australia- Heading
 sydney
  melbourne

how would i generate the same with the excel vba..

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Find differences in two worksheets.

[Mr excel]

hi group,

  I had a routine question regarding the comparision of worksheets.I had
searched the internet regarding the differences between two worksheets
which have similiar columns & headings.I want to find out the
changes/differences between the two worksheets.

In depth, I had a master worksheet with columns of EmpNo,Emp
Name,BASIC,HRA,DA & other allowances.I also get worksheet with the similiar
headings every month from the HR dept to check the differences like new
joinees or Resigned employees with their salary structure.what i want is to
know how to find out the differences / changes between the twoI want
the changes in every column in new worksheets.

I tried using the pivot table.is my approach the easiest or accurate one.i
would also like to know whether the same can be done using formulas or VBA.

Pls Help.

Thanks & Regards.

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Find differences between four columns.

[Mr excel]

hi all,
  i m in need of help regarding finding the differences between four
columns i.e. RECEIPT No & AMT. in sheet1 and RECEIPT No & AMT in sheet2.i
would like to know the Formula which will highlight the differences between
the two columns in both sheets.

  Receipt No Total Paid
Receipt No Total Paid  1151886 490
1151886 490  1151882 2100
1151882 2100  1151883 50
1151883 50  1151881 3500
1151881 1500  1151880 4000
1151881 2000  1151894 710
1151880 800  1151894 490
1151880 1200


1151894 710


1151894 490
For example the RECEIPT no:1151881=3500 is splitted into two in the second
worksheet.as 1151881=1500 & 2000.In short i need to lookup the Receipt No
with the amount in worksheet one with the Receipt no with the amount in
worksheet two.i need only THOSE receipt no and Amounts which are different..

Please guide me...

thanks & regards

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Find differences between four columns.

[Mr excel]

thanks for the speedy reply sir..how about using VBA for finding the
differences between the columns and pasting them(only the DIFFERENT
ones-Receipt no & amount which are not matched to a new sheet one down the
other...

On Thu, May 3, 2012 at 12:08 AM, Mr excel  wrote:

> hi all,
>   i m in need of help regarding finding the differences between four
> columns i.e. RECEIPT No & AMT. in sheet1 and RECEIPT No & AMT in sheet2.i
> would like to know the Formula which will highlight the differences between
> the two columns in both sheets.
>
>   Receipt No Total Paid
> Receipt No Total Paid  1151886 490
> 1151886 490  1151882 2100
> 1151882 2100  1151883 50
> 1151883 50  1151881 3500
> 1151881 1500  1151880 4000
> 1151881 2000  1151894 710
> 1151880 800  1151894 490
> 1151880 1200
>
>
> 1151894 710
>
>
> 1151894 490
> For example the RECEIPT no:1151881=3500 is splitted into two in the second
> worksheet.as 1151881=1500 & 2000.In short i need to lookup the Receipt No
> with the amount in worksheet one with the Receipt no with the amount in
> worksheet two.i need only THOSE receipt no and Amounts which are different..
>
> Please guide me...
>
> thanks & regards
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Find differences between four columns.

[Mr excel]

A small correction for my requirement please i need to highlight those
receipt nos which had different amounts..Verma bhayya...formula ko change
karona please taaki,Receipt nos with different amounts highlight hue to
color kardena

thanks a lot for the help

On Thu, May 3, 2012 at 12:21 AM, Mr excel  wrote:

> thanks for the speedy reply sir..how about using VBA for finding the
> differences between the columns and pasting them(only the DIFFERENT
> ones-Receipt no & amount which are not matched to a new sheet one down the
> other...
>
>
> On Thu, May 3, 2012 at 12:08 AM, Mr excel  wrote:
>
>> hi all,
>>   i m in need of help regarding finding the differences between four
>> columns i.e. RECEIPT No & AMT. in sheet1 and RECEIPT No & AMT in sheet2.i
>> would like to know the Formula which will highlight the differences between
>> the two columns in both sheets.
>>
>>   Receipt No Total Paid
>> Receipt No Total Paid  1151886 490
>> 1151886 490  1151882 2100
>> 1151882 2100  1151883 50
>> 1151883 50  1151881 3500
>> 1151881 1500  1151880 4000
>> 1151881 2000  1151894 710
>> 1151880 800  1151894 490
>> 1151880 1200
>>
>>
>> 1151894 710
>>
>>
>> 1151894 490
>> For example the RECEIPT no:1151881=3500 is splitted into two in the
>> second worksheet.as 1151881=1500 & 2000.In short i need to lookup the
>> Receipt No with the amount in worksheet one with the Receipt no with the
>> amount in worksheet two.i need only THOSE receipt no and Amounts which are
>> different..
>>
>> Please guide me...
>>
>> thanks & regards
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Find differences between four columns.

[Mr excel]

Getting error bhayy..please correct.

On Thu, May 3, 2012 at 12:59 AM, Rajan_Verma wrote:

> ** **
>
> *Wanna Use VBA??
>
> *
>
> See the attached Sheet.. You can A*dd record dynamically* in second table
> Try this ;
>
> Sub GetUnMatchedValueonNewSheet()
>
> 
>
> Dim ArrTabl1
>
> Dim ArrTabl2
>
> Dim ArrResult() As String
>
> *Dim objDic As Object*
>
> *Set objDic = CreateObject("Scripting.Dictionary")*
>
> 
>
> Dim lngCounter As Long
>
> ArrTabl1 = Range("rngTable1").CurrentRegion
>
> ArrTabl2 = Range("rngTable2").CurrentRegion
>
> 
>
> For lngCounter = LBound(ArrTabl1) To UBound(ArrTabl1)
>
> *If Not objDic.Exists(ArrTabl1(lngCounter, 1)) Then*
>
> *objDic.Add ArrTabl1(lngCounter, 1) & "," &
> ArrTabl1(lngCounter, 2), ArrTabl1(lngCounter, 1) & "," &
> ArrTabl1(lngCounter, 2)*
>
> End If
>
> Next
>
> lngCounter = 0
>
> lngCounter2 = 0
>
> For lngCounter = LBound(ArrTabl2) To UBound(ArrTabl2)
>
> *If Not objDic.Exists(ArrTabl2(lngCounter, 1) & "," &
> ArrTabl2(lngCounter, 2)) Then*
>
> ReDim Preserve ArrResult(0 To lngCounter2)
>
> ArrResult(lngCounter2) = ArrTabl2(lngCounter, 1) & ":" &
> ArrTabl2(lngCounter, 2)
>
> lngCounter2 = lngCounter2 + 1
>
> End If
>
> Next
>
> With Worksheets("Sheet2").Range("A1")
>
> .CurrentRegion.ClearContents
>
> *   .Resize(UBound(ArrResult) + 1, 1).Value =
> Application.Transpose(ArrResult)*
>
>.CurrentRegion.TextToColumns Destination:=Range("A1"),
> DataType:=xlDelimited, _
>
> TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False,
> Tab:=True, _
>
> Semicolon:=False, Comma:=False, Space:=False, Other:=True,
> OtherChar _
>
> :=":", FieldInfo:=Array(Array(1, 1), Array(2, 1)),
> TrailingMinusNumbers:=True
>
>     .Parent.Activate
>
>End With
>
> ** **
>
> *'Free from memory*
>
> *Set objDic = Nothing*
>
> *Erase ArrResult*
>
> *Erase ArrTabl1*
>
> *Erase ArrTabl2*
>
> ** **
>
> End Sub
>
> 
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Mr excel
> *Sent:* 03 May 2012 00:27
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Find differences between four columns.
>
> ** **
>
> A small correction for my requirement please i need to highlight those
> receipt nos which had different amounts..Verma bhayya...formula ko change
> karona please taaki,Receipt nos with different amounts highlight hue to
> color kardena
>
>
> thanks a lot for the help
>
> On Thu, May 3, 2012 at 12:21 AM, Mr excel  wrote:*
> ***
>
> thanks for the speedy reply sir..how about using VBA for finding the
> differences between the columns and pasting them(only the DIFFERENT
> ones-Receipt no & amount which are not matched to a new sheet one down the
> other...
>
> ** **
>
> On Thu, May 3, 2012 at 12:08 AM, Mr excel  wrote:*
> ***
>
> hi all,
>   i m in need of help regarding finding the differences between four
> columns i.e. RECEIPT No & AMT. in sheet1 and RECEIPT No & AMT in sheet2.i
> would like to know the Formula which will highlight the differences between
> the two columns in both sheets.
>
> Receipt No
>
> Total Paid
>
> Receipt No
>
> Total Paid
>
> 1151886
>
> 490
>
> 1151886
>
> 490
>
> 1151882
>
> 2100
>
> 1151882
>
> 2100
>
> 1151883
>
> 50
>
> 1151883
>
> 50
>
> 1151881
>
> 3500
>
> 1151881
>
> 1500
>
> 1151880
>
> 4000
>
> 1151881
>
> 2000
>
> 1151894
>
> 710
>
> 1151880
>
> 800
>
> 1151894
>
> 490
>
> 1151880
>
> 1200
>
> 1151894
>
> 710
>
> 1151894
>
> 490
>
>
> For example the RECEIPT no:1151881=3500 is splitted into two in the second
> worksheet.as 1151881=1500 & 2000.In short i need to lookup the Receipt No
> 

Re: $$Excel-Macros$$ Find differences between four columns.

[Mr excel]

Sorry Verma,,i had messed up everything here.Got confused with the
requirement.

What i want actually is to find out the differences between the FIRST table
with Receipt No & Amt and SECOND table with Receipt No & Amt.

 Example:  The receipt no  1151881 in Master data is 4500
 It should match the Receipt No 1151881 with the amount TOTAL in THIS month
data.  i.e. the amount in the second table may be splitted into two or more
lines,but the AMT in Both the tables should be same with the SAME RECEIPT
No's in both tables.
 I want the formula to find out which Receipts with amounts did not matched
the RECEIPT NO & amt in the second table
 Master Data
This Month Data  Receipt No Total Paid   Receipt No Total Paid
 1151886 490
1151886 490
 1151882 2100
1151882 2100
 1151883 50
1151883 50
 *1151881* *4500*
*1151881* *1500*
 1151880 4000
*1151881* *2000*
 1151894 710
1151880 800
 1151894 490
1151880 1200



1151894 710



1151894 490

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Find differences between four columns.

[Mr excel]

Verma bhayya,,
The code is working fine but only one sided.i mean if there are no Receipts
in List 2 which are in List 1 then the code finds the difference only
between these two.how to change the code so that it shows all the missing
receipts with amounts either way...Receipts with amounts not appearing in
list 2 compared with list 1 also...please help...

Thanks in advance

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Find differences in two worksheets.

[Mr excel]

I want to know  the differences between the two sheets.i.e. Main
worksheet(Master SHEET) and the Current Month(Apr'12) Worksheet.

Please give me any formula or code for finding out the differences between
the two sheets.
I m attaching the worksheet as an example..

Thanks

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


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

Re: $$Excel-Macros$$ Find differences in two worksheets.

[Mr excel]

Nice different approach verma...thanks a lot.is there any formula to do
the same.i mean to find out the differences between the two sheets.

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Ms-Excel Bible by john walkenbach

[Mr excel]

hi, i had Excel Bible 2002 by John Walkenbach.if u want it i will post it
here.


On Thu, May 13, 2010 at 11:52 PM, Nani Ram <06n...@gmail.com> wrote:

> Hi Excel Masters,
>
> Could any one have MS-Excel Bible by john walkenbach e-book.
> if so could please send it to me at 06n...@gmail.com.
>
>
> Thanks in advance,
>
> Nani Ram
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Ms-Excel Bible by john walkenbach

[Mr excel]

i had also found 2003 version shall i upload it to the forum.

On Fri, May 14, 2010 at 10:12 AM, Mr excel  wrote:

> hi, i had Excel Bible 2002 by John Walkenbach.if u want it i will post it
> here.
>
>
>
> On Thu, May 13, 2010 at 11:52 PM, Nani Ram <06n...@gmail.com> wrote:
>
>> Hi Excel Masters,
>>
>> Could any one have MS-Excel Bible by john walkenbach e-book.
>> if so could please send it to me at 06n...@gmail.com.
>>
>>
>> Thanks in advance,
>>
>> Nani Ram
>>
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Do not request or provide copyrighted eBook in group.

[Mr excel]

Yeah Ayush had said is true.

On Sat, May 15, 2010 at 10:41 AM, Ayush  wrote:

> Dear Group,
>
> Please do not send any request of copyrighted material in group. Any
> ebook/material which is copyrighted should not be shared in forum as
> it is a loss for the owner of that item.
>
> You are always welcome to share thoughts, idea , queries, tips and
> tricks in group. They are not copyrighted at all :)
>
> I hope you understand the same. Any such message again could lead to
> termination from the group membership.
>
> Keep Posting.
>
> Best regards,
> Ayush Jain
> Group Owner
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Online tutorials for macros

[Mr excel]

Very useful for learning the basics.thanks for the links

On Mon, Jul 12, 2010 at 10:13 AM, Soni.Rajender wrote:

> Hi
>
> Use the below link:
>
> http://www.familycomputerclub.com/excel/excel2003_macros.html
>
> the link was already suggested by one of our group member.
>
> Regards
> Rajender Soni
>
> On Jul 11, 10:05 am, manan joshi  wrote:
> > try google vedio and on you tube there are lot many then you want sure it
> > will help
> >
> > On Sat, Jul 10, 2010 at 9:20 PM, krishnan moorthy
> > wrote:
> >
> >
> >
> > > Dear All,
> >
> > > I am a beginner in creating excel macros. Is there a website that has
> > > online tutorials on excel macros?
> >
> > > Any kind of information would be of great help.
> >
> > > Thanks in advance!! :)
> >
> > > Krishnan
> >
> > >  --
> >
> > >
> ---­---
> > > Some important links for excel users:
> > > 1. Follow us on TWITTER for tips tricks and links :
> > >http://twitter.com/exceldailytip
> > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >
> > > To post to this group, send email to excel-macros@googlegroups.com
> >
> > > <><><><><><><><><><><><><><><><><><><><><><>
> > > HELP US GROW !!
> >
> > > We reach over 7000 subscribers worldwide and receive many nice notes
> about
> > > the learning and support from the group.Let friends and co-workers know
> they
> > > can subscribe to group at
> > >http://groups.google.com/group/excel-macros/subscribe- Hide quoted text
> -
> >
> > - Show quoted text -
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Copy & Paste values in adjacent cell

[Mr excel]

*Copy & Paste values in adjacent cell*
i had data in html format.i want the data to be splitted into columns in
excel.

*HTML FORMAT*
Employee name
Emp id


johnabraham wesleypeter neiljohn
254800254801 254802  254803

and so on.


i tried copying the data from html to excel. Then applied text to columns
but i m getting incomplete names from this step.

My problem is how would i get the full name in one Column(Column B) & the
emp id in the next Column (COLUMN C).Column A will have the data copied from
html page. The length of the employee name differs. The only saving tip is
that the employee name will suffix with sno like

*Johnabraham -1
254800
*
Any function or VBA routine will help me.

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Calculate Due dates

[Mr excel]

For example,
The billing cycle for supplier A is 5th of this month to 4th next
so all the transactions pertaining to Supplier "A" will be billed in this
period.
Here in this example, there is only one transaction related to "A" and the
billing is done for the month of jan'2011 so in the month column
Jan'2011 should be displayed as this single transaction is done between 5th
of Jan'2011-4th Feb'2011
Likewise for all the other suppliers…
Hope I had made it clear.


On Wed, May 4, 2011 at 9:57 PM, ashish koul  wrote:

> can you expaln with some example in workbook
>
>
> On Tue, May 3, 2011 at 8:30 PM, keechak  wrote:
>
>> Hi forum,
>>
>> Thanks very much for creating such a wonderful forum.
>>
>> I had a problem in calculating the due dates for different customers.
>>
>> Col A contains suppliers with the dates they supply the raw material &
>> amount of the material supplied in the next columns B & C Respectively.
>>
>> I need a formula or a vba routine which can calculate the due dates for
>> all the suppliers who supply the material.
>>
>> There are certain cut-off dates for each supplier in calculating the due
>> dates in the billing cycle table.
>>
>> I want to print the months in Column D basing upon the supply date for
>> each supplier and the cut-off dates in the right side table(Billing Cycle
>> -table).
>>
>> Please help me
>>
>> WebRep
>> Overall rating
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

WebRep
Overall rating

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Calculate Due dates

[Mr excel]

dear ashish,,

   That is excellent & great.Thanks a lot .The formula u provided is
very nearer to the solution i wanted.everthing is same except in the month
column of the sheet.Name of the month should be printed like April'2011
instead of *05-Apr-2011   TO  04-May-2011*.

the above formula also is very helpful to me in another scenario..

Really my joy knew no boundaries..

On Fri, May 6, 2011 at 6:46 AM, ashish koul  wrote:

> try  this one
>
> On Thu, May 5, 2011 at 9:11 PM, ashish koul  wrote:
>
>> see if it helps
>>
>>
>> On Thu, May 5, 2011 at 7:23 AM, Mr excel  wrote:
>>
>>> For example,
>>> The billing cycle for supplier A is 5th of this month to 4th next
>>> so all the transactions pertaining to Supplier "A" will be billed in this
>>> period.
>>> Here in this example, there is only one transaction related to "A" and
>>> the billing is done for the month of jan'2011 so in the month column
>>> Jan'2011 should be displayed as this single transaction is done between
>>> 5th of Jan'2011-4th Feb'2011
>>> Likewise for all the other suppliers…
>>> Hope I had made it clear.
>>>
>>>
>>>
>>> On Wed, May 4, 2011 at 9:57 PM, ashish koul wrote:
>>>
>>>> can you expaln with some example in workbook
>>>>
>>>>
>>>> On Tue, May 3, 2011 at 8:30 PM, keechak  wrote:
>>>>
>>>>> Hi forum,
>>>>>
>>>>> Thanks very much for creating such a wonderful forum.
>>>>>
>>>>> I had a problem in calculating the due dates for different customers.
>>>>>
>>>>> Col A contains suppliers with the dates they supply the raw material &
>>>>> amount of the material supplied in the next columns B & C Respectively.
>>>>>
>>>>> I need a formula or a vba routine which can calculate the due dates for
>>>>> all the suppliers who supply the material.
>>>>>
>>>>> There are certain cut-off dates for each supplier in calculating the
>>>>> due dates in the billing cycle table.
>>>>>
>>>>> I want to print the months in Column D basing upon the supply date for
>>>>> each supplier and the cut-off dates in the right side table(Billing Cycle
>>>>> -table).
>>>>>
>>>>> Please help me
>>>>>
>>>>>  WebRep
>>>>> Overall rating
>>>>>
>>>>>
>>>>> --
>>>>>
>>>>> --
>>>>> Some important links for excel users:
>>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>>> http://twitter.com/exceldailytip
>>>>> 2. Join our LinkedIN group @
>>>>> http://www.linkedin.com/groups?gid=1871310
>>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>>>
>>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>>
>>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>>> Like our page on facebook , Just follow below link
>>>>> http://www.facebook.com/discussexcel
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> *Regards*
>>>> * *
>>>> *Ashish Koul*
>>>> *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
>>>> *akoul*.wordpress.com <http://akoul.wordpress.com/>
>>>> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>>>>
>>>>
>>>> P Before printing, think about the environment.
>>>>
>>>>
>>>> --
>>>>
>>>> --
>>>> Some important links for excel users:
>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>> http://twitter.com/exceldailytip
>>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>> 4. L

Re: $$Excel-Macros$$ Calculate Due dates

[Mr excel]

what i meant is instead of the period,the formula is showing as a result the
formula should return only the month with the year.
For example,*05-Apr-2011   TO  04-May-2011*.
should return apr'2011.

hope this is not confusing you...ashish...

On Sat, May 7, 2011 at 1:25 PM, ashish koul  wrote:

>
> change
> "dd-mmm-" to
>
> "dd-mmm'" in formula
>
>
> On Sat, May 7, 2011 at 7:47 AM, Mr excel  wrote:
>
>> dear ashish,,
>>
>>That is excellent & great.Thanks a lot .The formula u provided is
>> very nearer to the solution i wanted.everthing is same except in the month
>> column of the sheet.Name of the month should be printed like April'2011
>> instead of *05-Apr-2011   TO  04-May-2011*.
>>
>> the above formula also is very helpful to me in another scenario..
>>
>> Really my joy knew no boundaries..
>>
>>
>> On Fri, May 6, 2011 at 6:46 AM, ashish koul wrote:
>>
>>> try  this one
>>>
>>> On Thu, May 5, 2011 at 9:11 PM, ashish koul wrote:
>>>
>>>> see if it helps
>>>>
>>>>
>>>> On Thu, May 5, 2011 at 7:23 AM, Mr excel wrote:
>>>>
>>>>> For example,
>>>>> The billing cycle for supplier A is 5th of this month to 4th next
>>>>> so all the transactions pertaining to Supplier "A" will be billed in
>>>>> this period.
>>>>> Here in this example, there is only one transaction related to "A" and
>>>>> the billing is done for the month of jan'2011 so in the month column
>>>>> Jan'2011 should be displayed as this single transaction is done between
>>>>> 5th of Jan'2011-4th Feb'2011
>>>>> Likewise for all the other suppliers…
>>>>> Hope I had made it clear.
>>>>>
>>>>>
>>>>>
>>>>> On Wed, May 4, 2011 at 9:57 PM, ashish koul wrote:
>>>>>
>>>>>> can you expaln with some example in workbook
>>>>>>
>>>>>>
>>>>>> On Tue, May 3, 2011 at 8:30 PM, keechak wrote:
>>>>>>
>>>>>>> Hi forum,
>>>>>>>
>>>>>>> Thanks very much for creating such a wonderful forum.
>>>>>>>
>>>>>>> I had a problem in calculating the due dates for different customers.
>>>>>>>
>>>>>>> Col A contains suppliers with the dates they supply the raw material
>>>>>>> & amount of the material supplied in the next columns B & C 
>>>>>>> Respectively.
>>>>>>>
>>>>>>> I need a formula or a vba routine which can calculate the due dates
>>>>>>> for all the suppliers who supply the material.
>>>>>>>
>>>>>>> There are certain cut-off dates for each supplier in calculating the
>>>>>>> due dates in the billing cycle table.
>>>>>>>
>>>>>>> I want to print the months in Column D basing upon the supply date
>>>>>>> for each supplier and the cut-off dates in the right side table(Billing
>>>>>>> Cycle -table).
>>>>>>>
>>>>>>> Please help me
>>>>>>>
>>>>>>>  WebRep
>>>>>>> Overall rating
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>>
>>>>>>> --
>>>>>>> Some important links for excel users:
>>>>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>>>>> http://twitter.com/exceldailytip
>>>>>>> 2. Join our LinkedIN group @
>>>>>>> http://www.linkedin.com/groups?gid=1871310
>>>>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>>>>>
>>>>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>>>>
>>>>>>> <><><><><><><><><><><><><><><><><><><><><><&

Re: $$Excel-Macros$$ Calculate Due dates

[Mr excel]

Got it ashish bhayya..thanks a lot.played with the formula and got the
desired result..
Thanks a lot.

On Wed, May 11, 2011 at 8:37 PM, Mr excel  wrote:

> what i meant is instead of the period,the formula is showing as a result
> the formula should return only the month with the year.
> For example,*05-Apr-2011   TO  04-May-2011*.
> should return apr'2011.
>
> hope this is not confusing you...ashish...
>
>
> On Sat, May 7, 2011 at 1:25 PM, ashish koul  wrote:
>
>>
>> change
>> "dd-mmm-" to
>>
>> "dd-mmm'" in formula
>>
>>
>> On Sat, May 7, 2011 at 7:47 AM, Mr excel  wrote:
>>
>>> dear ashish,,
>>>
>>>That is excellent & great.Thanks a lot .The formula u provided is
>>> very nearer to the solution i wanted.everthing is same except in the month
>>> column of the sheet.Name of the month should be printed like April'2011
>>> instead of *05-Apr-2011   TO  04-May-2011*.
>>>
>>> the above formula also is very helpful to me in another scenario..
>>>
>>> Really my joy knew no boundaries..
>>>
>>>
>>> On Fri, May 6, 2011 at 6:46 AM, ashish koul wrote:
>>>
>>>> try  this one
>>>>
>>>> On Thu, May 5, 2011 at 9:11 PM, ashish koul wrote:
>>>>
>>>>> see if it helps
>>>>>
>>>>>
>>>>> On Thu, May 5, 2011 at 7:23 AM, Mr excel wrote:
>>>>>
>>>>>> For example,
>>>>>> The billing cycle for supplier A is 5th of this month to 4th next
>>>>>> so all the transactions pertaining to Supplier "A" will be billed in
>>>>>> this period.
>>>>>> Here in this example, there is only one transaction related to "A" and
>>>>>> the billing is done for the month of jan'2011 so in the month column
>>>>>> Jan'2011 should be displayed as this single transaction is done
>>>>>> between 5th of Jan'2011-4th Feb'2011
>>>>>> Likewise for all the other suppliers…
>>>>>> Hope I had made it clear.
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Wed, May 4, 2011 at 9:57 PM, ashish koul wrote:
>>>>>>
>>>>>>> can you expaln with some example in workbook
>>>>>>>
>>>>>>>
>>>>>>> On Tue, May 3, 2011 at 8:30 PM, keechak wrote:
>>>>>>>
>>>>>>>> Hi forum,
>>>>>>>>
>>>>>>>> Thanks very much for creating such a wonderful forum.
>>>>>>>>
>>>>>>>> I had a problem in calculating the due dates for different
>>>>>>>> customers.
>>>>>>>>
>>>>>>>> Col A contains suppliers with the dates they supply the raw material
>>>>>>>> & amount of the material supplied in the next columns B & C 
>>>>>>>> Respectively.
>>>>>>>>
>>>>>>>> I need a formula or a vba routine which can calculate the due dates
>>>>>>>> for all the suppliers who supply the material.
>>>>>>>>
>>>>>>>> There are certain cut-off dates for each supplier in calculating the
>>>>>>>> due dates in the billing cycle table.
>>>>>>>>
>>>>>>>> I want to print the months in Column D basing upon the supply date
>>>>>>>> for each supplier and the cut-off dates in the right side table(Billing
>>>>>>>> Cycle -table).
>>>>>>>>
>>>>>>>> Please help me
>>>>>>>>
>>>>>>>>  WebRep
>>>>>>>> Overall rating
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>>
>>>>>>>> --
>>>>>>>> Some important links for excel users:
>>>>>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>>>>>> http://twitter.com/exceldailytip
>>>>>>>> 2. Join our LinkedIN group @
>>>>>>>> http://www.linkedin.com/groups?gid=1871310
>>>>>>>> 3. Excel tutorials

Re: $$Excel-Macros$$ Calculate Due dates

[Mr excel]

Thanks ashish bhayya for that great formula.Upon drilling deep into the
formula & the result,i feel we are into the logical error.To make it clear,
for Supplier A, if the transaction date is *12/05/2001*.the formula should
return the previous month just like, *05-Apr'2011   TO  04-May'2011.Kindly
update the formula.
Thanks in advance.
*
On Thu, May 12, 2011 at 9:41 AM, Anil Bhange <
anil.bha...@tatacommunications.com> wrote:

> I think Ashish is right use this,
>
>
>
> Still try with this
>
>
>
> “mmm'”
>
>
>
>
>
> Regards,Anil Bhange
>
> IP Phone - 512320 | Mobile - 90290 32123
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Mr excel
> *Sent:* Wednesday, May 11, 2011 8:37 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Calculate Due dates
>
>
>
> what i meant is instead of the period,the formula is showing as a result
> the formula should return only the month with the year.
> For example,*05-Apr-2011   TO  04-May-2011*.
> should return apr'2011.
>
> hope this is not confusing you...ashish...
>
> On Sat, May 7, 2011 at 1:25 PM, ashish koul  wrote:
>
>
> change
> "dd-mmm-" to
>
> "dd-mmm'" in formula
>
>
>
> On Sat, May 7, 2011 at 7:47 AM, Mr excel  wrote:
>
> dear ashish,,
>
>That is excellent & great.Thanks a lot .The formula u provided is
> very nearer to the solution i wanted.everthing is same except in the month
> column of the sheet.Name of the month should be printed like April'2011
> instead of *05-Apr-2011   TO  04-May-2011*.
>
> the above formula also is very helpful to me in another scenario..
>
> Really my joy knew no boundaries..
>
>
>
> On Fri, May 6, 2011 at 6:46 AM, ashish koul  wrote:
>
> try  this one
>
>
>
> On Thu, May 5, 2011 at 9:11 PM, ashish koul  wrote:
>
> see if it helps
>
>
>
> On Thu, May 5, 2011 at 7:23 AM, Mr excel  wrote:
>
> For example,
> The billing cycle for supplier A is 5th of this month to 4th next
> so all the transactions pertaining to Supplier "A" will be billed in this
> period.
> Here in this example, there is only one transaction related to "A" and the
> billing is done for the month of jan'2011 so in the month column
> Jan'2011 should be displayed as this single transaction is done between 5th
> of Jan'2011-4th Feb'2011
> Likewise for all the other suppliers…
> Hope I had made it clear.
>
>
>
> On Wed, May 4, 2011 at 9:57 PM, ashish koul  wrote:
>
> can you expaln with some example in workbook
>
>
>
> On Tue, May 3, 2011 at 8:30 PM, keechak  wrote:
>
> Hi forum,
>
> Thanks very much for creating such a wonderful forum.
>
> I had a problem in calculating the due dates for different customers.
>
> Col A contains suppliers with the dates they supply the raw material &
> amount of the material supplied in the next columns B & C Respectively.
>
> I need a formula or a vba routine which can calculate the due dates for all
> the suppliers who supply the material.
>
> There are certain cut-off dates for each supplier in calculating the due
> dates in the billing cycle table.
>
> I want to print the months in Column D basing upon the supply date for each
> supplier and the cut-off dates in the right side table(Billing Cycle
> -table).
>
> Please help me
>
> WebRep
>
> Overall rating
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
> --
>
> *Regards*
>
> * *
>
> *Ashish Koul*
>
> *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
>
> *akoul*.wordpress.com <http://akoul.wordpress.com/>
>
> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>
>
>
> P Before printing, think a

Re: $$Excel-Macros$$ Calculate Due dates

[Mr excel]

It is the same worksheet bhayya which i had attched previously.Just need to
change the formula or add a routine for my requirement.
Thanks in advance.

On Sun, May 15, 2011 at 9:43 AM, ashish koul  wrote:

> can you attach the sample sheet
>
> On Sat, May 14, 2011 at 6:20 PM, Mr excel  wrote:
>
>> Thanks ashish bhayya for that great formula.Upon drilling deep into the
>> formula & the result,i feel we are into the logical error.To make it clear,
>> for Supplier A, if the transaction date is *12/05/2001*.the formula
>> should return the previous month just like, *05-Apr'2011   TO
>> 04-May'2011.Kindly update the formula.
>> Thanks in advance.
>> *
>> On Thu, May 12, 2011 at 9:41 AM, Anil Bhange <
>> anil.bha...@tatacommunications.com> wrote:
>>
>>> I think Ashish is right use this,
>>>
>>>
>>>
>>> Still try with this
>>>
>>>
>>>
>>> “mmm'”
>>>
>>>
>>>
>>>
>>>
>>> Regards,Anil Bhange
>>>
>>> IP Phone - 512320 | Mobile - 90290 32123
>>>
>>>
>>>
>>> *From:* excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com] *On Behalf Of *Mr excel
>>> *Sent:* Wednesday, May 11, 2011 8:37 PM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* Re: $$Excel-Macros$$ Calculate Due dates
>>>
>>>
>>>
>>> what i meant is instead of the period,the formula is showing as a result
>>> the formula should return only the month with the year.
>>> For example,*05-Apr-2011   TO  04-May-2011*.
>>> should return apr'2011.
>>>
>>> hope this is not confusing you...ashish...
>>>
>>> On Sat, May 7, 2011 at 1:25 PM, ashish koul 
>>> wrote:
>>>
>>>
>>> change
>>> "dd-mmm-" to
>>>
>>> "dd-mmm'" in formula
>>>
>>>
>>>
>>> On Sat, May 7, 2011 at 7:47 AM, Mr excel  wrote:
>>>
>>> dear ashish,,
>>>
>>>That is excellent & great.Thanks a lot .The formula u provided is
>>> very nearer to the solution i wanted.everthing is same except in the month
>>> column of the sheet.Name of the month should be printed like April'2011
>>> instead of *05-Apr-2011   TO  04-May-2011*.
>>>
>>> the above formula also is very helpful to me in another scenario..
>>>
>>> Really my joy knew no boundaries..
>>>
>>>
>>>
>>> On Fri, May 6, 2011 at 6:46 AM, ashish koul 
>>> wrote:
>>>
>>> try  this one
>>>
>>>
>>>
>>> On Thu, May 5, 2011 at 9:11 PM, ashish koul 
>>> wrote:
>>>
>>> see if it helps
>>>
>>>
>>>
>>> On Thu, May 5, 2011 at 7:23 AM, Mr excel  wrote:
>>>
>>> For example,
>>> The billing cycle for supplier A is 5th of this month to 4th next
>>> so all the transactions pertaining to Supplier "A" will be billed in this
>>> period.
>>> Here in this example, there is only one transaction related to "A" and
>>> the billing is done for the month of jan'2011 so in the month column
>>> Jan'2011 should be displayed as this single transaction is done between
>>> 5th of Jan'2011-4th Feb'2011
>>> Likewise for all the other suppliers…
>>> Hope I had made it clear.
>>>
>>>
>>>
>>> On Wed, May 4, 2011 at 9:57 PM, ashish koul 
>>> wrote:
>>>
>>> can you expaln with some example in workbook
>>>
>>>
>>>
>>> On Tue, May 3, 2011 at 8:30 PM, keechak  wrote:
>>>
>>> Hi forum,
>>>
>>> Thanks very much for creating such a wonderful forum.
>>>
>>> I had a problem in calculating the due dates for different customers.
>>>
>>> Col A contains suppliers with the dates they supply the raw material &
>>> amount of the material supplied in the next columns B & C Respectively.
>>>
>>> I need a formula or a vba routine which can calculate the due dates for
>>> all the suppliers who supply the material.
>>>
>>> There are certain cut-off dates for each supplier in calculating the due
>>> dates in the billing cycle table.
>>>
>>> I want to print the months in Column D basing upon the supply date for
>

$$Excel-Macros$$ How to learn VSTO with excel.

[Mr excel]

hi all,

  I want to learn VSTO for excel.anybody please give me the notes,pdf or
urls for learning.

thanks & regards...

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Create worksheet from list

[Mr excel]

Mr.guillet..thanks for that great macro.i had a situation same like the
above. A little change is that u had given example for a worksheet with
data.
i want to update all the worksheets as and when i enter new data into the
main sheet.i think it can be done using the On_enter worksheet event.can u
give me the same for my requirement.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Create worksheet from list

[Mr excel]

*Macro 1:*

Option Explicit

Sub ExtractReps()
Dim ws1 As Worksheet
Dim wsNew As Worksheet
Dim rng As Range
Dim r As Integer
Dim c As Range
Set ws1 = Sheets("Sheet1")
Set rng = Range("Database")

'extract a list of Sales Reps
ws1.Columns("C:C").AdvancedFilter _
  Action:=xlFilterCopy, _
  CopyToRange:=Range("J1"), Unique:=True
r = Cells(Rows.Count, "J").End(xlUp).Row

'set up Criteria Area
Range("L1").Value = Range("C1").Value

For Each c In Range("J2:J" & r)
  'add the rep name to the criteria area
  ws1.Range("L2").Value = c.Value
  'add new sheet and run advanced filter
  Set wsNew = Sheets.Add
  wsNew.Move After:=Worksheets(Worksheets.Count)
  wsNew.Name = c.Value
  rng.AdvancedFilter Action:=xlFilterCopy, _
  CriteriaRange:=Sheets("Sheet1").Range("L1:L2"), _
  CopyToRange:=wsNew.Range("A1"), _
  Unique:=False
Next
ws1.Select
ws1.Columns("J:L").Delete
End Sub

*Macro 2:*
Option Explicit
Sub MakeRepSheetsSAS()
Dim c As Range
Dim lr As Long
Dim slr As Long

Application.ScreenUpdating = False
With Sheets("sheet1")
.Columns("C:C").AdvancedFilter Action:=xlFilterCopy, _
  CopyToRange:=Range("J1"), Unique:=True

lr = .Cells(Rows.Count, 1).End(xlUp).Row
slr = .Cells(Rows.Count, "j").End(xlUp).Row

For Each c In Range("j2:j" & slr)
.Range("A1:G1").AutoFilter
Sheets.Add After:=Sheets(Sheets.Count)
.Range("A1:G" & lr).AutoFilter Field:=3, Criteria1:=c
.Columns("a:g").Copy Range("a1")
 ActiveSheet.Name = c
'.Range("A1:G" & lr).AutoFilter
Next c
.Range("A1:G" & lr).AutoFilter
End With
End Sub

These are the macros in the example quoted earlier in this post.My Request
is that, how would i modify the macro to suit my needs

My requirements:
1.On entering the data in the main sheet.(sheet1) here.Worksheets to be
generated basing on the new reps added.
2.after the new data is added to the sheet, Rows should be updated on entry
to the respective sheets based on reps.

Everything is same but only the macro is run with the data in the main sheet
in the actual scenario.but whereas,in my requirement i need the data to be
updated immediately on entry in the main sheet.

Hope i had explained it better..Thanks in advance for sparing time...

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Help Needed.

[Mr excel]

HI group,

 This is a Great & amazing group in learning excel vba..


*Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)*

*Dim st As String*

*Dim sh As Worksheet*

*Set sh = Sheets("Sheet2")*

*st = Target.Address*

*sh.Activate*

*sh.Range(st).Activate*

*ActiveCell.Value = sh.Name & st*
*End Sub*

I had a doubt regarding the above code.
I had taken a sample code from one of  posts.What exactly does the code in
Brackets mean, and when will this type of code in brackets used.Can any body
explain me in detail with some easily understandable examples..I m a
beginner in excel vba...
Thanks in advance...

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Help Needed.

[Mr excel]

Thanks rajan babu, for that link.Can anybody quote some more examples in
detail.I just got a little understanding of the function with arguments.But
to enhance my knowledge i would like to study more examples...Pls provide me
with any other examples.

On Sat, Oct 1, 2011 at 12:18 PM, rajan verma wrote:

>
> Please VIsit this Page..
> http://www.cpearson.com/excel/Events.aspx
>
> On Sat, Oct 1, 2011 at 12:09 PM, XLS S  wrote:
>
>> Hey Rajan Babu,
>>
>> which page?
>>
>>
>>
>>
>>
>> On Sat, Oct 1, 2011 at 11:52 AM, rajan verma wrote:
>>
>>>  HI,
>>> Please visit this Page to know more about Worksheet Events..
>>>
>>> Regards
>>> Rajan
>>>
>>>   On Sat, Oct 1, 2011 at 10:53 AM, Mr excel wrote:
>>>
>>>> HI group,
>>>>
>>>>  This is a Great & amazing group in learning excel vba..
>>>>
>>>>
>>>> *Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
>>>> As Boolean)*
>>>>
>>>> *Dim st As String*
>>>>
>>>> *Dim sh As Worksheet*
>>>>
>>>> *Set sh = Sheets("Sheet2")*
>>>>
>>>> *st = Target.Address*
>>>>
>>>> *sh.Activate*
>>>>
>>>> *sh.Range(st).Activate*
>>>>
>>>> *ActiveCell.Value = sh.Name & st*
>>>> *End Sub*
>>>>
>>>> I had a doubt regarding the above code.
>>>> I had taken a sample code from one of  posts.What exactly does the code
>>>> in Brackets mean, and when will this type of code in brackets used.Can any
>>>> body explain me in detail with some easily understandable examples..I m a
>>>> beginner in excel vba...
>>>> Thanks in advance...
>>>>
>>>> --
>>>>
>>>> --
>>>> Some important links for excel users:
>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>> http://twitter.com/exceldailytip
>>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>>
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>> Like our page on facebook , Just follow below link
>>>> http://www.facebook.com/discussexcel
>>>>
>>>
>>>
>>>
>>> --
>>> Regards
>>> Rajan verma
>>> +91 9158998701
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> .
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <&g

$$Excel-Macros$$ Update sheets on Enter

[Mr excel]

Hi group,

   I had been struggling with a solution for a problem from many
days..
Recently i had seen a macro in this group which is very much nearer to my
problem.The sample data is taken from one of the previous examples given by
guillet.

Going by the same sample data :
the main sheet contains the following columns with data underneath it.
*Date* *Region* *Rep* *Item* *Units* *Cost* *Total* *
*
I want sheets to be added & updated based on each Region and with the date
in the chronological order.
If a sheet exists already with the REGION NAME there is no need to add the
sheet with the same name instead new data should be added from the main
sheet to the respective sheets (REGION wise)

I had attached the worksheet for reference.Kindly help me

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


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

Re: $$Excel-Macros$$ vba for loops -beginner

[Mr excel]

Thanks.very useful for beginners like me

On Mon, Jul 25, 2011 at 11:35 PM, XLS S  wrote:

> please find the attachment for basic loop concept
>
> On Mon, Jul 25, 2011 at 5:50 PM, vijayajith VA wrote:
>
>> Hi rajan
>>
>> Can you explain
>> below code
>>  st = st & vbTab & Arr(Rw, Cl)
>> Next
>> st = st & vbCrLf
>> Next
>>
>> St means ?
>>
>>
>>
>>
>> On Sun, Jul 24, 2011 at 1:08 PM, Rajan_Verma wrote:
>>
>>> See if it Helps
>>>
>>> Option Base 1
>>> Sub StoreInArrya()
>>>Dim Arr() As Variant
>>>Dim rng As Range
>>>Dim Rw As Integer
>>>Dim Cl As Integer
>>>
>>>Set rng = Range("A1:C5")
>>>ReDim Arr(rng.Cells.Rows.Count, rng.Cells.Columns.Count)
>>>
>>>For Rw = 1 To rng.Rows.Count
>>>For Cl = 1 To rng.Columns.Count
>>>Arr(Rw, Cl) = rng.Cells(Rw, Cl).Value
>>>Next
>>>Next
>>>
>>>   For Rw = 1 To rng.Rows.Count
>>>For Cl = 1 To rng.Columns.Count
>>>st = st & vbTab & Arr(Rw, Cl)
>>>Next
>>>st = st & vbCrLf
>>>Next
>>>   MsgBox st
>>> End Sub
>>>
>>> -Original Message-
>>> From: excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com]
>>> On Behalf Of netuser501
>>> Sent: Sunday, July 24, 2011 6:42 AM
>>> To: MS EXCEL AND VBA MACROS
>>> Subject: $$Excel-Macros$$ vba for loops -beginner
>>>
>>> Hi
>>>
>>> The question worksheets is filled with data on 5 rows and 3 columns.
>>> I'd like to have this data stored in an Array. For testing purpose, I
>>> want to test if the loop is "reading" the data with an integer "tmp"
>>> that should return the number of cells filled in with data.
>>>
>>>  Set wkb = ThisWorkbook
>>>  Set wks = wkb.Worksheets("questions")
>>>
>>>
>>>  For i = 0 To wks.Cells(i + 1, 1 = ""
>>>For j = 0 To wks.Cells(i + 1, j + 1) = ""
>>>  tmp = tmp + 1
>>>Next j
>>>  Next i
>>>
>>> Why aren't Loop j and i looping?
>>>
>>>
>>>
>>> Another question :
>>>
>>> Is this possible to redim an array in a 2d for loop :
>>>
>>> dim SomeArray() as variant
>>> redim SomeArray(0,0) 'A
>>>
>>> for i = 0 to MAXL
>>> for j = 0 to MAXC
>>> SomeArray(i,j) = cells(i+1,j+1)
>>> redim preserve SomeArray(i,j+1)
>>> next j
>>> redim preserve SomeArray(i+1,j) 'j has still MAXC as value
>>> next i
>>>
>>> I understand it's not making sense since MAXL and MAXC could be
>>> declared in A.
>>>
>>> Back to the previous question it would make sense to redim a 2d array
>>> in a for loop until a cell is empty in the column and a cell is empty
>>> in the lines.
>>>
>>> Thanks for your precious help,
>>>
>>> --
>>>
>>> 
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>  --
>>
>> --
>>
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>  --
>
> ---

Re: $$Excel-Macros$$ Update sheets on Enter

[Mr excel]

huhh..My COmmunication is sucking day by day...sorry guillet.i could not
communicate to you properlyHope this time i could make it clear

>From the Worksheet *MAKESHEETS example  *given by you.You are
adding/creating sheets based on the REP cell...Here the macro starts only
when it is run manually.
Instead,i  want the same type of solution.I.e. adding/creating sheets when a
new row with new data is entered into the main sheet.

To elaborate more in detail,when a new row is entered after the 44th  row in
row 45.the macro needs to be run automatically adding new worksheet based on
the column REP.

If all the sheets are added to the workbook previously the REP in the new
row should be added to the existing worksheet which was added before the
present row.The new row should be added to the worksheet underneath the
previous row.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Update sheets on Enter

[Mr excel]

any help from anybody please?

On Tue, Oct 4, 2011 at 6:29 PM, dguillett1  wrote:

>   I, or some of the others can amend my code to do as desired. However,
> again, I suggest you try this where you simply use filters on ONE sheet.
>
>  *From:* Mr excel 
> *Sent:* Monday, October 03, 2011 11:56 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Update sheets on Enter
>
> huhh..My COmmunication is sucking day by day...sorry guillet.i could
> not communicate to you properlyHope this time i could make it clear
>
> From the Worksheet *MAKESHEETS example  *given by you.You are
> adding/creating sheets based on the REP cell...Here the macro starts only
> when it is run manually.
> Instead,i  want the same type of solution.I.e. adding/creating sheets when
> a new row with new data is entered into the main sheet.
>
> To elaborate more in detail,when a new row is entered after the 44th  row
> in row 45.the macro needs to be run automatically adding new worksheet based
> on the column REP.
>
> If all the sheets are added to the workbook previously the REP in the new
> row should be added to the existing worksheet which was added before the
> present row.The new row should be added to the worksheet underneath the
> previous row.
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Update sheets on Enter

[Mr excel]

I m interested in learning macros don.only reason i m asking repeatedly is
this situation will be very helpful for me in my work.i just want the
workbook to update sheets as and when a new row is updated in the main
worksheet.

I need to see the whole details when demanded in my work.the example you had
provided is exactly the same i required.only change needed is that when a
new row is added it should go to the exact worksheet(REP based).

Oh my God now i understood why you people are offering me different
solutions when i m explaining it in clarity.I had used the pivot table in
the main sheet just to check whether all the rows updated are exactly the
same.(counting no of rows).thats it.

i had studied a little bit on searching in this forum.and learnt that i need
to use the
Worksheet Change Event.is it exactly the same don which i need to use

Any ways,thanks for all the help given by you all...Especially DON..


On Tue, Oct 4, 2011 at 11:09 PM, Sam Mathai Chacko wrote:

> For the sake of an alternative, here's one using Pivots, though I would go
> with Don.
>
> Regards,
> Sam
>
>
> On Tue, Oct 4, 2011 at 8:07 PM, dguillett1  wrote:
>
>>   What is the reason that you do not like my idea of filtering?
>>
>>  *From:* Mr excel 
>> *Sent:* Tuesday, October 04, 2011 8:42 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Update sheets on Enter
>>
>> any help from anybody please?
>>
>> On Tue, Oct 4, 2011 at 6:29 PM, dguillett1  wrote:
>>
>>>   I, or some of the others can amend my code to do as desired. However,
>>> again, I suggest you try this where you simply use filters on ONE sheet.
>>>
>>>  *From:* Mr excel 
>>> *Sent:* Monday, October 03, 2011 11:56 PM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* Re: $$Excel-Macros$$ Update sheets on Enter
>>>
>>>   huhh..My COmmunication is sucking day by day...sorry guillet.i
>>> could not communicate to you properlyHope this time i could make it
>>> clear
>>>
>>> From the Worksheet *MAKESHEETS example  *given by you.You are
>>> adding/creating sheets based on the REP cell...Here the macro starts only
>>> when it is run manually.
>>> Instead,i  want the same type of solution.I.e. adding/creating sheets
>>> when a new row with new data is entered into the main sheet.
>>>
>>> To elaborate more in detail,when a new row is entered after the 44th  row
>>> in row 45.the macro needs to be run automatically adding new worksheet based
>>> on the column REP.
>>>
>>> If all the sheets are added to the workbook previously the REP in the new
>>> row should be added to the existing worksheet which was added before the
>>> present row.The new row should be added to the worksheet underneath the
>>> previous row.
>>>
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>  --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><&

Re: $$Excel-Macros$$ Update sheets on Enter

[Mr excel]

ADDITION: i just need the raw data to be exported to the respective sheets
based on REP column.No need of calculations of any kind.Hope i made it
clear...

On Wed, Oct 5, 2011 at 5:28 AM, Mr excel  wrote:

> I m interested in learning macros don.only reason i m asking repeatedly is
> this situation will be very helpful for me in my work.i just want the
> workbook to update sheets as and when a new row is updated in the main
> worksheet.
>
> I need to see the whole details when demanded in my work.the example you
> had provided is exactly the same i required.only change needed is that when
> a new row is added it should go to the exact worksheet(REP based).
>
> Oh my God now i understood why you people are offering me different
> solutions when i m explaining it in clarity.I had used the pivot table in
> the main sheet just to check whether all the rows updated are exactly the
> same.(counting no of rows).thats it.
>
> i had studied a little bit on searching in this forum.and learnt that i
> need to use the
> Worksheet Change Event.is it exactly the same don which i need to use
>
> Any ways,thanks for all the help given by you all...Especially DON..
>
>
>
> On Tue, Oct 4, 2011 at 11:09 PM, Sam Mathai Chacko wrote:
>
>> For the sake of an alternative, here's one using Pivots, though I would go
>> with Don.
>>
>> Regards,
>> Sam
>>
>>
>> On Tue, Oct 4, 2011 at 8:07 PM, dguillett1  wrote:
>>
>>>   What is the reason that you do not like my idea of filtering?
>>>
>>>  *From:* Mr excel 
>>> *Sent:* Tuesday, October 04, 2011 8:42 AM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* Re: $$Excel-Macros$$ Update sheets on Enter
>>>
>>> any help from anybody please?
>>>
>>> On Tue, Oct 4, 2011 at 6:29 PM, dguillett1  wrote:
>>>
>>>>   I, or some of the others can amend my code to do as desired. However,
>>>> again, I suggest you try this where you simply use filters on ONE sheet.
>>>>
>>>>  *From:* Mr excel 
>>>> *Sent:* Monday, October 03, 2011 11:56 PM
>>>> *To:* excel-macros@googlegroups.com
>>>> *Subject:* Re: $$Excel-Macros$$ Update sheets on Enter
>>>>
>>>>   huhh..My COmmunication is sucking day by day...sorry guillet.i
>>>> could not communicate to you properlyHope this time i could make it
>>>> clear
>>>>
>>>> From the Worksheet *MAKESHEETS example  *given by you.You are
>>>> adding/creating sheets based on the REP cell...Here the macro starts only
>>>> when it is run manually.
>>>> Instead,i  want the same type of solution.I.e. adding/creating sheets
>>>> when a new row with new data is entered into the main sheet.
>>>>
>>>> To elaborate more in detail,when a new row is entered after the 44th
>>>> row in row 45.the macro needs to be run automatically adding new worksheet
>>>> based on the column REP.
>>>>
>>>> If all the sheets are added to the workbook previously the REP in the
>>>> new row should be added to the existing worksheet which was added before 
>>>> the
>>>> present row.The new row should be added to the worksheet underneath the
>>>> previous row.
>>>>
>>>>
>>>> --
>>>>
>>>> --
>>>> Some important links for excel users:
>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>> http://twitter.com/exceldailytip
>>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>>
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>> Like our page on facebook , Just follow below link
>>>> http://www.facebook.com/discussexcel
>>>>  --
>>>>
>>>> --
>>>> Some important links for excel users:
>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>> http://twitter.com/e

Re: $$Excel-Macros$$ Update sheets on Enter

[Mr excel]

Any ideas please..:?

On Wed, Oct 5, 2011 at 5:30 AM, Mr excel  wrote:

> ADDITION: i just need the raw data to be exported to the respective sheets
> based on REP column.No need of calculations of any kind.Hope i made it
> clear...
>
>
> On Wed, Oct 5, 2011 at 5:28 AM, Mr excel  wrote:
>
>> I m interested in learning macros don.only reason i m asking repeatedly is
>> this situation will be very helpful for me in my work.i just want the
>> workbook to update sheets as and when a new row is updated in the main
>> worksheet.
>>
>> I need to see the whole details when demanded in my work.the example you
>> had provided is exactly the same i required.only change needed is that when
>> a new row is added it should go to the exact worksheet(REP based).
>>
>> Oh my God now i understood why you people are offering me different
>> solutions when i m explaining it in clarity.I had used the pivot table in
>> the main sheet just to check whether all the rows updated are exactly the
>> same.(counting no of rows).thats it.
>>
>> i had studied a little bit on searching in this forum.and learnt that i
>> need to use the
>> Worksheet Change Event.is it exactly the same don which i need to use
>>
>> Any ways,thanks for all the help given by you all...Especially DON..
>>
>>
>>
>> On Tue, Oct 4, 2011 at 11:09 PM, Sam Mathai Chacko wrote:
>>
>>> For the sake of an alternative, here's one using Pivots, though I would
>>> go with Don.
>>>
>>> Regards,
>>> Sam
>>>
>>>
>>> On Tue, Oct 4, 2011 at 8:07 PM, dguillett1  wrote:
>>>
>>>>   What is the reason that you do not like my idea of filtering?
>>>>
>>>>  *From:* Mr excel 
>>>> *Sent:* Tuesday, October 04, 2011 8:42 AM
>>>> *To:* excel-macros@googlegroups.com
>>>> *Subject:* Re: $$Excel-Macros$$ Update sheets on Enter
>>>>
>>>> any help from anybody please?
>>>>
>>>> On Tue, Oct 4, 2011 at 6:29 PM, dguillett1 wrote:
>>>>
>>>>>   I, or some of the others can amend my code to do as desired.
>>>>> However, again, I suggest you try this where you simply use filters on ONE
>>>>> sheet.
>>>>>
>>>>>  *From:* Mr excel 
>>>>> *Sent:* Monday, October 03, 2011 11:56 PM
>>>>> *To:* excel-macros@googlegroups.com
>>>>> *Subject:* Re: $$Excel-Macros$$ Update sheets on Enter
>>>>>
>>>>>   huhh..My COmmunication is sucking day by day...sorry guillet.i
>>>>> could not communicate to you properlyHope this time i could make it
>>>>> clear
>>>>>
>>>>> From the Worksheet *MAKESHEETS example  *given by you.You are
>>>>> adding/creating sheets based on the REP cell...Here the macro starts only
>>>>> when it is run manually.
>>>>> Instead,i  want the same type of solution.I.e. adding/creating sheets
>>>>> when a new row with new data is entered into the main sheet.
>>>>>
>>>>> To elaborate more in detail,when a new row is entered after the 44th
>>>>> row in row 45.the macro needs to be run automatically adding new worksheet
>>>>> based on the column REP.
>>>>>
>>>>> If all the sheets are added to the workbook previously the REP in the
>>>>> new row should be added to the existing worksheet which was added before 
>>>>> the
>>>>> present row.The new row should be added to the worksheet underneath the
>>>>> previous row.
>>>>>
>>>>>
>>>>> --
>>>>>
>>>>> --
>>>>> Some important links for excel users:
>>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>>> http://twitter.com/exceldailytip
>>>>> 2. Join our LinkedIN group @
>>>>> http://www.linkedin.com/groups?gid=1871310
>>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>>>
>>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>>
>>>>> <><><><><><><><><><><><><>

Re: $$Excel-Macros$$ Update sheets on Enter

[Mr excel]

Thanks sam first of all,for the kind reply.The code u posted is not the same
i m looking for.I had explained what i  m in need of...Kindly Read my last
two updates & help me..
thanks...

On Thu, Oct 6, 2011 at 8:57 AM, Sam Mathai Chacko wrote:

> Isn't that what the code I posted does?
>
> Sam
>
>
> On Thu, Oct 6, 2011 at 8:52 AM, Mr excel  wrote:
>
>> Any ideas please..:?
>>
>>
>> On Wed, Oct 5, 2011 at 5:30 AM, Mr excel  wrote:
>>
>>> ADDITION: i just need the raw data to be exported to the respective
>>> sheets based on REP column.No need of calculations of any kind.Hope i made
>>> it clear...
>>>
>>>
>>> On Wed, Oct 5, 2011 at 5:28 AM, Mr excel  wrote:
>>>
>>>> I m interested in learning macros don.only reason i m asking repeatedly
>>>> is this situation will be very helpful for me in my work.i just want the
>>>> workbook to update sheets as and when a new row is updated in the main
>>>> worksheet.
>>>>
>>>> I need to see the whole details when demanded in my work.the example you
>>>> had provided is exactly the same i required.only change needed is that when
>>>> a new row is added it should go to the exact worksheet(REP based).
>>>>
>>>> Oh my God now i understood why you people are offering me different
>>>> solutions when i m explaining it in clarity.I had used the pivot table in
>>>> the main sheet just to check whether all the rows updated are exactly the
>>>> same.(counting no of rows).thats it.
>>>>
>>>> i had studied a little bit on searching in this forum.and learnt that i
>>>> need to use the
>>>> Worksheet Change Event.is it exactly the same don which i need to
>>>> use
>>>>
>>>> Any ways,thanks for all the help given by you all...Especially DON..
>>>>
>>>>
>>>>
>>>> On Tue, Oct 4, 2011 at 11:09 PM, Sam Mathai Chacko 
>>>> wrote:
>>>>
>>>>> For the sake of an alternative, here's one using Pivots, though I would
>>>>> go with Don.
>>>>>
>>>>> Regards,
>>>>> Sam
>>>>>
>>>>>
>>>>> On Tue, Oct 4, 2011 at 8:07 PM, dguillett1 wrote:
>>>>>
>>>>>>   What is the reason that you do not like my idea of filtering?
>>>>>>
>>>>>>  *From:* Mr excel 
>>>>>> *Sent:* Tuesday, October 04, 2011 8:42 AM
>>>>>> *To:* excel-macros@googlegroups.com
>>>>>> *Subject:* Re: $$Excel-Macros$$ Update sheets on Enter
>>>>>>
>>>>>> any help from anybody please?
>>>>>>
>>>>>> On Tue, Oct 4, 2011 at 6:29 PM, dguillett1 wrote:
>>>>>>
>>>>>>>   I, or some of the others can amend my code to do as desired.
>>>>>>> However, again, I suggest you try this where you simply use filters on 
>>>>>>> ONE
>>>>>>> sheet.
>>>>>>>
>>>>>>>  *From:* Mr excel 
>>>>>>> *Sent:* Monday, October 03, 2011 11:56 PM
>>>>>>> *To:* excel-macros@googlegroups.com
>>>>>>> *Subject:* Re: $$Excel-Macros$$ Update sheets on Enter
>>>>>>>
>>>>>>>   huhh..My COmmunication is sucking day by day...sorry guillet.i
>>>>>>> could not communicate to you properlyHope this time i could make it
>>>>>>> clear
>>>>>>>
>>>>>>> From the Worksheet *MAKESHEETS example  *given by you.You are
>>>>>>> adding/creating sheets based on the REP cell...Here the macro starts 
>>>>>>> only
>>>>>>> when it is run manually.
>>>>>>> Instead,i  want the same type of solution.I.e. adding/creating sheets
>>>>>>> when a new row with new data is entered into the main sheet.
>>>>>>>
>>>>>>> To elaborate more in detail,when a new row is entered after the 44th
>>>>>>> row in row 45.the macro needs to be run automatically adding new 
>>>>>>> worksheet
>>>>>>> based on the column REP.
>>>>>>>
>>>>>>> If all the sheets are added to the workbook previously the REP in the
>>>>>>> new row should be added to the existing worksheet which was

$$Excel-Macros$$ How to learn vba

[Mr excel]

Hi group,

   i would like to know a specific method for learning Excel vba.I mean i m
just getting perplexed & worried about how to learn excel vba on seeing this
so many examples in this forum.I could not get a right point where to start
in vba.

Kindly suggest some tips or methods so that i can follow in learning excel
vba.

Thanks in advance.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ How to learn vba

[Mr excel]

Thanks all,for the replies.i had been working with the VBA macro
recorder.Its really very funny & intersting to learn like this.But there are
some situation where i need to learn the programming techniques like Do
Loops,While Loops etc which cannot be learnt from macro recording.Please
suggest me some ideas or techniques for learning...Thanks in advance to all
those who had helped me...

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ How to learn vba

[Mr excel]

thanks setiyowati.for that link.Pls do update this mail when ever anybody
comes across new linksThanks in advance.

On Fri, Oct 21, 2011 at 4:36 AM, STDEV(i)  wrote:

> Dear Mr excel,
>
> You are welcome to visit your brother here
> http://www.mrexcel.com/articles.shtml#VBA
>
> best regards
> ~siti
> your fans from indonesia
>
>
>
>
> On Thu, Oct 20, 2011 at 8:21 AM, Mr excel  wrote:
>
>> Thanks all,for the replies.i had been working with the VBA macro
>> recorder.Its really very funny & intersting to learn like this.But there are
>> some situation where i need to learn the programming techniques like Do
>> Loops,While Loops etc which cannot be learnt from macro recording.Please
>> suggest me some ideas or techniques for learning...Thanks in advance to all
>> those who had helped me...
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ How to learn vba

[Mr excel]

Hi all and a ton thanks for updating this mail frequently.I had been
struggling with the Do Loops from many days.i m following whatever the links
had been given re reading & studying the examples.I feel a little bit
confident with the loops now.thanks for the great support and i request you
all to pls keep this mail live by posting more & more examples.

Thanking you.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Download Word Macro Tutorial

[Mr excel]

Pankaj the link is working fine & i had downloaded the pdf.Just check it
again.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Right approach to learn macro coding

[Mr excel]

Ansari,your ppt is excellent.Nice tutorial for the beginners like me.Can You
create more PPTS with some advanced VBA...Awaiting your reply.

On Mon, Oct 24, 2011 at 1:20 PM, NOORAIN ANSARI wrote:

> Dear Navdeep,
>
> Please find Excel VBA Basic PPT.
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
> On Sun, Oct 23, 2011 at 12:10 PM, deep  wrote:
>
>> Hi frnzz.. i m new to this group so jst wnt to ask u people wat should
>> be d ryt approach to start wid macrosryt nw i m going thru some of
>> the Pdf files i have downloaded from the net. If anybody cn share any
>> material i wud realy appreciate dat...or else if anybdy cn let me any
>> institute or something whr i cn learn macros
>>
>> Thanks
>> Navdeep
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Re: Subtotals

[Mr excel]

Very helpful thanks a  lot..
On Mon, Dec 5, 2011 at 9:47 PM, Sam Mathai Chacko wrote:

> Thanks a lot Noorain
>
> Cheers
> Sam
>
>
> On Mon, Dec 5, 2011 at 9:36 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear SAM,
>>
>> Please find attached sheet...
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>>  *http://excelmacroworld.blogspot.com/*
>> *http://noorain-ansari.blogspot.com/*
>> On Sun, Dec 4, 2011 at 7:45 PM, Sam Mathai Chacko wrote:
>>
>>> Dear All,
>>>
>>> Hope you all are doing good.
>>>
>>> Requesting a favor. Does anyone of you have some study material on
>>> Solver, Goal Seek and Subtotals? I already have some from the net, but in
>>> case you have something customized, with examples, would be great.
>>>
>>> Regards,
>>> Sam Mathai Chacko
>>>
>>
>>
>> ** 
>>
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Sam Mathai Chacko
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Code for deleting files in a folder.

[Mr excel]

hi all,

  i would like to know the code for deleting all the files in a folder on a
desired day or say a particular date using vba or any script for that
matter.Can i achieve the same using DOS commands or any software is
required to do.
Kindly help.
Regards
excelkeechak.

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Dairy 2012

[Mr excel]

Very useful one.thanks a lot for sharing.

On Wed, Jan 18, 2012 at 7:52 PM, Rajan_Verma wrote:

> Good one.. simple
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *muralidhar e
> *Sent:* Jan/Mon/2012 02:22
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Dairy 2012
>
> ** **
>
>
> Hi,
>
>  
>
> Dear all wish u happy sankranti(Pongal) and a digital dairy gift for all.*
> ***
>
>
> -- 
>
> *Thanks & Regards,*
>
>  
>
> *Muralidhar E.*
>
> ** **
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Code for deleting files in a folder.

[Mr excel]

thanks a lot guillet for your support.i would further like to know whether
this code works simply by installing it in the code window of an excel
sheet and triggers itself on that particular date (checking the date with
the system date). Tell me how to get this code work with out any problems.
Thanks in advance.

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Code for deleting files in a folder.

[Mr excel]

thanks for the update guillett

On Thu, Jan 26, 2012 at 6:31 AM, dguillett1  wrote:

>   Just copy into a regular module. Change the date, folder, as I
> said.. It’s automatic based on the date.
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Mr excel 
> *Sent:* Wednesday, January 25, 2012 6:51 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Code for deleting files in a folder.
>
> thanks a lot guillet for your support.i would further like to know whether
> this code works simply by installing it in the code window of an excel
> sheet and triggers itself on that particular date (checking the date with
> the system date). Tell me how to get this code work with out any problems.
> Thanks in advance.
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Code for deleting files in a folder.

[Mr excel]

will this work automatically or should the excel sheet should be open for
the macro to run.

On Thu, Jan 26, 2012 at 8:32 AM, Mr excel  wrote:

> thanks for the update guillett
>
>
> On Thu, Jan 26, 2012 at 6:31 AM, dguillett1  wrote:
>
>>   Just copy into a regular module. Change the date, folder, as I
>> said.. It’s automatic based on the date.
>>
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* Mr excel 
>> *Sent:* Wednesday, January 25, 2012 6:51 PM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Code for deleting files in a folder.
>>
>> thanks a lot guillet for your support.i would further like to know
>> whether this code works simply by installing it in the code window of an
>> excel sheet and triggers itself on that particular date (checking the date
>> with the system date). Tell me how to get this code work with out any
>> problems.
>> Thanks in advance.
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Code for deleting files in a folder.

[Mr excel]

thanks noorain for the reply.but my requirement is to delete the files &
folders dynamically on the date in the code.any other way around.pls tell
me.

On Fri, Jan 27, 2012 at 5:40 PM, NOORAIN ANSARI wrote:

> Dear Mr. excel,
>
> It will work automatically when you run macro.
>
>
>
>
> On Fri, Jan 27, 2012 at 5:35 PM, Mr excel  wrote:
>
>> will this work automatically or should the excel sheet should be open for
>> the macro to run.
>>
>>
>> On Thu, Jan 26, 2012 at 8:32 AM, Mr excel  wrote:
>>
>>> thanks for the update guillett
>>>
>>>
>>> On Thu, Jan 26, 2012 at 6:31 AM, dguillett1 wrote:
>>>
>>>>   Just copy into a regular module. Change the date, folder, as I
>>>> said.. It’s automatic based on the date.
>>>>
>>>> Don Guillett
>>>> SalesAid Software
>>>> dguille...@gmail.com
>>>>
>>>>  *From:* Mr excel 
>>>> *Sent:* Wednesday, January 25, 2012 6:51 PM
>>>> *To:* excel-macros@googlegroups.com
>>>> *Subject:* Re: $$Excel-Macros$$ Code for deleting files in a folder.
>>>>
>>>> thanks a lot guillet for your support.i would further like to know
>>>> whether this code works simply by installing it in the code window of an
>>>> excel sheet and triggers itself on that particular date (checking the date
>>>> with the system date). Tell me how to get this code work with out any
>>>> problems.
>>>> Thanks in advance.
>>>> --
>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>>
>>>> 2) Don't post a question in the thread of another member.
>>>>
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>>
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>
>>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>>> signatures are prohibited.
>>>>
>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>> Forum owners and members are not responsible for any loss.
>>>>
>>>>
>>>> --
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>> --
>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>>
>>>> 2) Don't post a question in the thread of another member.
>>>>
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>>
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>
>>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>>> signatures are prohibited.
>>>>
>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>> Forum owners and members are not responsible for any loss.
>>>>
>>>>
>>>> --
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>
>>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data