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
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.
--
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, Ne
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
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 app
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
onsecutiveDelimiter:=False,
> Tab:=True, _
>
> Semicolon:=False, Comma:=False, Space:=False, Other:=True,
> OtherChar _
>
> :=":", FieldInfo:=Array(Array(1, 1), Array(2, 1)),
> TrailingMinusNumbers:=True
>
> .Parent.Activate**
: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, 2
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
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 Tota
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 workshee
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
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
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]***
>
> ^^ஜ۩۞۩ஜ▬▬▬ ▬^^
>
> * *
>
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
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.
>
>
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. Ch
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
>
> *
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.
Than
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@goo
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
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 Ansar
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
>
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
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
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
>
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 s
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
oes?
>
> 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
>>> she
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 exce
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
>
gt;
>> 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
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, Octo
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 r
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)
>>
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 c
, 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,
>&g
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*
*ActiveCe
*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, _
CopyToRan
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
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 :
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 exc
; 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:
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.
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
>> ve
e 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
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 colum
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
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
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> wrot
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.
>
>
>
*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 h
52 matches
Mail list logo
