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
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
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
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.
>
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
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
24 matches
Mail list logo
