ANYBODY HAVE GST 2A MATCHING TOOL FOR GST, IF SO PLEASE SEND ME THE SAME.
IF NOT PLEASE TELL ME HOW COULD I MATCH 2 EXCEL SHEETS. THANKS IN ADVANCE
REGARDS
HARI NAIR
--
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
Sir,
I have an attached tamplete called advice, I want to make a data sheet each
time I save a work book from the advice. Please help Thanks in advance
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum
Access import from excel
Once u created one data table n data, if the same details are in other 4
worksheets also. Use import from excel say append to existing data.
Exact options changes from ur version's of office
On Jan 23, 2014 5:24 AM, "fahad hassan" wrote:
> Hey i want to ask a question re
I want to deduct continues percentages from one amount.(i.e. assume that
100 in a1 then I want 100-2%-3%-4%-1.5% from that amount, the result
should be (89.89) How can I enter formula)
Regards, thanks in advance
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME
Networkdays( stdate, end date,[holidays]
Thanks & Regards
Hari Kumar
"Our strength grows from our weakness."
On Jun 17, 2014 10:28 AM, "pankaj khairanar" wrote:
> Hi Expert,
>
> I want excel formula for below scenario.
>
> Date-9=result
>
> If re
Assuming data in cells a1 to e5
A6 cell value=
If(and(a2=a3,a2=a4,a2=a5),a2,"not same date"))
B5 cell value =
Sum (b2:b5)
C5 cell value=
C2&"/"c3&"/"&c4&"/"c5
Thanks & Regards
Hari Kumar
"Our strength grows from our weakness.
Hi ,
It would be better to give a try of importing and working in access or any
other databases for calculation and reporting.
Thanks & Regards
Hari Kumar
"Our strength grows from our weakness."
On May 19, 2014 3:28 AM, "Dima" wrote:
> Hello!
>
> I ha
Thanks for your help.
It will be much helpful other than in VBA code.
Thanks,
Harish
On 11 October 2013 17:51, Ravinder wrote:
> PFA, if u r looking for this.
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behal
ou can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> *-
>
>
> --
> *From:* Hari
> *To:* excel-macros@googlegroups.com
> *Sent:* Wed, January 9, 2013 6:57:56 AM
> *Subject:* $$Excel-Macros$$ Inde
-
>> *“Do all the good you can,
>> By all the means you can,
>> In all the ways you can,
>> In all the places you can,
>> At all the times you can,
>> To all the people you can,
>> As long as ever you can.” - John Wesley
>> *
Dear excel gurus,
Please let me know how to get the index of sheets in a given excel workbook.
Thanks,
Harish
--
Yours,
Hari.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles
Thanks for your help..
On 8 January 2013 12:56, jmothilal wrote:
> use ((amount* int/100)/365) * no of days
>
>
>
> On Tue, Jan 8, 2013 at 11:43 AM, Hari wrote:
>
>>
>>
>> -- Forwarded message --
>> From: Hari
>> Date: 8 Janua
-- Forwarded message --
From: Hari
Date: 8 January 2013 11:43
Subject: Fwd: Interest formulae
To: excel-macros@googlegroups.com
-- Forwarded message --
From: Hari
Date: 8 January 2013 11:42
Subject: Interest formulae
To: excel-macros@googlegroups.com
Dear
-- Forwarded message --
From: Hari
Date: 8 January 2013 11:42
Subject: Interest formulae
To: excel-macros@googlegroups.com
Dear excel experts,
PFA document of FD made with interest compuation made.
Provide me interest formulae in the attached sheet with the mathematical
Dear excel experts,
PFA document of FD made with interest compuation made.
Provide me interest formulae in the attached sheet with the mathematical
function or any macros.
Your help will be guide for us to save time.
--
Yours,
Hari.
--
Yours,
Hari.
--
Join official Facebook
Dear excel experts,
PFA document of FD made with interest compuation made.
Provide me interest formulae in the attached sheet with the mathematical
function or any macros.
Your help will be guide for us to save time.
--
Yours,
Hari.
--
Join official Facebook page of this forum @
https
Congratulations to both of you.
Keep smiling,
Regards,
Harish
On 2 July 2012 12:19, Hari wrote:
> Congratulations to both of you.
>
> Keep smiling,
>
> Regards,
> Harish
>
>
> On 2 July 2012 11:51, Kuldeep Singh wrote:
>
>>
>> Congratulations both
> 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.c
HI,
The following transactions to be imported into tally from excel in the
attached file. No ledgers are created in tally.
Regards,
Harish
On 2 June 2012 22:47, wrote:
> **
> Hi,
> What you want to import, provide with details.
> --
> *From: *
Hi,
Can someone tell the procedures of importing transactions into tally from
MS Excel with details.
Thanks in advance.
--
Yours,
Hari.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need
Hi,
Superb links.
Thanks,
Hari
On 14 April 2012 12:44, PRAVESH KUMAR wrote:
> Hi Varun,
>
>
> a lot of Thanks
>
>
> On Tue, Apr 10, 2012 at 9:13 AM, VARUN CHAWLA wrote:
>
>>
>>
>> On Sat, Apr 7, 2012 at 3:09 AM, Maries wrote:
>>
>>>
hread 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 bypa
other 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.
>
>
and time.
--
Yours,
Hari.
--
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
Hi guys,
Happy friendship day to all my friends.
Thanks for solving all my queries.
Regards,
Hari
On 7 August 2011 11:29, Venkat CV wrote:
> Dear Friends,
>
> *
> HAPPY FRIENDSHIP DAY To All
> *
> Best Regards,
> Venkat
> Chennai
>
>
> On Sat, Aug 6, 2011
Thanks a lot dear
On 28 July 2011 18:32, ashish koul wrote:
> SUBSTITUTE(F1&TEXT(G1,"ddmmyyy")," ","")
>
>
> On Thu, Jul 28, 2011 at 5:13 PM, Hari wrote:
>
>> dear members,
>>
>> can any one solve my query with help of formul
blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><>&l
$1642))+1,""),ROW(A112)))
On Wed, Jul 6, 2011 at 11:21 AM, Vasant wrote:
> Pls find the attached
> This function will give you only the common values in both the columns
>
> On Wed, Jul 6, 2011 at 10:49 AM, HARI NAIR
> wrote:
> > I want a marco to find common val
I want a marco to find common values of column A and B in column C in the
attached file. Please Help.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com
Thanks for getting the award. Even though, i am very new to this group,
I proudly wishes to keep this spirit high always,
Have a nice day
with best wishes,
Regards,
Hari
On 1 July 2011 21:25, Ayush wrote:
> Dear Group,
> I am extremely happy to share a good news with you. One of our d
I WANT YOUR VALUE HELP TO PUT A FORMULA IN THE ATTACHED SHEET. PLEASE HELP
THANKS IN ADVANCE..
HARI
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com
Dear Friends,
Can any one please help me in *"how to learn Excel-VBA"* through some
tutorial materials as i am CA Final student.
-
Yours,
Hari.
--
--
Some important links for excel users:
1. Fo
ase(Range("A" & i).Value) = "E" Then Range("A" & i).EntireRow.Delete
If UCase(Range("A" & i).Value) = "F" Then Range("A" & i).EntireRow.Delete
> Next
Application.ScreenUpdating = True
End Sub
Hari Lal
--
--
ng or applying the following commands
step by step in excel.
Hari Lal
delete the entire row when specification meets
Sub processdata()
Dim i As Long, lr As Long
lr = ActiveSheet.UsedRange.Rows.Count
> Application.ScreenUpdating = False
For i = 1 To lr
> If Range("A" & i)
*Macro*
Please help me
Hari Lal
--
--
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
; > also very suitable for so many conditions..
> >
> > Thanks again sir.
> >
> >
> >
> > On Jul 23, 6:33 pm, Dilip Pandey wrote:
> >> Hi Hari,
> >>
> >> I have achieved the desired result using array functionality in Vlookup
>
HLC
Hai Friends,
Please open the attached Excel file. I need your help.
I have to total 3 columns at the end of the report. I can do it by
selecting a particular ROW and insert Total function commands (=sum(E5:E35).
But if I do this, the Grid lines will appear upto the last Row, where,
total f
HLC
-- Forwarded message --
From: MNM
Date: Fri, Jul 23, 2010 at 7:12 AM
Subject: $$Excel-Macros$$ Auto Calculate Number to Percent
To: MS EXCEL AND VBA MACROS
Hi,
I am trying to figure out if there is a way to auto calculate number
entered into a column to total percent. Exa
Dear Friends,
I want rate automatically comes from rate sheet in Data sheet when I enter
the remaining details in the attached file, please help, Thanks in advance
Regards,
Hari
--
--
Some important links for
ANKURJI THANK YOU VERY MUCH
On 2/27/10, ankur wrote:
>
> hi hari
> check these files about excise
>
>
> Have A Nice Time & Enjoy Life
>
> Regards:
> CMA Ankur Pandey
> (Someone Different)
>
> I'm not the best but i'm not like the rest~~
>
>
I am looking for Central Excise Registers, like RG-23A Part-!, II, RG-1
Registers in excel .If anybody have please post
Thanks in advance
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips t
t;><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,700 subscribers worldwide and receive many nice notes about
> the learning and suppo
the
world”
--
Hari kumar
Our strength grows out of our weaknesses.
--
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and lin
Hi All,
Can anyone unprotect the files.
--
Hari kumar
Our strength grows out of our weaknesses.
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA
order Styles. Within this, there's a way to set the width: say to
> 0.25 pt.
regards
hari kumar
>
>
> From: Sonny
> To: MS EXCEL AND VBA MACROS
> Sent: Monday, October 5, 2009 8:55:18 AM
> Subject: $$Excel-Macros$$ Excel 2007: How can I u
Hi Ankur,
http://groups.google.com/group/excel-macros/files
regards
Hari kumar
On Wed, Jun 24, 2009 at 10:09 PM, ankur wrote:
>
> hello excel gurus
> thanks for helps to my earlier queries
>
> i can work properly with excel sheets,but no familiar with macros. i
> can reco
Hi
I would undoubtedly say " East or West-- Harmeet Singh is one of the kings
of this group."
regards
Hari kumar
On Wed, Jun 17, 2009 at 1:10 PM, Harmeet Singh wrote:
> Hi Ayush,
>
> Thanks a lot
> This is the charm of Excel Group that is attracting good talent.
>
()
If Application.IsText(ActiveCell) = True Then
MsgBox ("Text")
Else
If ActiveCell = "" Then
MsgBox ("Blank")
Else
End If
If ActiveCell.HasFormula = True Then
MsgBox ("Formula")
Else
End If
If IsDate(ActiveCell.Value) = True Then
MsgBox ("date")
Else
E
ow Standard and Formatting toolbars on two rows
2.Always show Full menus.
*Select as per the requirement incase we dont find as an example :Sort
option in Data menu.
>
>
> Thanks & Regards,
>
> *Hari Kumar*
>
>
>
> >
>
--
Hi Mayank,
please look into the site.
http://www.vbamacros.blogspot.com
regards
Hari Kumar
On Mon, Jun 1, 2009 at 7:16 AM, mayank khare wrote:
> plz replyyy
>
> On Mon, Jun 1, 2009 at 7:13 AM, mayank khare wrote:
>
>> Hai,
>> I want to learn indepth excel macros.
>
eStyleNone
.ColorIndex = 46
End With
With Selection.Interior
.ColorIndex = 36
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With
Else
End If
If IsDate(ActiveCell.Value) = True Then
MsgBox ("date")
Else
End If
End If
End S
pptApp = Nothing
End Sub
On Thu, Apr 9, 2009 at 2:34 AM, wrote:
>
> Hi All,
>
> Please find the attachment.
>
> My requirements is –
>
> Can anyone tell me how to pull the charts from the excel file to the
> P
Hi Aplesh / Kgrabbs,
Thank you very much.
Regards
Hari Kumar
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of kgrabbs
Sent: Friday, April 03, 2009 6:32 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re: Hi I would
osed please find the file.
Regards
Hari Kumar
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free a
Hi Puneet,
If there is no requirement of calculation in blank cells, just remove them.
Or probably try out exporting the data to access and work.
Regards
Hari Kumar
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of PUNEET NASA
Hi Harmeet,
Thank you very much.
Regards
Hari Kumar
_
From: Harmeet Singh [mailto:harmeet.hew...@gmail.com]
Sent: Wednesday, March 18, 2009 10:10 PM
To: excel-macros@googlegroups.com
Cc: prekkeh...@gmail.com
Subject: Re: $$Excel-Macros$$ Re: How to break the vba project
Hi All,
Can anyone help me how to break a vba protect password.
Regards
Hari kumar
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA
Hi Alok,
Thank you.
Regards
Hari kumar
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Alokeshwar Tiwary
Sent: Tuesday, March 10, 2009 6:35 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: charts to powerpoint
Dear
ich we open regularly.
>> Suppose a pop up message box appear on a particular date stating" Hello
>> today is the birthday of your team memeber" or " need to send a mail to some
>> one".
>>
>> Regards
>> Santosh
>>
>
>
> >
>
002,001 Dave 20
> Feb.
> 12.09
>
>
>
> Thanks all,
>
> >
>
--
Hari kumar
--~--~-~--~~~---~--~~
-
Some important lin
Hi Vinu,
When you are replying there will be an option "attach a file", select your
attachment.
regards
hari kumar
On Tue, Feb 17, 2009 at 10:43 PM, vinu wrote:
>
> Hello Group members,
>
> Could you pls let me know how to attach the file while replying to any
> of
Hi Pavithrak,
Not sre what markers are required.
i had updated three radio buttons but not sure of the code which you require
the below link has the option of adding the code.
*http://www.functionx.com/excel2003/articles/radiobuttons.htm*
regards
Hari kumar
On Wed, Feb 18, 2009 at 8:56 AM
pe
> of computer each individual in column A is using. I'm looking for a
> formula or series of formulas that will tell me how many PC's,
> laptops's and CAD's are being used but only counting one per name once
> (hope that makes sense)."
>
> >
>
Hi Mudassar,
It would be advisable to go for pivot table by organising data in proper
fields.
Regards
Hari kumar
On Tue, Feb 10, 2009 at 3:38 AM, Mudassar Ramzan wrote:
> Dear Group Member,
> Can some one help me on attached file.
> I wanted to g
ted XLA file
>
> Harish Upadhyay
> 9773284902
>
>
> On 2/8/09, VIRAL PANDYA wrote:
>>
>> How can i open Password protected XLA file?
>>
>> Regards,
>> Viral Pandya
>>
>>
>>
>
> >
>
--
Hari kumar
--~--~-~--~~~---~-
lling cells with various values.
> > However, I much prefer to use the keyboard in preference to the mouse. Is
> it
> > possible to utilize the fill handle in some way only by using the
> keyboard?
> >
> > aJaY :) (R)™
>
> >
>
--
Hari kumar
--~--~
lso excludes
> holidays and weekends.But I am not able to add the exact time.
>
> Can YOU help me to get it done through macros??
>
> Thanks in Advance
>
> >
>
--
Hari kumar
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutoria
67 matches
Mail list logo
