Use this =countif(A:A,A2)1 in conditional formating. Its compares all of
the values in column A to the contents of cell A2 the condition is TRUE if
there r more den one. After dat set the format if there r duplicate. Then
use filter by color.
On Sun, Oct 2, 2011 at 11:05 AM, anil kumar
Hello,
Any help on this. Thanks in advance.
Regards,
Chandra Shekar B
On Fri, Sep 30, 2011 at 8:47 AM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hello,
I am looking for a macro which can copy slides based on TITLE and create a
new presentation. Could u please help me out in the
Congrats...!!!
On Mon, Oct 3, 2011 at 10:10 AM, Venkat CV venkat1@gmail.com wrote:
Dear Ayush,
Congrats
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71
*
On Sun, Oct 2, 2011 at 8:40 PM, NOORAIN ANSARI
Hi,
Can any one help me. My Excel Files are *corupted *Please tell me what i can
do for *Recover Excel files.*
*
*
*
*
Rashid Memon.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
Hi,
Use format function.
ex. MsgBox Format(CDate(03/10/2011), dd-mmm-)
Regards,
Swapnil.
On Mon, Oct 3, 2011 at 11:33 AM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Dear Friends,
would u please help me about the below mentioned problem in VBA EXCEL
I like to put the date
thank you for your quick responce Swapnil Palande . But i want to say is
there any option in excel to put the date value like dd/mm/,without
changing my computer date format.
Thanking you
Sanjib
On Mon, Oct 3, 2011 at 11:43 AM, Swapnil Palande
palande.swapni...@gmail.com wrote:
Hi,
Hi Sanjib,
The code I had given is vba code it will not change your computer date
format.
If you want to change date format for particular cell without using code
then you can do that using following method
1. Right Click on Cell and select Format Cells option
2. Custom category in Number tab
But It is not working sir,
I want to put the value as 25/09/2011 and like to display 25/sep/2011
regards,
sanjib
On Mon, Oct 3, 2011 at 12:58 PM, Swapnil Palande
palande.swapni...@gmail.com wrote:
Hi Sanjib,
The code I had given is vba code it will not change your computer date
format.
Thanks Mahesh,
But it is capturing only div sheet, i want to capture all 3 sheets.
Regards,
Shrinivas
From: Mahesh parab [mailto:mahes...@gmail.com]
Sent: Saturday, October 01, 2011 10:38 PM
To: excel-macros@googlegroups.com; Chidurala, Shrinivas [ICG-GTS]
Dear Rashid,
Please try through below link, I hope it will be help to u..
http://www.wikihow.com/Recover-a-Corrupt-Excel-File
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*
Dear Azeem,
Please provide query
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Mon, Oct 3, 2011 at 2:47 PM, Azeem Quraishi (HAB5) aqurai...@ccc.aewrote:
Hi group,
I had been struggling with a solution for a problem from many
days..
Recently i had seen a macro in this group which is very much nearer to my
problem.The sample data is taken from one of the previous examples given by
guillet.
Going by the same sample data :
the main sheet
hi sanjib
i would suggest the below
1. Right Click on Cell and select Format Cells option
2. Custom category in Number tab
3. and type [$-409]dd/mmm/;@ in Type text box
On Mon, Oct 3, 2011 at 1:05 PM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
But It is not working sir,
Suggest you try this instead as the formula for currsheet. It will work for
all. Notice there is NO sheet name in the formula, just the !
=OFFSET(!$A$1,1,0,COUNT(!$A:$A),5)
From: Haseeb Avarakkan
Sent: Sunday, October 02, 2011 6:03 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
I suggest, instead that you use ONLY one sheet and filter as desired. See
attached and filter by region and then by date. to clear filters use
datafiltershow all
From: Mr excel
Sent: Monday, October 03, 2011 4:19 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Update sheets on
Hi All,
I want to be able to run queries within Excel like this:
--
mysql01 = select * from some_table
ActiveWorkbook.Worksheets.Add
With ActiveSheet.QueryTables.Add(Connection:= _
Working with the inbuilt query feature in Excel can get tricky.
Try finding the exact syntax for a MySQL database from *
http://connectionstrings.com/*
And on how to run a query from within Excel, try
*
http://www.excelfox.com/forum/showthread.php?66-Execute-SQL-From-Excel-(VBA)
*
Regards,
Sometimes, a sample workbook speaks louder than words. So would really help
in boosting your chance to get a solution is to have the expected output
also posted as a sample. That would give the volunteers here a perspective
of what the objective is.
On Mon, Oct 3, 2011 at 11:40 PM, shaneallen
Hi Yes I saw this, but I still get a General ODBC error. thank you
On Mon, Oct 3, 2011 at 1:23 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Working with the inbuilt query feature in Excel can get tricky.
Try finding the exact syntax for a MySQL database from *
I connect to Access database as well as SQL server databases using the same
method suggested by Mechanic in the SQLJuicer code. Have you tried modifying
your query with a more conventional VBA connection code snippet? If that
didn't work, did you try recording a macro while you perform the query
Yes maybe the macro recorder is a good idea, thanks!
On Mon, Oct 3, 2011 at 1:33 PM, Sam Mathai Chacko samde...@gmail.comwrote:
I connect to Access database as well as SQL server databases using the same
method suggested by Mechanic in the SQLJuicer code. Have you tried modifying
your query
Dear members,
I am proud to share that I have been re-awarded the Micrososft MVP award in
2011. My deep thanks to each group member for all your support and
contribution to this group.
I keep saying that this forum is a great community and emerging as one of
the largest forum in the world,
Chil,
Paste this code in the sheet code module of the respective sheet. Now once
any entry is made in any row of B C, it will check and display a message
if any duplicate is found.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim lngCount As Long
Dim lngLoop As Long
Dim
I don’t understand what you need There is a master sheet and no
sample sheet for your desires. My macro and the other do essentially the same
thing.
From: Mr excel
Sent: Monday, October 03, 2011 10:54 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Update
OK. I now see what you wanted which means a slight modification to my macro.
However, I also posted a STRONG suggestion to just use filters.
From: Mr excel
Sent: Monday, October 03, 2011 4:19 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Update sheets on Enter
Hi group,
*** SOLVED **
The best way to generate a connection string is to use the macro recorder
and go through the steps manually.
1. FIRST: Set up a Data Source Name (DSN)
2. Then use the macro recorder in Excel, and go to Data-Existing
Connections and choose the DSN.
3. Then
Hi
Thanx for the very practical suggestion but unfortunately the sample book is
over 10MB big and I tried to post it earlier this morning but unfortunately
my post did not appear I think due to the size of this file. I can however
see if I can post it as a text file from the Excel sheet.
Hi,
you have option to group the file...Bring the data in excel pivit..and right
clickselect group...and select group by year..
you can also group my month Quarter too..
Regards
Chethan Kumar BN
On Tue, Oct 4, 2011 at 1:32 AM, John A. Smith johnasmit...@gmail.comwrote:
Attached is
Chethan,
Thank you for your quick and enlightening response. This opens up new
avenues for me. Thank you very much!!!
John
On Mon, Oct 3, 2011 at 4:26 PM, B.N.Chethan kumar chetankumar1...@gmail.com
wrote:
Hi,
you have option to group the file...Bring the data in excel pivit..and
Excellent, exactly what I needed thank you very much Sam !!!
2011/10/3 Sam Mathai Chacko samde...@gmail.com
Chil,
Paste this code in the sheet code module of the respective sheet. Now once
any entry is made in any row of B C, it will check and display a message
if any duplicate is
Congrats Ayush :)
Regards,
Santhosh
On Tue, Oct 4, 2011 at 12:14 AM, Ayush Jain jainayus...@gmail.com wrote:
Dear members,
I am proud to share that I have been re-awarded the Micrososft MVP award in
2011. My deep thanks to each group member for all your support and
contribution to this
I would just use a data validation rule.
1. Select the range that needs to not allow duplicate entry.
2. Data/Data Tools/Data Validation on the ribbon.
3. For Validation Criteria:
ALLOW: Custom
FORMULA: =COUNTIF(A$2:A$1000,$A2)=1
(In the formula, A$2:A$1000 should be a range with the
Dear John,
You can also try...
Pivot Table Tools-Options-Group Selection...
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Tue, Oct 4, 2011 at
Can excel file such as reports be access from web or can be acccess as web
pages suppose we have 10 sheets but from some url we want to see the reports
--
syed aliya
--
--
Some important links for excel users:
1.
Thanks.very useful for beginners like me
On Mon, Jul 25, 2011 at 11:35 PM, XLS S xlst...@gmail.com wrote:
please find the attachment for basic loop concept
On Mon, Jul 25, 2011 at 5:50 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi rajan
Can you explain
below code
st = st
huhh..My COmmunication is sucking day by day...sorry guillet.i could not
communicate to you properlyHope this time i could make it clear
From the Worksheet *MAKESHEETS example *given by you.You are
adding/creating sheets based on the REP cell...Here the macro starts only
when it is
36 matches
Mail list logo