Hello Asish,
I tried it and its working fine but I need to know is there any other way
to get this result.
Regards,
Chandra
On Wed, Oct 2, 2013 at 12:31 PM, ashish koul koul.ash...@gmail.com wrote:
y dont u try pivot table
On Wed, Oct 2, 2013 at 12:28 PM, Chandra Shekar
Dear Excel Guru's,
I need a excel test for interview purpose, anyone can provide the excel
test..
Thanks in advance
.
Thanks Regards,
Sriram . G (Chennai)
--
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
Actullay its fuction u have to use as Excel formulas type =sumup(b2) and
drag
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Indrajit $nai
Sent: Thursday, October 03, 2013 1:29 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help
Dear Ashish,
Thanks for the code.
My requirement is to import all the word tables from all the sub-folder in
the given path.
I got the following code from the net which obviously is not working.
Sub DoItNow()
Dim file
Dim path As String
' the path to the folder
' make SURE you include the
Hey, Ravinder it's really great, thanks bro. :)
--
Indrajit
Disclaimer:
This electronic message and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to whom they
are addressed. If you are not the intended recipient you are hereby
original link :
https://secure.fundsupermart.com/main/fundinfo/dailyPricesHistory.tpl?id=
FI3039
With ActiveSheet.QueryTables.Add(Connection:= _
URL;https://secure.fundsupermart.com/main/fundinfo/dailyPricesHistory.tpl?id=Sheet1.Range(H1).Value,
Destination:=Range(
A1))
=MIN(IF($B$2:$B$10=C2,$A$2:$A$10))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chandra Shekar
Sent: Tuesday, October 01, 2013 7:58 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Min based on condtions
Hello,
am trying to get
Hello,
Is there any other way to get this other than Min If conditions.
Regards,
Chandra
On Thu, Oct 3, 2013 at 3:14 PM, Ravinder ravinderexcelgr...@gmail.comwrote:
=MIN(IF($B$2:$B$10=C2,$A$2:$A$10))
** **
*From:* excel-macros@googlegroups.com [mailto:
try this
Sub test()
ActiveSheet.Pictures.Insert (C:\Users\admin\Desktop\Excel Tips
Tricks\01.jpg)
With ActiveSheet.Shapes(ActiveSheet.Shapes.Count)
.LockAspectRatio = False
.Left = Range(a1).Left
.Top = Range(a1).Left
.Width = 180
.Height = 180
End With
End Sub
On Thu,
to avoid typing in combobox
On Thu, Oct 3, 2013 at 12:27 AM, Bipin Singh bipin.ling...@gmail.comwrote:
Hello Ashish,
May I ask you the use of ComboBox1_KeyDown and ComboBox1_KeyPress event in
provided solution if *Userform.show* is already inside worksheet change
event..
Thanks in
if data is sorted then u can use index match
On Thu, Oct 3, 2013 at 5:51 PM, Chandra Shekar chandrashekarb@gmail.com
wrote:
Hello,
Is there any other way to get this other than Min If conditions.
Regards,
Chandra
On Thu, Oct 3, 2013 at 3:14 PM, Ravinder
have you tried the code which i shared
On Thu, Oct 3, 2013 at 1:34 PM, Nasir Khan nasirkhan.du...@gmail.comwrote:
Dear Ashish,
Thanks for the code.
My requirement is to import all the word tables from all the sub-folder in
the given path.
I got the following code from the net which
try something like this
URL;
https://secure.fundsupermart.com/main/fundinfo/dailyPricesHistory.tpl?id=;
Sheet1.Range(H1).Value, Destination:=Range(
A1)
On Thu, Oct 3, 2013 at 2:20 PM, asd...@gmail.com wrote:
original link :
do you want to sum all the values of Fridays of each month
On Wed, Oct 2, 2013 at 6:09 PM, asd...@gmail.com wrote:
On Tuesday, October 1, 2013 10:18:15 PM UTC+8, asd...@gmail.com wrote:
vba returns total Fridays in A2:A6. If A2:A6 all are Fridays. The value
should be 5.
Plse refer to
On Thursday, October 3, 2013 4:50:23 PM UTC+8, asd...@gmail.com wrote:
With ActiveSheet.QueryTables.Add(Connection:= _
URL;https://secure.fundsupermart.com/main/fundinfo/dailyPricesHistory.tpl?id=FI3039;
, Destination:=Range( _
$A$1))
.FieldNames = True
On Thursday, October 3, 2013 4:50:23 PM UTC+8, asd...@gmail.com wrote:
With ActiveSheet.QueryTables.Add(Connection:= _
URL;https://secure.fundsupermart.com/main/fundinfo/dailyPricesHistory.tpl?id=FI3039;
, Destination:=Range( _
$A$1))
.FieldNames = True
On Thursday, October 3, 2013 10:10:03 PM UTC+8, ashish wrote:
try something like this
URL;
https://secure.fundsupermart.com/main/fundinfo/dailyPricesHistory.tpl?id=;
Sheet1.Range(H1).Value, Destination:=Range(
A1)
not working
On Thu, Oct 3, 2013 at 2:20 PM,
On Thursday, October 3, 2013 10:10:03 PM UTC+8, ashish wrote:
try something like this
URL;
https://secure.fundsupermart.com/main/fundinfo/dailyPricesHistory.tpl?id=;
Sheet1.Range(H1).Value, Destination:=Range(
A1)
*not working*
On Thu, Oct 3, 2013 at 2:20 PM,
check the attached file see if it helps
On Thu, Oct 3, 2013 at 8:24 PM, asd...@gmail.com wrote:
On Thursday, October 3, 2013 10:10:03 PM UTC+8, ashish wrote:
try something like this
URL;https://secure.**fundsupermart.com/main/**
check attached file see if it helps
On Thu, Oct 3, 2013 at 8:20 PM, asd...@gmail.com wrote:
On Thursday, October 3, 2013 4:50:23 PM UTC+8, asd...@gmail.com wrote:
With ActiveSheet.QueryTables.Add(Co**nnection:= _
URL;https://secure.**fundsupermart.com/main/**
Yes I did.
But as mentioned in my reply I need the code to
1) run on all the files in the given Path = Your code run a single folder
at a time...there are several folder in the given path.
2) Each table should come on a separate sheet - Your code bring in the
table one below other
3) The sheet
On Thursday, October 3, 2013 11:01:36 PM UTC+8, ashish wrote:
check the attached file see if it helps
still not working
On Thu, Oct 3, 2013 at 8:24 PM, asd...@gmail.com javascript: wrote:
On Thursday, October 3, 2013 10:10:03 PM UTC+8, ashish wrote:
try something like this
Hi Ashish,
Unfortunately, it has failed again. The message I get indicates...
Run Time error '1004'
Insert method of pictures class failed.
Not certain if it matters, but I am inserting bitmaps (.bmp). I am also
using Excel 2007.
On Thursday, October 3, 2013 9:54:51 AM UTC-4, ashish
Hi Besole,
This kind of work, but there are a couple of issues.
A. I would much prefer inserting the graphic file as opposed to having to
manually enter the whole directory. Unfortunately, the files are being
stored in different directories and sub-directories for classification
purposes
Hi De Premor,
Yes this pretty much close to what I am looking for.
Many thanks.
On Thursday, October 3, 2013 10:44:12 PM UTC-4, De Premor wrote:
try this attached file, i hope you can find something there
On 03-10-2013 7:22, Bill Q wrote:
Hi Ashish,
I put the macro into the
You're welcome,
With that code you can customize the image to fit with cell width or cell height
-Original Message-
From: Bill Q ronsmith...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 3 Oct 2013 19:52:50
To: excel-macros@googlegroups.com
Reply-To:
Thanks Ravinder. This works perfect for me. :-)
Also, can you guide me with material/ website from which i
can learn dashboard from scratch to end.
Regards,
Ashwani
On Thu, Oct 3, 2013 at 12:40 PM, Ravinder ravinderexcelgr...@gmail.comwrote:
PFA, I think u r looking for this.
** **
27 matches
Mail list logo