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.
Thanks for the reply..Mr.Vijay...
On Mon, Jun 10, 2013 at 1:32 PM, P.VIJAYKUMAR vijay.4...@gmail.com 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
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,
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
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
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
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 excelkeec...@gmail.com wrote:
hi
:21 AM, Mr excel excelkeec...@gmail.com 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
*
*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
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
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
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
Nice good example dude...
On Tue, Mar 6, 2012 at 1:19 PM, Abhishek Jain abhishek@gmail.comwrote:
Anyone...?
On Thu, Mar 1, 2012 at 6:57 PM, Abhishek Jain abhishek@gmail.comwrote:
Hi friends,
For the sake of learning I just keep doing some thing or the other,
mostly in excel.
try using the vlookup function or DLOOKUP function on the form.
On Sat, Mar 3, 2012 at 11:15 AM, Deba Ranjan drdeva...@gmail.com wrote:
*
*
*Regards*
*Deba Ranjan P**
*
*[image: http://www.fileden.com/files/2008/8/21/2058970/greatday.gif]***
^^ஜ۩۞۩ஜ▬▬▬ ▬^^
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 excelkeec...@gmail.com wrote:
thanks for the update guillett
On Thu, Jan 26, 2012 at 6:31 AM, dguillett1 dguille...@gmail.com wrote:
Just copy
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 noorain.ans...@gmail.comwrote:
Dear Mr. excel,
It will work automatically when you run macro
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
Very useful one.thanks a lot for sharing.
On Wed, Jan 18, 2012 at 7:52 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
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:*
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 for the update guillett
On Thu, Jan 26, 2012 at 6:31 AM, dguillett1 dguille...@gmail.com 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
Very helpful thanks a lot..
On Mon, Dec 5, 2011 at 9:47 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Thanks a lot Noorain
Cheers
Sam
On Mon, Dec 5, 2011 at 9:36 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear SAM,
Please find attached sheet...
--
Thanks
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 noorain.ans...@gmail.comwrote:
Dear Navdeep,
Please find Excel VBA Basic PPT.
--
Thanks regards,
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) setiyowati.d...@gmail.com wrote:
Dear Mr excel,
You are welcome to visit your brother here
http://www.mrexcel.com/articles.shtml
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
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
Any ideas please..:?
On Wed, Oct 5, 2011 at 5:30 AM, Mr excel excelkeec...@gmail.com 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
does?
Sam
On Thu, Oct 6, 2011 at 8:52 AM, Mr excel excelkeec...@gmail.com wrote:
Any ideas please..:?
On Wed, Oct 5, 2011 at 5:30 AM, Mr excel excelkeec...@gmail.com wrote:
ADDITION: i just need the raw data to be exported to the respective
sheets based on REP column.No need
any help from anybody please?
On Tue, Oct 4, 2011 at 6:29 PM, dguillett1 dguille...@gmail.com 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 excelkeec...@gmail.com
:
What is the reason that you do not like my idea of filtering?
*From:* Mr excel excelkeec...@gmail.com
*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
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 excelkeec...@gmail.com wrote:
I m interested in learning macros don.only reason i m asking
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
Thanks.very useful for beginners like me
On Mon, Jul 25, 2011 at 11:35 PM, XLS S xlst...@gmail.com wrote:
please find the attachment for basic loop concept
On Mon, Jul 25, 2011 at 5:50 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi rajan
Can you explain
below code
st = st
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
visit this Page to know more about Worksheet Events..
Regards
Rajan
On Sat, Oct 1, 2011 at 10:53 AM, Mr excel excelkeec...@gmail.comwrote:
HI group,
This is a Great amazing group in learning excel vba..
*Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
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*
*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, _
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 :
| 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
@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
...@gmail.com wrote:
change
dd-mmm- to
dd-mmm' in formula
On Sat, May 7, 2011 at 7:47 AM, Mr excel excelkeec...@gmail.com 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
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 excelkeec...@gmail.com wrote:
what i meant is instead of the period,the formula is showing as a result
the formula should return only the month
:23 AM, Mr excel excelkeec...@gmail.com 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
Very useful for learning the basics.thanks for the links
On Mon, Jul 12, 2010 at 10:13 AM, Soni.Rajender soni.rajen...@gmail.comwrote:
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
Yeah Ayush had said is true.
On Sat, May 15, 2010 at 10:41 AM, Ayush jainayus...@gmail.com 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.
i had also found 2003 version shall i upload it to the forum.
On Fri, May 14, 2010 at 10:12 AM, Mr excel excelkeec...@gmail.com 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
*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
50 matches
Mail list logo