Hi,
See below links..
http://www.mrexcel.com/forum/showthread.php?t=32187
http://www.ozgrid.com/forum/showthread.php?t=69235page=1
http://www.cpearson.com/excel/vbaarrays.htm
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
On Wed,
Hi ,
See Below Links...
http://www.contextures.com/xlcondformat03.html\
http://www.dummies.com/how-to/content/applying-conditional-formatting-in-excel-2007.html
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*
On Wed, Sep 7, 2011
Brother Noorain
It good solution but make it some easiest solution instead of new user
can write this type of complex formula.
Thanks
Tariq Aziz
On 7 September 2011 21:10, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Nishant,
Please see attached sheet..
--
Thanks
Dear Sanjib,
Please see attached sheet.
On Thu, Sep 8, 2011 at 12:40 PM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Good Morning Everybody,
I want to create a macro to copy the selected data from sheets1 to sheet2
automatically
after
OK, please see attachment.
zp18
On Thu, Sep 8, 2011 at 2:22 PM, Venkat CV venkat1@gmail.com wrote:
Hi ,
See Below Links...
http://www.contextures.com/xlcondformat03.html\
http://www.dummies.com/how-to/content/applying-conditional-formatting-in-excel-2007.html
*Best Regards,*
Dear Sanjib,
Another option, you record macro with short-cut key
and paste red color code
Sub Macro10()
'
' Macro10 Macro
'
' Keyboard Shortcut: Ctrl+r
'
*If TypeName(Selection) = Range Then
Selection.Copy Sheets(Sheet2).Range(A
Sheets(Sheet2).UsedRange.Rows.Count + 1)
End
Well... The file is working fine in... you just need to save the
workbook before you open it.. So select 'Save' option instead of
'Open' (to directly open the workbook), I've used dynamic ranges for
charts, that might be the reason for why its not working...
Best of Luck... :-)
Regards
Deepak
Hi,
If it is in your reach than please think about this.. Most of the time
in a day I spend in my office, where I cannot access to Gmail but can
open Google Groups, whenever i get free time I try to solve queries
posted by other members, sometimes I get solutions and sometimes not
because of some
Dear Friends,
error message will not take any arguments
On Thu, Sep 8, 2011 at 1:31 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Sanjib,
Another option, you record macro with short-cut key
and paste red color code
Sub Macro10()
'
' Macro10 Macro
'
'
Deepak ji
I want to blink the text on the Label object on form initialize event.
On Thu, Sep 8, 2011 at 11:04 AM, Deepak Pal Singh deepaktheind...@gmail.com
wrote:
It won't work... Just want to confirm whether do you want to blink your
text in a label or in cells...??
Regards
Deepak
On
its right. it would be better if the facility incorporates to the forum
On Thu, Sep 8, 2011 at 5:02 PM, deepu deepaktheind...@gmail.com wrote:
Hi,
If it is in your reach than please think about this.. Most of the time
in a day I spend in my office, where I cannot access to Gmail but can
Dear Sanjib,
Please see updated sheet..
On Thu, Sep 8, 2011 at 5:03 PM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Dear Friends,
error message will not take any arguments
On Thu, Sep 8, 2011 at 1:31 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Sanjib,
Another
*Experience:*
2 - 5 Years
*Location:* Noida
*Education:* UG - Any Graduate - Any Specialization,Graduation Not Required PG
- Any PG Course - Any Specialization,Post Graduation Not Required
*Industry Type:* IT-Software/ Software Services
*Role:* Business Analyst
*Functional Area:* IT-Other
Job
I tried with this code. But it is not stopping the entry of the duplicate
row with the same file number.
file numbers may be given consequently 1,2,3 .,
if we enter file number 1 for twice, it would fire msgbox that it already
exists.
pls provide solution
On Wed, Sep 7, 2011 at 8:03 PM,
*Experience:* 4 - 8 Years
*Location:* Noida
*Compensation:* Rupees 1,75,000 - 2,00,000
*Education:* UG - Any Graduate - Any Specialization PG - Post Graduation Not
Required
*Industry Type:* IT-Software/ Software Services
*Role:* Finance Exec.
*Functional Area:* Accounts, Finance, Tax, CS, Audit
NO can do. Cell width for the entire column must be the same. You can merge
cells but NO one suggests that so maybe format to WRAP and raise the height of
the row
From: Shankar Bheema
Sent: Wednesday, September 07, 2011 11:33 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
*Experience:* 4 - 9 Years
*Location:* Bengaluru/Bangalore
*Education:* UG - B.B.A - Management,B.Com - Commerce PG - Any PG Course -
Any Specialization,Post Graduation Not Required
*Industry Type:* BPO/ITES
*Role:* Finance Exec.
*Functional Area:* Accounts, Finance, Tax, CS, Audit
*Posted Date:*
*Experience:* 3 - 5 Years
*Location:* Gurgaon
*Compensation:* Rupees 6,00,000 - 8,00,000
*Education:* UG - Any Graduate - Any Specialization PG - Any PG Course - Any
Specialization
*Industry Type:* Banking/Financial Services/Broking
*Role:* Analyst
*Functional Area:* Banking, Insurance
*Posted
Which columns need to be totaled?
From: anu gomathi
Sent: Thursday, September 08, 2011 12:14 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Add the multiple row values delete the
duplicate row
Hi Noorain,
Opportunity column contains the duplicate. I need to convert the
Dear Varun,
Try to use Datedif function, if you are familiar with it or just google it
you will get the solution in seconds.
On Thu, Sep 8, 2011 at 11:27 AM, VARUN CHAWLA varunchawla...@gmail.comwrote:
Can any body guide me the formula to calculate the Age in excel with months
and days.
Why cant i attach to this
On Sep 5, 3:04 pm, dguillett1 dguille...@gmail.com wrote:
Post a file
-Original Message-
From: Andy McGooner
Sent: Monday, September 05, 2011 7:56 AM
To: MS EXCEL AND VBA MACROS
Cc: amcni...@jaguarlandrover.com
Subject: $$Excel-Macros$$
Use it
=Year DATEDIF(E7,F7,y) Days DATEDIF(E7,F7,d)
On Thu, Sep 8, 2011 at 1:57 PM, VARUN CHAWLA varunchawla...@gmail.comwrote:
Can any body guide me the formula to calculate the Age in excel with months
and days.
Regards
Varun Chawla
--
Hey Varun ,
thy this
=DATEDIF(A1,TODAY(),Y) Years, DATEDIF(A1,TODAY(),YM) Months,
DATEDIF(A1,TODAY(),MD) Days
On Thu, Sep 8, 2011 at 1:57 PM, VARUN CHAWLA varunchawla...@gmail.comwrote:
Can any body guide me the formula to calculate the Age in excel with months
and days.
Dear varun,
You can use below mentioned formulas..
=DATEDIF(C8,TODAY(),y) =For Year
=DATEDIF(C8,TODAY(),ym) =For Month
=DATEDIF(C8,TODAY(),md) =For Days
On Thu, Sep 8, 2011 at 1:57 PM, VARUN CHAWLA varunchawla...@gmail.comwrote:
Can any body guide me the formula to calculate
Hi All,
Anyone is there to provide solution for this query..
Is it possible to work on other worksheet while markquee is there in sheet1.
/suresh
-- Forwarded message --
From: suresh k brave.sur...@gmail.com
Date: Wed, Sep 7, 2011 at 10:39 PM
Subject: Re: $$Excel-Macros$$ Re:
Dear varun,
There is one more formula available.
=Age is DATEDIF(C8,TODAY(),y) Years, DATEDIF(C8,TODAY(),ym)
Months and DATEDIF(C8,TODAY(),md) Days
For Example:Age is 51 Years, 8 Months and 7 Days
On Thu, Sep 8, 2011 at 1:57 PM, VARUN CHAWLA varunchawla...@gmail.comwrote:
Can any body
NO
From: suresh k
Sent: Thursday, September 08, 2011 9:49 AM
To: Excel group
Subject: Fwd: $$Excel-Macros$$ Re: Marquee in Excel
Hi All,
Anyone is there to provide solution for this query..
Is it possible to work on other worksheet while markquee is there in sheet1.
/suresh
--
Hi all,
I'm new to VBA Programming. But how o add a command button in excel without
using form.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Hi,
Need to add the value from X to DO column.
Regards
Anu
On Thu, Sep 8, 2011 at 6:11 PM, dguillett1 dguille...@gmail.com wrote:
Which columns need to be totaled?
*From:* anu gomathi anugomathi.d...@gmail.com
*Sent:* Thursday, September 08, 2011 12:14 AM
*To:*
Hi All,
Please help me with macro to populate the data from the the pivot to the
specific fields
Regards
Anu
On Wed, Sep 7, 2011 at 3:17 PM, anu gomathi anugomathi.d...@gmail.comwrote:
Hi,
Attached the File
Regards
Anu
On Wed, Sep 7, 2011 at 12:25 PM, Abhishek Jain
Dear Madhukar,
Please tyr
First step
Check Excel Option-Popular- Show Develper tab in the ribbon
Next step :
Developer-Insert-form Controls/Active X controls-Select Commond
Button
On Thu, Sep 8, 2011 at 10:25 PM, Madhukar madhukar.kalaha...@gmail.comwrote:
Hi all,
I'm new to VBA
Thanks in advance, experts!
What I have:
2 worksheets in same Excel file, each has a table (Table1 on WS1,
Table2 on WS2) with the SAME headers/type of data.
As an example (only), BOTH tables have:
Invoice#Cat1SalesCat2SalesCat3Sales
TotalSales
The only difference
Use COUNTIF to check filenumber is unique :
=COUNTIF(the filenumber column,filenumber)=0
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Bheema Shankar
Envoyé : mardi 6 septembre 2011 16:40
À : MS EXCEL AND VBA MACROS
Hi Sanjib,
You Can try Advanced filter Option in 2007
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*
On Thu, Sep 8, 2011 at 12:40 PM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Good Morning Everybody,
I want to
visit to this site:
http://office.microsoft.com/en-us/excel-help/add-a-button-and-assign-a-macro-to-it-in-a-worksheet-HP010236676.aspx
On Thu, Sep 8, 2011 at 11:55 PM, Madhukar madhukar.kalaha...@gmail.comwrote:
Hi all,
I'm new to VBA Programming. But how o add a command button in excel
Dear Group,
Please find attached sheet, it is very usefull to understand Loop in VBA
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
--
Dear Bheema,
Please see attached Sheet...
On Tue, Sep 6, 2011 at 8:10 PM, Bheema Shankar shankar.n...@gmail.comwrote:
I made a userform. linked it with the datasheet. the filenumber acts
as a bridge between userform and datasheet. I have to make the file
number unique in excel.
is it possible to split the cell column into
On Thu, Sep 8, 2011 at 6:05 PM, dguillett1 dguille...@gmail.com wrote:
NO can do. Cell width for the entire column must be the same. You can
merge cells but NO one suggests that so maybe format to WRAP and raise the
height of the row
*From:*
Good morning to all,
Is the crystal report software which will use for report generation in
Visual Basic 6 will work with VBA Excel ? If so, I request to you all,
provide me sample project to understand.
--
--
Some
See below link if it help to u..
http://softwaretopic.informer.com/how-to-use-crystal-report-with-vba/
On Fri, Sep 9, 2011 at 10:42 AM, Shankar Bheema shankar.n...@gmail.comwrote:
Good morning to all,
Is the crystal report software which will use for report generation in
Visual Basic 6
Hi Bheema,
See below image and Try Data Validation and use custom and formula as *
=COUNTIF(C:C,C1)=1*
[image: image.png]
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*
On Tue, Sep 6, 2011 at 8:10 PM, Bheema Shankar
Hi ,
See below links if Helps
http://forums.esri.com/Thread.asp?c=93f=992t=67019
http://www.codeguru.com/forum/showthread.php?t=356836
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*
On Fri, Sep 9, 2011 at 10:42 AM, Shankar
Hi,
Thanks a lot for the response.
Regards
Anu
On Thu, Sep 8, 2011 at 11:10 PM, dguillett1 dguille...@gmail.com wrote:
Try using datasubtotal as shown on the attached for col D
*From:* anu gomathi anugomathi.d...@gmail.com
*Sent:* Thursday, September 08, 2011 12:11 PM
*To:*
43 matches
Mail list logo