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 wrote:
> Hi Sm
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
ed this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-mac
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
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
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
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
ils. Columns where I have 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 wi
ils. Columns where I have 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 wi
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
.
Regards,
Anand Kumar
On Saturday, May 19, 2012 12:20:15 PM UTC+5:30, Anand Kumar wrote:
>
> 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 n
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 T
everytime it
runs you may want to modify that section too
Copy paste the code in VBA editor. Go to Tools>References 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
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
Y
17 matches
Mail list logo