Hi,
I maintain my monthly production figure in a excel file.The file is
maintained for each Financial year.
In one of the sheet I keep values for different months by giving links
to values present in other sheets from same files some values from
other excel file.
Now I want to make new file for
While most of the solutions revolve around getting the second highest value
from a list of duplicates, here's something that will help you get a unique
list of Large values from a list of duplicates.
Dear fellow members of this group,
Thank you for all the kind words. For all who have posted here, a big
thanks, and I would like to keep it as a blanket thanks for anybody posting
in later (if they do :D).
As I always maintain, it is good to be a part of such a group. All regards
to Donald,
Sandeep,
The -- is used as an unary operator to convert a boolean value ie,
TRUE/FALSE in to 1/0. Sumproduct for example does not evaluate non-numeric
values that results in a formula like the boolean results in the array
equation A1:A10=Sandeep.
So to negate this, we use unary operator -- with
The edit links feature in Excel is specifically given for this. YOu just
need to browse for the new file, and OK it. Did you try that?
Regards,
Sam Mathai Chacko
On Sat, Dec 3, 2011 at 12:20 PM, debasish debasis...@gmail.com wrote:
Hi,
I maintain my monthly production figure in a excel
Hi Debasish,
Also try Find and Replace option.
*Select the cells Ctr+H *
[image: find replace.jpg]
Regards,
MARIES.
+971559828492
On Sat, Dec 3, 2011 at 2:43 PM, Sam Mathai Chacko samde...@gmail.comwrote:
The edit links feature in Excel is specifically given for this. YOu just
need
congrats sam...
On 12/3/11, Sam Mathai Chacko samde...@gmail.com wrote:
Dear fellow members of this group,
Thank you for all the kind words. For all who have posted here, a big
thanks, and I would like to keep it as a blanket thanks for anybody posting
in later (if they do :D).
As I always
Hi Ashish,
i need to open all files in a folder and run the macro regarding macro i
can take care but opening all files in folder i am getting trouble
application .filesearch is not working 2010 coudl you please let me know
how to do that.
--
Rakesh Joshi
--
FORUM RULES (934+ members already
Rakesh,
Application.FileSearch has been discontinued from Excel 2007 for reasons I
am still not sure why. You can find an alternative method here.
http://www.ozgrid.com/forum/showthread.php?t=147929
Regards,
Sam Mathai Chacko
On Sat, Dec 3, 2011 at 6:20 PM, Rakesh Joshi rakesh.ri...@gmail.com
Hi All,
In case if i want to close many excel files ( not all) or emails all at a time
(in stead of selecting one at a time - want to select many..), how can we do
that?
Regards,
Amit Desai
Disclaimer: This message and its attachments contain confidential
Try removing blank cells in your defined name list or ' ' '
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: B Sharma
Sent: Friday, December 02, 2011 10:52 PM
To: MS EXCEL AND VBA MACROS
Cc: rajanverma1...@gmail.com
Subject: $$Excel-Macros$$ Data
This assumes you have a list of files entered in cells and have used ctrl to
select the file(s) to close
You can use another macro to make the list if not there
Sub CloseSelectedWorkbooks()
On Error Resume Next
Application.DisplayAlerts = False
For Each wb In Selection
workbookname = wb.Value
Remove check from Ignore Blanks in data validatoin
On Sat, Dec 3, 2011 at 7:20 PM, dguillett1 dguille...@gmail.com wrote:
Try removing blank cells in your defined name list or ' ' '
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message- From: B Sharma
Sent:
By FileSystemObject we can do operation with File and folder..Here is code
for that..
Sub GetAllFilesInAFolder()
Dim fso As New Scripting.FileSystemObject
Dim flFIle As File
Dim fdFOlder As Folder
Set fdFOlder = fso.GetFolder(C:\Documents and Settings\Cyber
Junction\My Documents)
As it convert TRUE/False into 1/0 ..we can debug formula error easily..
On Sat, Dec 3, 2011 at 4:02 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Sandeep,
The -- is used as an unary operator to convert a boolean value ie,
TRUE/FALSE in to 1/0. Sumproduct for example does not evaluate
I think macro recording is not a good idea to find duplicates ... because
most of time sheet Name will change.. Data Range at worksheet will
change..
You can write a macro for this purpose..by using conditional Formatting..
On Sat, Dec 3, 2011 at 9:32 AM, vijayajith VA
Hay Guy,,
Can any one please Help me in this, this is really critical..
Regards
Pankaj k Pandey
On Sat, Dec 3, 2011 at 3:34 AM, Secret Shot secrets...@gmail.com wrote:
Dear Experts,
Greeting of the Day,
I am facing a very strength problem, I have created a workbook, which have
2
Hay Guy,,
Can any one please Help me in this, this is really critical..
Regards
Pankaj k Pandey
On Sat, Dec 3, 2011 at 4:26 AM, Secret Shot secrets...@gmail.com wrote:
Dear Experts,
Can anyone please tell me that how to Enable Activex Setting in Excel
2003. I know how to do this in
you can use Countifs like this.. if you want to compare value you need to
put the operator ( ) in inverted COmmas..
=countifs(B1:B17,10,A1:A17,10)
On Sat, Dec 3, 2011 at 4:49 AM, B.N.Chethan Kumar chetankumar1...@gmail.com
wrote:
Please find the information as requested
On Sat, Dec 3,
if we need to know how many Rows Contains data we can use indirect
function like this :
=ROWS(INDIRECT(A1:ACOUNTA(A:A)))
On Thu, Dec 1, 2011 at 11:19 PM, Aamir Shahzad aamirshahza...@gmail.comwrote:
thanks Noorain / Chethan Kumar.
Regards,
Aamir Shahzad
On Thu, Dec 1, 2011 at 9:03 AM,
hi
its a strange problem but hope it will help you ..
http://www.mrexcel.com/forum/showthread.php?t=71323
On Thu, Dec 1, 2011 at 6:04 PM, Aivi aivran...@gmail.com wrote:
Hi,Friends
Any body give the refernce of MACRO IN EXECEL 2007, How can create and how
do work the with macros
Pls give
please ignore that post.,
You can download this book..
http://www.rencross.co.uk/ebookshelf/Microsoft/Visual%20Basic/Office/VBA/Excel%202007%20Power%20Programming%20With%20VBA.pdf
On Sat, Dec 3, 2011 at 8:43 PM, rajan verma rajanverma1...@gmail.comwrote:
hi
its a strange problem but hope it
Hope it will help
http://www.mrexcel.com/forum/showthread.php?t=71323
On Sat, Dec 3, 2011 at 8:16 PM, Secret Shot secrets...@gmail.com wrote:
Hay Guy,,
Can any one please Help me in this, this is really critical..
Regards
Pankaj k Pandey
On Sat, Dec 3, 2011 at 4:26 AM, Secret Shot
Dear Rajan,
Its not working for me... :(,
Regards
Pankaj k Pandey
On Sat, Dec 3, 2011 at 8:50 PM, rajan verma rajanverma1...@gmail.comwrote:
Hope it will help
http://www.mrexcel.com/forum/showthread.php?t=71323
On Sat, Dec 3, 2011 at 8:16 PM, Secret Shot secrets...@gmail.com wrote:
Hay
http://tinyurl.com/72uneme
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Secret Shot
Sent: Saturday, December 03, 2011 8:46 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Expert Advice Needed - in VBA.
Hay Guy,,
Can any one please Help me in this, this is
Sub Consolidator()
Dim rng As Range
Dim lng As Long
Dim var As Variant
With Worksheets(Sheet1)
lng = Application.CountIf(.Range(D1, .Cells(Rows.Count,
D).End(xlUp)), Name of party)
ReDim var(0 To lng, 0 To 4)
var(0, 0) = Sl No.: var(0, 1) = Unit No.:
Dear Aamir,
Please use
*=SUMPRODUCT(--($F$3:$F$14=B5)*($G$3:$G$149))*
See attached sheet..
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Sat, Dec 3,
Hi Noorain,
Its not opening.Only excel window is opening but not able to see sheets..
can you send it once again Please ? Thanks
On Sat, Dec 3, 2011 at 11:23 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Vijay,
Please use this add-in to Compare Sheets.
Thanks regards,
Noorain
Dear Rakesh,
Please use below code to open file of Folder,
*Sub open_all_fileoffolder()
flname = Application.GetOpenFilename(MultiSelect:=True)
For Each fname In flname
Workbooks.Open fname
Next
End Sub
*
--
Thanks regards,
Noorain Ansari
Dear Vijay,
It is actually Add-in File you have to add it in Add-In.
Process :
Click the Microsoft Office Button , click Excel Options, and then click
Add-Ins.
View the add-ins and application extensions that are categorized as follows:
Active Application Add-ins: Lists the extensions that are
Dear B. Sharma,
Read this article or use VBA Macro mentioned thereby:-
http://www.excelitems.com/2010/11/shrink-reduce-excel-file-size.html
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*
Dear Aamir,
Please see attached Sheet.
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Sat, Dec 3, 2011 at 1:46 AM, Aamir Shahzad
Dear friends
thanks for replyinng
But I havrent got my solution
On Dec 3, 11:19 pm, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear B. Sharma,
Read this article or use VBA Macro mentioned
thereby:-http://www.excelitems.com/2010/11/shrink-reduce-excel-file-size.html
Thanks regards,
Heartiest Congratulations Sam keep up the helping spirit.
Regards,
DILIPandey
On 12/2/11, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Sam Mathai Chacko has been recognised as 'Most Helpful Member' for the
month of Nov'11
He has posted 129 posts (13% of total posts) in Nov
Thanks sam,
I just want to ask u that i have try the option at my house but i can not
able to change the option in my office pc so is there any other option or
any macro code for outlook which can solve my problem
sorry for late reply.
On Tue, Nov 29, 2011 at 7:22 PM, Sam Mathai Chacko
35 matches
Mail list logo