Re: $$Excel-Macros$$ Re: Introduce Yourself !!
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:32 PM, Vaibhav Joshi wrote: > Hi Janaki > > welcome to Excel Macros.. > > If you have any query start separate thread.. > > Cheers!! > > On Sat, Apr 11, 2015 at 4:46 PM, Janaki Dalvi > wrote: > >> Thanks Ayush for giving us this forum, Have been through some of the >> posts and it has been a lot of help thus far. To introduce myself, I am >> Janaki, working as a Business Analyst for a IT firm here in Mumbai. >> Recently i have been working on a project which involves a lot of reporting >> and hence would like more insights into dynamic dashboard reporting. I've >> been through some of the earlier posts, but what i need is a website that >> would help me to get started from scratch as am not "typically" from a IT >> background >> >> Looking forward for your suggestion >> >> Regards, >> Janaki >> >> >> >> On Saturday, June 9, 2012 at 12:51:59 AM UTC+5:30, Ayush Jain wrote: >>> >>> Hey all new and current posters, >>> >>> Welcome to excel group,one of the largest online community of excel Fans! >>> >>> I hope you enjoy your time here & find this forum to be a friendly and >>> knowledgeable community. Please feel free to post a small introduction, a >>> friendly hello or tell us a bit about yourself. Why not tell us where are >>> you from, what you do, what your interests are, how old you are, which is >>> your favourite excel site or blog is or anything else that comes to mind! >>> >>> Thanks for your time >>> Ayush Jain >>> Group Manager >>> Microsoft MVP >>> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received 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-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received 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-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E
Re: $$Excel-Macros$$ Shape Colors (VBA)
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 Smith,
>
> PFA excel. Press Ctrl + q to run macro.
>
> Hope this will solve your problem.
>
> Thanks and regards,
>
> Swapnil Suresh Palande.
>
> On Mon, Mar 9, 2015 at 6:59 PM, Iain Smith wrote:
>
>> Hi. If anyone can assist.
>>
>> I have a map of the world in individual shapes per country, each named.
>> I have a sales spreadsheet which, through Pivot Tables, converts the
>> sales into percentages.
>> Using this, conditional formatting colors the cells according to
>> percentage.
>> This will change on a regular basis, so needs some automation.
>> I need to first get the RGB color information from each of the cells and
>> change the color of the country to match.
>>
>> I have been playing around with Module:
>> With ActiveSheet
>> .Shapes("USA").Fill.ForeColor.RGB = RGB(43, 136, 154)
>> .Shapes("UK").Fill.ForeColor.RGB = RGB(167, 227, 28)
>> 'and so on
>> End With
>>
>> Can anyone assist? Knowledge of VBA is nil, but willing to learn
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received 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-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received 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-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their li
$$Excel-Macros$$ Re: how to make a file expire after a period of time.
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:25:42 UTC+5:30, pappu wrote: > > Hi, > > how to make a file expire after a period of time. > > > regards > Kannan V > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received 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-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Re: array formula
Hi,
To work on different sheets you don't always need array formulas. It is
possible that you need nested formulas for your work. e.g.
If you click on a cell containing formula and see something like:
{=SUM(A1:B100)}
This is an array formula. It is identified by the curly bracket in formula
"{ }". To enter formula as an array formula you type a formula and instead
of pressing enter you press Ctrl + Shift + Enter hence the name CSE
formulas.
If you click on a cell containing formula and see something like:
=IF(VLOOKUP(A1,$B$1:$D$100,3,0)<3,SUM(A1:A3),A1)
This is a nested formula which contains many formulas nested inside one
another. Nesting one formula into another is often useful and in most of
the cases you use this only.
In case you need array functions for your work you can search Google for
array functions and you will find many tutorials on the topic.
Warm Regards,
Anand
On Wed, Apr 3, 2013 at 8:44 AM, Lalit Mohan Pandey wrote:
> Just write your formula and comfirm it with CSE.
>
> Or you can go through below link:
> http://www.cpearson.com/excel/ArrayFormulas.aspx
>
> http://office.microsoft.com/en-in/excel-help/introducing-array-formulas-in-excel-HA001087290.aspx
>
> http://www.excelfox.com/forum/f2/count-consecutive-value-range-using-formula-391/
>
> On Tuesday, 2 April 2013 22:33:07 UTC+5:30, kushy wrote:
>>
>> I am using multiple sheets in a file. I want to know how to write array
>> formulas(those that are combination of formulas or have a lot of brackets).
>> any simple lead with basic formulas would be very fulfilling.
>>
>> --
>> Regards Always,
>>
>> Kushlesh Sharma
>> 9907517169
>>
>>
>>
>> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received 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-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) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received 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-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.
Re: $$Excel-Macros$$ Combine all sheets in a single sheet
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 December 2012 12:45:09 UTC+5:30, NOORAIN ANSARI wrote:
>
> Dear Pravin,
>
> Pls try, hope it will help to you.
>
> Sub collatedata()
> Dim i As Integer
> Dim j As Integer
> Dim rng As Range
> Dim sh As Worksheet
> Set sh = Sheets.Add
> sh.Move after:=Sheets(Sheets.Count)
> sh.Name = "Mastersheet"
> Sheets(1).Range("A1:C1").Copy sh.Cells(1, 1)
> i = 1
> Do While i <= Sheets.Count - 1
> j = sh.Cells(Rows.Count, "A").End(xlUp).Row + 1
> Sheets(i).Range("a2:c" & Sheets(i).Cells(Rows.Count,
> 3).End(xlUp).Row).Copy sh.Cells(j, 1)
> i = i + 1
> Loop
> Exit Sub
> End Sub
>
>
> On Thu, Dec 20, 2012 at 12:39 PM, Pravin Gunjal
> > wrote:
>
>> Hi Friends,
>>
>> I have an excel file containing almost 50 sheets in it and would like to
>> gather all those data in a single sheet one after one (column headings may
>> be different)
>>
>> Is there any way/VB code which can do it faster. Thank you,
>>
>> Regards
>> Pravin Gunjal.
>>
>> --
>> Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> To unsubscribe from this group, send email to
>> excel-macros...@googlegroups.com .
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
>
>
> --
> With Regards,
> Noorain Ansari
> http://
> <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com>
> http://
> <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com><http://accesssqclinic.blogspot.in/>
>
>
>
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Re: Combine all sheets in a single sheet
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 those data in a single sheet one after one (column headings may > be different) > > Is there any way/VB code which can do it faster. Thank you, > > Regards > Pravin Gunjal. > > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Re: Dynamic calendar quiz : There is a prize for the winner.
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 you to participate in a quiz to make calendar for the new > year in excel. > > There are some rules to be followed : > 1) No macros to be used and should be formula based, only xlsx file to be > submitted. > 2) The calendar should be dynamic for any year, if you change the year , > the calendar should update automatically. > 3) The calendar should be in one sheet only > 4) The leap year should be considered. > 5) Last date to submit the calendar is 2nd December 2012 > 6) Make sure you create calendar yourself and do not download from anywhere > 7) Send your calendar to my email id - jainayush85[at]gmail.com. If you > post in the forum, there are chances people take reference from your > calendar. > 8) Once you send the calendar, you can reply to this post for the > confirmation. > > The following will add points to your calendar : > 1) Highlight current date > 2) Highlight bank/public holidays > 3) Calendar formatting and user friendliness > > There is a prize for the best calendar and recognition for the runner up. > Sponsors for the prize are invited, you can contact me if you want to be > sponsor. > > Looking forward to your active participation in the quiz. Let me know if > you have any queries. > > Many thanks for your contribution to this group. Keep it up > > Regards > Ayush Jain > Group Manager -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Re: Heplp Required
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 Experts, > > i want randomly time and date like > > > 10:43 AM 10:50 AM 10:05 AM 11:10 AM 1:07 PM > 20-Nov-12 19-Nov-12 2-Nov-12 11-Nov-12 6-Nov-12 24-Nov-12 18-Nov-12 > 27-Nov-12 4-Nov-12 1-Nov-12 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Re: credit card due date formula
Dear Hemant, 1. In your second column you can use EOMONTH() to find the last date of the month. Instead of the long function you are using. (Useable with version 2007) 2. As you have 3 different cases for finding due date you should use 3 different columns. 3. I have used the following function to get desired results based on the data provided in E column (Credit card date) *=IF(ISNUMBER(E2),TEXT(E2,"dd/mm/"),IF(ISTEXT(E2),E2,TEXT(C2,"mmm")))* 4. Some cleaning of data might be needed as some of your data is entered as text. 5. See the attached sheet for details. 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 will show me the > credit card month or the cycle or the due date. > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. credit cARD.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: credit card due date formula
Dear Hemant, 1. In your second column you can use EOMONTH() to find the last date of the month. Instead of the long function you are using. (Useable with version 2007) 2. As you have 3 different cases for finding due date you should use 3 different columns. 3. I have used the following function to get desired results based on the data provided in E column (Credit card date) *=IF(ISNUMBER(E2),TEXT(E2,"dd/mm/"),IF(ISTEXT(E2),E2,TEXT(C2,"mmm")))* 4. Some cleaning of data might be needed as some of your data is entered as text. 5. See the attached sheet for details. 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 will show me the > credit card month or the cycle or the due date. > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. credit cARD.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Mails IDs from Outlook
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
>
> ROHAN
>
> On Thu, Jul 5, 2012 at 10:58 PM, ashish koul
> wrote:
> > try this see if it helps
> >
> > Sub Scan_my_outlook_inbox()
> > 'TOOLS ->Refrence -> microsoft outlook
> > 'declare outlook objects
> > Dim olapp As Outlook.Application
> > Dim olappns As Outlook.Namespace
> > Dim oinbox As Outlook.Folder
> > Dim oitem As Outlook.MailItem
> > Dim myItems As Outlook.Items
> > Dim i As Long
> > i = 2
> > 'set outlook objects
> > Set olapp = New Outlook.Application
> > Set olappns = olapp.GetNamespace("MAPI")
> > ' it will scan inbox folder only
> > Set oinbox = olappns.GetDefaultFolder(olFolderInbox)
> > ' sort emails on recieved basis
> > Set myItems = oinbox.Items
> > myItems.Sort "[Received]", True
> >
> > 'loop through all unread emails
> >
> > For Each oitem In myItems
> > Sheets("Inbox Scan").Cells(i, 1).Value = oitem.SenderName
> > Sheets("Inbox Scan").Cells(i, 2).Value =
> oitem.SenderEmailAddress
> > 'Sheets("Inbox Scan").Cells(i, 3).Value = oitem.Subject
> > 'Sheets("Inbox Scan").Cells(i, 4).Value = oitem.Body
> > 'Sheets("Inbox Scan").Cells(i, 5).Value = oitem.ReceivedTime
> > i = i + 1
> > Next
> > End Sub
> >
> >
> >
> >
> > On Thu, Jul 5, 2012 at 4:39 PM, Rohan Young
> wrote:
> >>
> >> Dear Sanjib,
> >>
> >> Its not working & improting i need to import all Mail IDs from My Sent
> >> & Inbox Folder, i need any macro for this
> >>
> >> thanks
> >>
> >>
> >> On Thu, Jul 5, 2012 at 4:01 PM, Sanjib Chatterjee
> >> wrote:
> >> > Just follow follow the link
> >> >
> >> > http://support.microsoft.com/kb/295664
> >> >
> >> >
> >> > On Thu, Jul 5, 2012 at 3:52 PM, Rohan Young
> >> > wrote:
> >> >>
> >> >> Dear Group,
> >> >>
> >> >> how can i get all mail IDs from my outlook to excel to make a list
> of
> >> >> all IDs and Co., please help me out
> >> >>
> >> >> Thanks & Regds
> >> >>
> >> >> ROHAN
> >> >>
> >> >> --
> >> >> FORUM RULES (986+ members already BANNED for violation)
> >> >>
> >> >> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please
> >> >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice
> >> >> will
> >> >> not get quick attention or may not be answered.
> >> >>
> >> >> 2) Don't post a question in the thread of another member.
> >> >>
> >> >> 3) Don't post questions regarding breaking or bypassing any security
> >> >> measure.
> >> >>
> >> >> 4) Acknowledge the responses you receive, good or bad.
> >> >>
> >> >> 5) Cross-promotion of, or links to, forums competitive to this
> forum
> >> >> in
> >> >> signatures are prohibited.
> >> >>
> >> >> NOTE : Don't ever post personal or confidential data in a workbook.
> >> >> Forum
> >> >> owners and members are not responsible for any loss.
> >> >>
> >> >>
> >> >>
> >> >>
> --
>
>
> >> >> To post to this group, send email to excel-macros@googlegroups.com
> >> >>
> >> >> To unsubscribe, send a blank email to
> >> >> excel-macros+unsubscr...@googlegroups.com
> >> >
> >> >
> >> >
> >> >
> >> > --
> >> > -
> >>
> >> --
> >> FORUM RULES (986+ members already BANNED for violation)
> >>
> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will
> >> not get quick attention or may not be answered.
> >>
> >> 2) Don't post a question in the thread of another member.
> >>
> >> 3) Don't post questions regarding breaking or bypassing any security
> >> measure.
> >>
> >> 4) Acknowledge the responses you receive, good or bad.
> >>
> >> 5) Cross-promotion of, or links to, forums competitive to this forum
> in
> >> signatures are prohibited.
> >>
> >> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum
> >> owners and members are not responsible for any loss.
> >>
> >>
> >>
> --
>
>
> >> To post to this group, send email to excel-macros@googlegroups.com
> >>
> >> To unsubscribe, send a blank email to
> >> excel-macros+unsubscr...@googlegroups.com
> >
> >
> >
> >
> > --
> > Regards
> >
> > Ashish Koul
> > http://www.excelvbamacros.com/
> > http://www.accessvbamacros.com/
> >
> >
> > P Before printing, think about the environment.
> >
> >
> >
> > --
> > FORUM RULES (986+ members already BANNED for violation)
> >
> > 1) Use concise, accurate thread titles. Poor thread titles, li
$$Excel-Macros$$ Re: Introduce Yourself !!
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 titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Re: Converting from a single column to different rows
Hi, Please find attached data file. The first sheet contains the data as it is and sheet 2 has the data in format I need it to be. @Don Gulliet: Manual copy paste with transpose is what I am doing right now Sir !! (and it is too tiresome a task). Hope this helps in suggesting a solution. 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 next column and std codes, phone numbers in next > columns. > How to do it using VBA? > > Sample data: > > Anil Kumar Gupta T-510/F23c, Gali No-2,Baljeet Nagar New Delhi STD: 0 > Phone: > 0 Fax: 0 Mobile: 0 Email: Agency Code: 10079311 > > Expected Result: > Anil Kumar Gupta T-510/F23c, > > Gali No-2,Baljeet Nagar New Delhi STD > Phone > Fax > Mobile > Email Agency Code: 10079311 > 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 next column and std codes, phone numbers in next > columns. > How to do it using VBA? > > Sample data: > > Anil Kumar Gupta T-510/F23c, Gali No-2,Baljeet Nagar New Delhi STD: 0 > Phone: > 0 Fax: 0 Mobile: 0 Email: Agency Code: 10079311 > > Expected Result: > Anil Kumar Gupta T-510/F23c, > > Gali No-2,Baljeet Nagar New Delhi STD > Phone > Fax > Mobile > Email Agency Code: 10079311 > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com sample data.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Converting from a single column to different rows
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-510/F23c, Gali No-2,Baljeet Nagar New Delhi STD: 0 Phone: 0 Fax: 0 Mobile: 0 Email: Agency Code: 10079311 Expected Result: Anil Kumar Gupta T-510/F23c, Gali No-2,Baljeet Nagar New Delhi STD Phone Fax Mobile Email Agency Code: 10079311 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Re: Need a macro for Out look
Hi,
Find the code below ... this would read the necessary things from Outlook
inbox into Excel sheet. You will have to do some modifications to suit your
own need. e.g. the code reads more than the subject of mail and sending
date you may want to delete them and it creates a new sheet 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 Sub ReadOutlook()
Dim olApp As Outlook.Application
Dim olNamespace As Outlook.Namespace
Dim olItem As MailItem
Dim i As Integer
Dim olInbox As Outlook.MAPIFolder
Dim olFolder As Outlook.MAPIFolder
Dim lngCol As Long
Set olApp = New Outlook.Application
Set olNamespace = olApp.GetNamespace("MAPI")
Set olInbox = olNamespace.GetDefaultFolder(olFolderInbox)
Worksheets.Add
i = 2
For Each olItem In olInbox.Items
Cells(i, 1) = olItem.SenderName ' Sender
Cells(i, 2) = olItem.Subject ' Subject
Cells(i, 3) = olItem.ReceivedTime ' Received
Cells(i, 4) = olItem.ReceivedByName ' Recepient
Cells(i, 5) = olItem.UnRead ' Unread?
i = i + 1
Next
Range("F1").Select
ActiveCell.FormulaR1C1 = "=COUNTA(C[-5])"
Calculate
Cells(1, 1) = "Sender"
Cells(1, 2) = "Subject"
Cells(1, 3) = "Received"
Cells(1, 4) = "Recepient"
Cells(1, 5) = "Unread?"
For i = 1 To 5
Columns(i).AutoFit
Next i
Set olInbox = Nothing
Set olNamespace = Nothing
Set olApp = Nothing
End Sub
On Monday, 26 March 2012 00:19:20 UTC+5:30, nike wrote:
>
> Dear Team,
>
> I want a macro for message names export to excel with received dates.
>
>
> thanks in advance
> Simha
>
>
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Re: Help to find position of a particular number in a given data set
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 02:54:21 UTC+5:30, Atul wrote: > > > Hi, > > I need help to find position of a particular number in a given data > set. Please refer to the table below. > >*Fin. Inst.* *Rates in %* A 10 B 11 C 12 D 11 E 6 F 9 G 8 H 8 I 9 J 7 > > In the above example, Rates are given for each financial institution. In > descending order,the rate 12% is at the 1st position,11% is 2nd highest and > so on. While using function LARGE or SMALL, we need to assign kth position > to get the required result. > > I need to find (kth) position of given rate from the list, ignoring the > duplicate items. Going back to the above example, 11% will be the second > highest rate, 10% being the third highest rate and so on. Please let me > know the function or combination of functions. > > Thank you for your help and time. > > Regards, > > *Atul Patel* > H: 905 785 8324 > C: 647 898 4074 > atul_pate...@yahoo.com > > Good to know you ! > > > *Atul Patel* > H: 905 785 8324 > C: 647 898 4074 > atul_pate...@yahoo.com > > Good to know you ! > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Anand Kumar wants to chat
--- 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 need to click this link to be able to chat with Anand Kumar. To get Gmail - a free email account from Google with over 2,800 megabytes of storage - and chat with Anand Kumar, visit: http://mail.google.com/mail/a-60943ae763-3b0a750245-hfaE1gnqrmFYgOTVLQA-LcGRqXs Gmail offers: - Instant messaging right inside Gmail - Powerful spam protection - Built-in search for finding your messages and a helpful way of organizing emails into "conversations" - No pop-up ads or untargeted banners - just text ads and related information that are relevant to the content of your messages All this, and its yours for free. But wait, there's more! By opening a Gmail account, you also get access to Google Talk, Google's instant messaging service: http://www.google.com/talk/ Google Talk offers: - Web-based chat that you can use anywhere, without a download - A contact list that's synchronized with your Gmail account - Free, high quality PC-to-PC voice calls when you download the Google Talk client We're working hard to add new features and make improvements, so we might also ask for your comments and suggestions periodically. We appreciate your help in making our products even better! Thanks, The Google Team To learn more about Gmail and Google Talk, visit: http://mail.google.com/mail/help/about.html http://www.google.com/talk/about.html (If clicking the URLs in this message does not work, copy and paste them into the address bar of your browser). -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
