Welcome Janki,
As for your query www.chandoo.org would be a good place to start learning.
There are a lot of other websites as well. If you have specific questions
do post them. A lot of people here would be willing to help.
--
Warm regards,
Anand Kumar
08987396594
On Mon, Apr 13, 2015 at 12
http://www.tushar-mehta.com/publish_train/xl_vba_cases/0301-dashboard-conditional_shape_colors.htm
On this link you can find a detailed tutorial on conditional coloring. Hope
this helps...
--
Warm regards,
Anand Kumar
On Mon, Mar 9, 2015 at 8:31 PM, Swapnil Palande palande.swapni
We can force the users to enable macros.
1. As 1st step code can be put up to enable macros else file would not open.
2. As 2nd step we can use macro to determine if the file has expired.
This way the desired functionality can be achieved.
Warm Regards,
Anand Kumar
On Saturday, 27 July 2013 14
to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
Warm regards,
Anand Kumar
Data Analyst (Research)
Datamation CS
09990525998
--
Are you =EXP(E:RT
Dear Prince,
Could you please share code for splitting data into multiple sheets based
on column.
Regards,
Anand Kumar
On Thursday, 20 December 2012 12:39:35 UTC+5:30, Pravin Gunjal wrote:
Hi Friends,
I have an excel file containing almost 50 sheets in it and would like to
gather all
Dear Noorain,
In your code the statement Exit Sub comes right before End Sub. It is also
not based on any condition being tested and no Error Handling is there so
Go To is also not being used.
Could you please explain how this code is working?
Warm Regards,
Anand Kumar
On Thursday, 20
Hi,
It would be a lot better if we could see the calenders submitted. If
required I can provide web space to host these files too.
Warm regards,
Anand Kumar
On Sunday, 18 November 2012 21:53:29 UTC+5:30, Ayush Jain wrote:
Dear members,
Let's get set for the new year 2013
Here is inviting
made changes
are marked in Pink color.
Hope that helps,
Anand Kumar
On Sunday, 2 December 2012 00:43:56 UTC+5:30, Hemantpokharkar wrote:
Dear All
Kindly help me to solve the problem
I have a excel sheet were i have required a formula which will show me the
credit card month or the cycle
made changes
are marked in Pink color.
Hope that helps,
Anand Kumar
On Sunday, 2 December 2012 00:43:56 UTC+5:30, Hemantpokharkar wrote:
Dear All
Kindly help me to solve the problem
I have a excel sheet were i have required a formula which will show me the
credit card month or the cycle
Dear Neeraj,
If you are using Excel 2007 or above
1. For random dates use :-
*=DATE(2012,RANDBETWEEN(1,12),RANDBETWEEN(0,31))*
2. For random time Eugene Bernard's solution will work perfectly
Hope that helps,
Anand Kumar
On Saturday, 1 December 2012 10:48:04 UTC+5:30, neeraj chauhan wrote
Dear Rohan,
The code seems to be correct. You need to add some libraries it seems.
Regards,
Anand
On Friday, 6 July 2012 10:11:16 UTC+5:30, Rohan Young wrote:
Dear Ashish Ji,
thanks but i m not getting the result, can you please send me the add
in or anything else for it
regds
Hi,
I am Anand Kumar. Aged 31 years and working in fields of data analysis for
past aprrox 5 years. I have my PGDM in Marketing and hold a ISO 9000 lead
auditor qualifications.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
Hi,
I have a data set where Name, Address, STD Codes, Phone Number, Mobile No.
all are in a single column for different people. I want to have names in
first column, Address in next column and std codes, phone numbers in next
columns.
How to do it using VBA?
Sample data:
Anil Kumar Gupta
everytime it
runs you may want to modify that section too
Copy paste the code in VBA editor. Go to ToolsReferences and find
Microsoft Office Object Library and Microsoft Office Outlook Library tick
mark to add them into references and run the code to test it.
Hope that helps,
Anand Kumar
Public Sub
Hi Atul,
Rank function seems to work perfectly fine here Copied the name of
Institutions to A column and percentages to column B in C2 the formula was
=RANK(B2,$B$2:$B$11,0) now drag the formula till C11 you get the desired
result.
Warm regards,
Anand Kumar
On Wednesday, 21 March 2012
---
Anand Kumar wants to stay in better touch using some of Google's coolest new
products.
If you already have Gmail or Google Talk, visit:
http://mail.google.com/mail/b-60943ae763-3b0a750245-hfaE1gnqrmFYgOTVLQA-LcGRqXs
You'll
16 matches
Mail list logo