Hi
You can do using Pivot Table, see attached file.
1. In the Pivot Table, click the drop down arrow in the RowLabels field
heading.
2. In the pop-up menu, click Value Filters, then click Top 10 & change
it to 5.
You can sort on Descending on Output by going thru More Sort option un
Hi
Attachment is missing..
Thx
On Mon, Apr 28, 2014 at 7:14 PM, L.K. Modi wrote:
> Dear Sir
>
> I have downloaded a file from the net but unable to understand the logic
> in column Q AND R as the file is read only only so can anyone say me how
> that delay had been calculated and interest is
Hi Modi,
Im not clear with Defaults month (column Q) because it does not match with
due date and payment day.
But Defaults Interest (column R) is calculate by if *defaults
months*greater than 0 then *TDS
amount * 1.5% * defaults months* else the defaults interest will be *0*.
(=if(defaultsmonth>0
Hi All,
Need some help on excel calculations:
I have a data of employee attendance (daily in/out time). The extract from
timekeeping software does come in format for me to analyse it further,
Sample file of base data and output required is attached. Request you to
pls provide me a solution so th
Dear experts,
please help me
Thanks & Regards´¨)
¸ •´ ¸.•*´¨) ¸.•*¨)
(¸.•´ (¸.•* ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪
P Let us do our best to save nature, save water, plant trees, protect
greenery, keep our surroundings clean, reduce usage of plastics, and
use renewable en
Any place you have:
Sheets(
add the workbook name:
Workbooks("Firstfile").Sheets(
For the workbook that contains the code, you can use:
Thisworkbook.Sheets(
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the pl
Hi Paul,
The code given above works well for the sheets in same workbook.
send me the code for data in two different work books.
Regards
Eugene
On Fri, Apr 25, 2014 at 9:15 PM, Paul Schreiner wrote:
> It works perfectly in my workbook.
> Row 6 is unhighlighted in sheet1
> and 6 and 13 are unhi
Vaibhav, before giving a solution, it is always a kind thing to do to
ensure you validate what you are saying. If the Applications Extensibility
library reference wasn't added, the sub-routine wouldn't have even execute
because the declaration in the following lines would have not compiled.
Dim Sr
Dear Sir
I have downloaded a file from the net but unable to understand the logic in
column Q AND R as the file is read only only so can anyone say me how that
delay had been calculated and interest is calculated...
thanks in advance
regards
LKM
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Exc
Dear friends
can any one explain the use of getpivot data... i have excel 2010 and it
seems much advanced formulas and all so if any one have working with
examples of such new formula pls suggest me or guide me...
thanks to all
ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
dear experts
can u please explain the function of scenario manager and where can we use
this as some of my senior had told me that its very useful but i have not
much knowledge of this funtion.
ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,
Dear friends
can any one explain the use of getpivot data... i have excel 2010 and it
seems much advanced formulas and all so if any one have working with
examples of such new formula pls suggest me or guide me...
thanks to all
ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
OK
On Mon, Apr 28, 2014 at 4:55 PM, Ravi Kumar wrote:
>
> Ok PFA...
>
> You can also post your queries in below link by click on "New Thread"
>
> http://excelvbasupport.com/forum/forumdisplay.php?fid=6
>
>
>
> Warm Regards,
> Ravi Kumar.
>
> -Original Message-
> From: excel-macros@googleg
Dear ravi ,Can you Pls send me sample excel
On Mon, Apr 28, 2014 at 4:24 PM, Ravi Kumar wrote:
> Try this
>
>
> Sub Button1_Click()
> Dim wb As Workbook
> Dim ws As Worksheet
> Dim tbl As ListObject
> Dim wrd As Object
> Dim doc As Object
> Dim sel As Object
> Set wb = ThisWorkbook
> Set ws = wb
Try this
Sub Button1_Click()
Dim wb As Workbook
Dim ws As Worksheet
Dim tbl As ListObject
Dim wrd As Object
Dim doc As Object
Dim sel As Object
Set wb = ThisWorkbook
Set ws = wb.Sheets(1)
Set wrd = CreateObject("word.application")
wrd.Visible = True
Set doc = wrd.Documents.Add
For Each tbl In w
Same error show "cant find project or library"
On Mon, Apr 28, 2014 at 4:10 PM, Ravi Kumar wrote:
> Ok check the below link
>
> http://excelvbasupport.com/forum/showthread.php?tid=23
>
>
>
> Warm Regards,
> Ravi Kumar.
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:e
Ok check the below link
http://excelvbasupport.com/forum/showthread.php?tid=23
Warm Regards,
Ravi Kumar.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of amar takale
Sent: Monday, April 28, 2014 4:02 PM
To: excel-macros@googleg
Dear Ravi
Sheet not work with modified code Pls send me excel sheet with this
modified code. (In references show Missing: "Microsoft Word 14.0
Object Library")
Regards
amar
On Mon, Apr 28, 2014 at 3:40 PM, Ravi Kumar wrote:
> No need to do anything just comment the two lines
>
> 'Dim wrdapps A
No need to do anything just comment the two lines
'Dim wrdapps As Word.Application
'Dim wrddoc As Word.Document
It would work
Warm Regards,
Ravi Kumar.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of amar takale
Sent: Monday,
Hi Amar, PFB link for your solution, now you can add whatever the table in
excel and copy paste in word one by one,, pls revert if you are looking
something else. On this...
http://excelvbasupport.com/forum/showthread.php?tid=23
-Original Message-
From: excel-macros@googlegroups.com [m
Visit on the below link and check if you are asking for the same
http://excelvbasupport.com/forum/showthread.php?tid=22
Warm Regards,
Ravi Kumar.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of amar takale
Sent: Monday, April
Check the same link now…
http://excelvbasupport.com/forum/showthread.php?tid=8
Warm Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Suyog Kulkarni
Sent: Monday, April 28, 2014 2:35 PM
To: excel-macros@googlegroups.com
Dear all excel champs friends
Can any one proper guide on this topic means it uis possible or not?
Regards
Amar
On Fri, Apr 11, 2014 at 12:21 PM, amar takale wrote:
> Dear Ashish sir
>
> Pls help me on this solution.
>
> I would appreciate very much Sir
>
> Regards
> Amar Takale
>
> On Mon, Apr 7
Hi
Check reference is given to Microsoft Visual Basic for Applications
Extensibility 5.x"
Thanks
On Mon, Apr 28, 2014 at 5:50 AM, Sam Mathai Chacko wrote:
> Ondrej, for that you'll have to enable programmatic access to VBA. Just
> search the internet how to do that, or post back. Someone will h
24 matches
Mail list logo