Dear Ravinder,
Yes your answer is absolutely correct...
Magnificent. Absolutely amazing.
Thanks a lot for the solution
Regards
Amar
On Thu, Nov 28, 2013 at 12:22 PM, Ravinder wrote:
> Pfa.
>
>
>
> Button 1 is for getting the all files names in excel from a specific
> folder.
>
>
Pfa..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shrinivas Shevde
Sent: Thursday, November 28, 2013 11:53 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Comments
Waiting for Reply
On Wed, Nov 27, 2013 at 2:18 PM, Shrinivas
Please try the below code.. Hope this will help Shrinivas..
Sub showcomments()
Application.ScreenUpdating = False
Dim commrange As Range
Dim mycell As Range
Dim curwks As Worksheet
Dim newwks As Worksheet
Dim i As Long
Set curwks = ActiveSheet
On Error Resume Nex
Please can any one help me on help me on below issue.
Thanking in advance.
On Nov 28, 2013 9:03 AM, "SHRINIVAS C A" wrote:
> Dear all,
>
> I have some data in excel first row, want convert into XML file.
>
> Requesting you to advice on the same.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in
Pfa.
Button 1 is for getting the all files names in excel from a specific folder.
Button 2 is for rename the files from "A" to "C" column values.
You can put name manually also in column a and then use rename(2) button or
get all files from specific folder then put new name in column B if
Waiting for Reply
On Wed, Nov 27, 2013 at 2:18 PM, Shrinivas Shevde wrote:
> Dear all
> I have excel sheet in which I added comments in many cell.
> I want to get all the comments in row one below another may be any order.
> In one sheet there are more than 40 comments and such I have 16 to 18
Its ok
You can also try averageif function
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Noel Sherry
Sender: excel-macros@googlegroups.com
Date: Wed, 27 Nov 2013 22:58:45
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Formula for averaging re
Pfa examples file
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Amit Desai (MERU)
Sent: Thursday, November 28, 2013 10:49 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Column Reference to change when we move to
next row
Can some
any suggestion friends?
On Wed, Nov 27, 2013 at 4:34 PM, amar takale wrote:
> Dear all Champs
>
> Pls suggest VBA code for rename files name in specific folder. I change
> only folder path in code.There are list of 100 files name in excel column
> A .Also there are list of file name in excel
Can someone please help?
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Amit Desai (MERU)
Sent: 27 November 2013 16:14
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Column Reference to change when we move to next row
Hi Group,
I have a formu
Ashish,
I just double checked and that works like a charm. Thanks so much. I really
searched for a formula and tried 8 to 10 I found, but none worked. This is
perfect. Wow, this forum is amazing. I will have other questions as I
continue to use Excel. Should I check this as completed?
Noel
On W
Dear all,
I have some data in excel first row, want convert into XML file.
Requesting you to advice on the same.
--
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 @
https://www.facebook.com/discussexcel
That looks good, compared to the ones I have found on the Internet. I will
plug this in and try it. Thanks,
Noel
On Wed, Nov 27, 2013 at 10:28 PM, ashish koul wrote:
> =SUMIFS($D$2:$D$63,$C$2:$C$63,"*pm")/COUNTIF($C$2:$C$63,"*pm*")
>
> use same for am
>
>
> On Thu, Nov 28, 2013 at 8:53 AM, Noel
=SUMIFS($D$2:$D$63,$C$2:$C$63,"*pm")/COUNTIF($C$2:$C$63,"*pm*")
use same for am
On Thu, Nov 28, 2013 at 8:53 AM, Noel Sherry wrote:
> Sure Ashish,
> That was a quick response. I just joined this forum and posted my
> question. I have put a sample Excel attached to this to show the problem.
> T
Sure Ashish,
That was a quick response. I just joined this forum and posted my question.
I have put a sample Excel attached to this to show the problem. The first
column is the date, second column the day, third the time, the morning or
AM reading in the even numbered cells of column D (4th column)
in this case you want to highlight 1.571003
On Wed, Nov 27, 2013 at 2:45 PM, anon wrote:
> Attached.
>
>
> On Tuesday, 26 November 2013 18:06:00 UTC, ashish wrote:
>
>> can u share a sample file
>>
>>
>> On Tue, Nov 26, 2013 at 11:19 PM, anon wrote:
>>
>>> Hi all,
>>>
>>> Using conditional fo
try the attachement
On Wed, Nov 27, 2013 at 3:14 PM, Rajesh Agarwal wrote:
> Dear Friend
> How to put conditional formatting in column b.
> rgds
>
> --
> *Rajesh Kumar Agarwal*
>
> --
> 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 offic
even number byr row or value can u share a sample file
On Thu, Nov 28, 2013 at 8:43 AM, wrote:
>
>
> I am working on a DMin, for Bethel Seminary, and am trying to find a
> formula to average the even and the odd numbered cells or rows in an Excel
> 2010 column of blood pressure readings, the ev
I am working on a DMin, for Bethel Seminary, and am trying to find a
formula to average the even and the odd numbered cells or rows in an Excel
2010 column of blood pressure readings, the even cells have the morning
readings, and the odd cells have the evening reading. I am trying to get
the
Hi Friend,
I am not able to access your attachment. I am getting error message as link
not available.
Can you please help me to get as excel sheet.
Thanks & Regards
Venkateswaran.S
On Monday, November 25, 2013 9:21:34 AM UTC+1, XLS S wrote:
> as required, PFA
>
> .
Guys,
Want to know how check it out
http://excelautomate.blogspot.in/2013/11/sending-email-from-excel-using-vba.html
Thanks,
Anoop Kumar.V
--
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 @
https://ww
Hi Dawns,
Check http://excelautomate.blogspot.in/ for more excel tricks
On Saturday, 21 September 2013 18:44:29 UTC+5:30, DawnS wrote:
>
> This is not actually a question but just a big THANKYOU to the three
> responses to by prob. Thanks heaps guys! The key just below Esc combined
> with Cont
check here..
http://excelautomate.blogspot.in/2013/11/function-to-find-unique-items-in-list.html
On Wednesday, 16 October 2013 20:29:51 UTC+5:30, Excel ka Keeda wrote:
>
> Dear Exterts,
>
> I am stuck in my project and need your expert advice that ho can i prevent
> duplicate data entry in any c
Hi Howard,
check this site for learning simple macros in easy ways...
http://excelautomate.blogspot.in
On Sunday, 27 October 2013 08:26:00 UTC+5:30, Howard Rambin wrote:
>
> I am new to macros in Excel (wiz at lotus keyboard macros).
>
> I don't have not problem recording a simple print macro wit
Check VBA's most useful built in functions
http://excelautomate.blogspot.in/2013/11/vbas-most-useful-built-in-functions.html
On Thursday, 7 November 2013 11:13:59 UTC+5:30, rutuja patekar wrote:
>
> I am taking data from one workbook and finding the same data in different
> workbook.
>
> I am usi
Hi Rajan,
Please check here to understand Excel formulas in detail.
http://excelautomate.blogspot.in/2013/11/how-to-work-with-formulas-in-excel.html
On Monday, 11 November 2013 15:42:14 UTC+5:30, Rajan sharma wrote:
>
> Dear experts,
>
> I have wrote formula in the attached file, but throwing e
Hi Excel Fans,
My self Anoop Kumar, working as a automation tester. I'm using Excel for my
automation activities such as mainframe validation, job submitting,
internet explorer automation, report automation etc.
Want to know more about automation visit my blog :
www.excelautomate.blogspot.in
Hi Jadhav,
Please check here for formats
http://excelautomate.blogspot.in/2013/11/using-custom-format-for-numbers-dates.html
On Monday, 18 November 2013 12:23:35 UTC+5:30, Prafull Jadhav wrote:
>
> Dear All,
>
> Good Afternoon !
> I have one small query regarding date format .
> Daily i am gett
Hi Mickey,
Check these posts for more about hyperlinks
http://excelautomate.blogspot.in/2013/11/how-to-create-hyperlinks-in-multiple.html
and creating dropdown list of hyper links
http://excelautomate.blogspot.in/2013/11/drop-down-list-of-hyperlinks.html
On Friday, 22 November 2013 03:31:49 UTC+
Good Evening Dharam,
Please check this blog for simple way of creating VBA macros and functions.
www.excelautomate.blogspot.in
On Sunday, 24 November 2013 10:12:30 UTC+5:30, Dharm Pd wrote:
>
>
>
> Dear All,
>
> I work in Excel from last 8 years and understand almost all function of
> Excel but
Hi,
I need to automate a web application, i can pick the HTML Elements and set
the values. But I am unable to send the keys like "ENTER","TAB" into
Internet Explorer.
I tried different types of send keys options
Please help me with answeres
With Thanks,
Anoop Kumar.V
www.excelautomate.blogpso
Dear all Champs
Pls suggest VBA code for rename files name in specific folder. I change
only folder path in code.There are list of 100 files name in excel column
A .Also there are list of file name in excel column B which I want to
replace on column A name list.So in excel after put code only ch
Hi Group,
I have a formula in which I have reference of column "A". when I go down I want
to change the formula to refer column "B". is there any way to do this? As of
now I need to change the same manully.
Regards,
Amit Desai - MIS Manager
M: +91 9867232534
[cid:image001.jpg@01CEEB8B.B90C5DE0
Dear Friend
How to put conditional formatting in column b.
rgds
--
*Rajesh Kumar Agarwal*
--
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 @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use c
Attached.
On Tuesday, 26 November 2013 18:06:00 UTC, ashish wrote:
>
> can u share a sample file
>
>
> On Tue, Nov 26, 2013 at 11:19 PM, anon
> > wrote:
>
>> Hi all,
>>
>> Using conditional formatting, how can I highlight the smallest-valued
>> cell which is greater than 1.5?
>>
>> Thanks.
>>
>>
Dear all
I have excel sheet in which I added comments in many cell.
I want to get all the comments in row one below another may be any order.
In one sheet there are more than 40 comments and such I have 16 to 18
sheets
Can any one help me to write code which will do this.
Sheet is attached
--
S
36 matches
Mail list logo
