Re: $$Excel-Macros$$ macro: delete base on table
Hi Guys,
thanks a lot for your help.
regards,
Pawel
From: Rajan_Verma
To: excel-macros@googlegroups.com
Sent: Thursday, October 4, 2012 6:32 PM
Subject: FW: $$Excel-Macros$$ macro: delete base on table
Here is thread on this Solution , Please visit
http://www.excelfox.com/forum/f20/delete-list-contain-matching-second-list-589/
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From:Rajan_Verma [mailto:rajanverma1...@gmail.com]
Sent: 04 October 2012 9:58
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ macro: delete base on table
Hi,
Use this Code, Just Create Two Name Ranges,
Sheet1!B2=”rngRange”
Sheet2!B2 =” MapDelete”
Sub ExcludeFromList()
Dim objDicMap As Object
Dim VarArrData
Dim VarArrResult
Dim rngCell As Range
Dim lngCOunt As Long
VarArrData = Intersect(Range("rngRange").CurrentRegion,
Range("rngRange").CurrentRegion.Offset(1))
Set objDicMap = CreateObject("Scripting.Dictionary") ' Dictionary Object
get Mapping
'Filling Dictionary
For Each rngCell In Intersect(Range("MapDelete").CurrentRegion,
Range("MapDelete").CurrentRegion.Offset(1))
If Not objDicMap.exists(rngCell.Value) Then objDicMap.Add
rngCell.Value, rngCell.Value
Next rngCell
'Filling Result Array From Data List which would not Include Mapping Data
For lngCOunt = LBound(VarArrData) To UBound(VarArrData)
If Not objDicMap.exists(VarArrData(lngCOunt, 1)) Then
If Not IsArray(VarArrResult) Then
ReDim VarArrResult(0 To 0)
VarArrResult(0) = VarArrData(lngCOunt, 1)
Else
ReDim Preserve VarArrResult(UBound(VarArrResult) + 1)
VarArrResult(UBound(VarArrResult)) = VarArrData(lngCOunt, 1)
End If
End If
Next lngCOunt
'Clear Old List
Range("rngRange").CurrentRegion.Offset(1).Clear
'Replace with new list
Range("rngRange").Offset(1).Resize(UBound(VarArrResult)).Value =
Application.Transpose(VarArrResult)
Set objDicMap = Nothing
Set rngCell = Nothing
End Sub
Keep Excelling J
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of pawel lupinski
Sent: 04 October 2012 9:30
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ macro: delete base on table
Hi All,
I'd like to ask you for favour, can you help me with these. I have a table
"code" with codes. From this table I'd like to excclude all codes for table "to
delete" (tab table). Right now I'm using "or" function in vba, but when I want
to add something, each time I need to open VB and change it. Is there any way
that I can manage it from "to delete" table?
Thanks
Pawel
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ 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.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or 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.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ 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.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or 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 pos
$$Excel-Macros$$ Remove All Special Characters
Dear All, I need to clean all special characters from a my data. Please suggest any formula or macro to remove them. Please find attached sheet. Thanks Karan Singh -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. Remove All Special Characters.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ St id Reqd on Max Date
Hi, You can try pivot table. see below Snapshot. Name Date ID Name1 01-10-2012 9558 02-10-2012 9565 03-10-2012 9564 04-10-2012 9563 05-10-2012 9562 06-10-2012 9561 07-10-2012 9559 Name2 01-10-2012 9559 02-10-2012 9558 03-10-2012 9565 04-10-2012 9564 05-10-2012 9563 06-10-2012 9562 07-10-2012 9560 Name3 01-10-2012 9560 02-10-2012 9559 03-10-2012 9558 04-10-2012 9565 05-10-2012 9564 Name4 01-10-2012 9561 02-10-2012 9560 03-10-2012 9559 04-10-2012 9558 05-10-2012 9565 06-10-2012 9563 07-10-2012 9561 Name5 01-10-2012 9562 02-10-2012 9561 03-10-2012 9560 04-10-2012 9559 05-10-2012 9558 06-10-2012 9564 Name6 01-10-2012 9563 02-10-2012 9562 03-10-2012 9561 04-10-2012 9560 05-10-2012 9559 06-10-2012 9565 07-10-2012 9562 Name7 01-10-2012 9564 02-10-2012 9563 03-10-2012 9562 04-10-2012 9561 05-10-2012 9560 06-10-2012 9558 07-10-2012 9563 Grand Total Regards, Kuldeep Singh On Fri, Oct 5, 2012 at 11:51 AM, Manoj Kumar wrote: > Dear Viper, > > Please can you solve it without erry..please help.. > > > On Fri, Oct 5, 2012 at 11:47 AM, The Viper wrote: > >> pfa >> >> >> On Fri, Oct 5, 2012 at 10:58 AM, Manoj Kumar >> wrote: >> >>> Dear Expert, >>> >>> >>> Request you to kindly help me on this matter... >>> Please find the attachment.. >>> >>> I want id witch has on max dateeg:- if "name1" max date is 3-Oct it >>> show 9564 >>> >>> >>> >>> >>> Regard >>> Manoj >>> >>> -- >>> Join official facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES (1120+ 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. >>> >>> 6) Jobs posting is not allowed. >>> >>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >>> >>> NOTE : Don't ever post personal or 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. >>> >>> >>> >> >> >> >> -- >> *Great day,* >> *viper* >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ 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. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or 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. >> >> >> > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ 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. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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" gr
Re: $$Excel-Macros$$
Hello Asish, Thanks its working. :) On Thu, Oct 4, 2012 at 4:51 PM, ashish koul wrote: > IF(ISERROR(B2-A2),"",B2-A2) > > format as [mm] > > > On Thu, Oct 4, 2012 at 6:51 PM, Chandra Shekar < > chandrashekarb@gmail.com> wrote: > >> Hi, >> >> Could you please let me know how to ignore error in the rows? >> >> Regards, >> >> Chandra Shekar B >> >> On Wed, Oct 3, 2012 at 4:59 PM, Rajan_Verma wrote: >> >>> *Date2 Must be greater than Date1* >>> >>> * * >>> >>> * * >>> >>> *Regards* >>> >>> *Rajan verma* >>> >>> *+91 7838100659 [IM-Gtalk]* >>> >>> * * >>> >>> *From:* excel-macros@googlegroups.com [mailto: >>> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar >>> *Sent:* 03 October 2012 6:59 >>> *To:* excel-macros@googlegroups.com >>> *Subject:* Re: $$Excel-Macros$$ >>> >>> ** ** >>> >>> Hello, >>> >>> >>> >>> I tried the formula still its have some issues could you please check it >>> out. >>> >>> >>> >>> Thanks in advance. >>> >>> >>> >>> >>> >>> >>> >>> On Wed, Oct 3, 2012 at 3:13 PM, Rajan_Verma >>> wrote: >>> >>> * * >>> >>> * * >>> >>> *=B2-A2* >>> >>> * * >>> >>> *Apply [m] as custom format* >>> >>> * * >>> >>> *Regards* >>> >>> *Rajan verma* >>> >>> *+91 7838100659 [IM-Gtalk]* >>> >>> * * >>> >>> *From:* excel-macros@googlegroups.com [mailto: >>> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar >>> *Sent:* 03 October 2012 6:34 >>> *To:* excel-macros@googlegroups.com >>> *Subject:* $$Excel-Macros$$ >>> >>> >>> >>> Hello, >>> >>> >>> >>> Could you please help me in the attached file. >>> >>> >>> >>> Thanks in advance. >>> >>> >>> >>> Regards, >>> >>> >>> >>> Chandra Shekar B >>> >>> >>> >>> >>> >>> -- >>> Join official facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES (1120+ 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. >>> >>> 6) Jobs posting is not allowed. >>> >>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >>> >>> NOTE : Don't ever post personal or 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. >>> >>> >>> >>> -- >>> Join official facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES (1120+ 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. >>> >>> 6) Jobs posting is not allowed. >>> >>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >>> >>> NOTE : Don't ever post personal or 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. >>> >>> >>> >>> ** ** >>> >>> -- >>> Join official facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES (1120+ 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, o
Re: $$Excel-Macros$$ St id Reqd on Max Date
Dear Viper, Please can you solve it without erry..please help.. On Fri, Oct 5, 2012 at 11:47 AM, The Viper wrote: > pfa > > > On Fri, Oct 5, 2012 at 10:58 AM, Manoj Kumar > wrote: > >> Dear Expert, >> >> >> Request you to kindly help me on this matter... >> Please find the attachment.. >> >> I want id witch has on max dateeg:- if "name1" max date is 3-Oct it >> show 9564 >> >> >> >> >> Regard >> Manoj >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ 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. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or 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. >> >> >> > > > > -- > *Great day,* > *viper* > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ 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. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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. > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
Re: $$Excel-Macros$$ St id Reqd on Max Date
pfa On Fri, Oct 5, 2012 at 10:58 AM, Manoj Kumar wrote: > Dear Expert, > > > Request you to kindly help me on this matter... > Please find the attachment.. > > I want id witch has on max dateeg:- if "name1" max date is 3-Oct it show > 9564 > > > > > Regard > Manoj > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ 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. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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. > > > -- *Great day,* *viper* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. Max Date St ID.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Macro for convert to Million
Dear Group, I require the Macro in Add-in form which convert the full amount into the million e.g. if I want to convert the figure 1,000,000 to million it will show as 1.000. Procedure should 1,000,000 enter as "1,000,000mm" it automatically convert the figure as 1.000. Regards, Aamir Shahzad -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
$$Excel-Macros$$ Re: Introduce Yourself !!
Hello My name is Radek Jurecek, I'm from Czech Republic. I work as IT programmer (ASP.NET, C#). I developing own a add-ins (Czech language). One of the add-ins I try translate to English. See http://rjurecek.cz/rjtoolsEn.htm -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
$$Excel-Macros$$ St id Reqd on Max Date
Dear Expert, Request you to kindly help me on this matter... Please find the attachment.. I want id witch has on max dateeg:- if "name1" max date is 3-Oct it show 9564 Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. Max Date St ID.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Re: Need help
Array Formula
=IFERROR(SMALL(IF(ISERROR(MATCH(ROW(INDIRECT(MIN(g)&":"&MAX(g))),g,0)),ROW(INDIRECT(MIN(g)&":"&MAX(g))),""),ROW(INDIRECT("1:"&COUNT(IF(ISERROR(MATCH(ROW(INDIRECT(MIN(g)&":"&MAX(g))),g,0)),ROW(INDIRECT(MIN(g)&":"&MAX(g))),""),"")
g is your list name.
Rajan
On Thursday, 4 October 2012 19:14:56 UTC+5:30, karthik n wrote:
>
> Hi Team,
>
> Please help in the attachment file
>
> Regards
> karthik.N
>
>
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ 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.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or 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.
$$Excel-Macros$$ Re: Macro to create Pivot Table for each sheet in the workbook
Hello Ashsh, I posted my query and dont see it Did it get through. Rashid On Monday, October 1, 2012 9:11:00 PM UTC+4, prkhan56 wrote: > I posted this yesterday...it seems it did not get through..so posting once > again > > Hello All, > > I am using Excel 2010. I have a List of Names in Sheet name “List” > > > I have attached a file with two modules. > > > *Module1* Macro creates separate sheet with the names listed in the sheet > name List and copies Sheet Data for each name. > > > *Module2* makes Pivot Table on the Active Sheet. > > > My requirement is to amend the *Module2* as follows: > > 1) * **Module2* should loop through each name and create Pivot Table for > each sheet created and name it viz. Pivot created for Name1 should be > PivotName1, Pivot created for Name2 should be PivotName2 and so on. > > 2) The macro should exclude Data and List sheets. > > Any help would be appreciated. > > Thanks > > Rashid Khan > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
FW: $$Excel-Macros$$ macro: delete base on table
Here is thread on this Solution , Please visit
http://www.excelfox.com/forum/f20/delete-list-contain-matching-second-list-5
89/
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: Rajan_Verma [mailto:rajanverma1...@gmail.com]
Sent: 04 October 2012 9:58
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ macro: delete base on table
Hi,
Use this Code, Just Create Two Name Ranges,
Sheet1!B2="rngRange"
Sheet2!B2 =" MapDelete"
Sub ExcludeFromList()
Dim objDicMap As Object
Dim VarArrData
Dim VarArrResult
Dim rngCell As Range
Dim lngCOunt As Long
VarArrData = Intersect(Range("rngRange").CurrentRegion,
Range("rngRange").CurrentRegion.Offset(1))
Set objDicMap = CreateObject("Scripting.Dictionary")' Dictionary
Object get Mapping
'Filling Dictionary
For Each rngCell In Intersect(Range("MapDelete").CurrentRegion,
Range("MapDelete").CurrentRegion.Offset(1))
If Not objDicMap.exists(rngCell.Value) Then objDicMap.Add
rngCell.Value, rngCell.Value
Next rngCell
'Filling Result Array From Data List which would not Include Mapping
Data
For lngCOunt = LBound(VarArrData) To UBound(VarArrData)
If Not objDicMap.exists(VarArrData(lngCOunt, 1)) Then
If Not IsArray(VarArrResult) Then
ReDim VarArrResult(0 To 0)
VarArrResult(0) = VarArrData(lngCOunt, 1)
Else
ReDim Preserve VarArrResult(UBound(VarArrResult) + 1)
VarArrResult(UBound(VarArrResult)) = VarArrData(lngCOunt, 1)
End If
End If
Next lngCOunt
'Clear Old List
Range("rngRange").CurrentRegion.Offset(1).Clear
'Replace with new list
Range("rngRange").Offset(1).Resize(UBound(VarArrResult)).Value =
Application.Transpose(VarArrResult)
Set objDicMap = Nothing
Set rngCell = Nothing
End Sub
Keep Excelling J
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of pawel lupinski
Sent: 04 October 2012 9:30
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ macro: delete base on table
Hi All,
I'd like to ask you for favour, can you help me with these. I have a table
"code" with codes. From this table I'd like to excclude all codes for table
"to delete" (tab table). Right now I'm using "or" function in vba, but when
I want to add something, each time I need to open VB and change it. Is there
any way that I can manage it from "to delete" table?
Thanks
Pawel
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ 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.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or 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.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ 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.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or 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.
Re: $$Excel-Macros$$ Re: Modify code below to also insert the file creation date
why don't u sort data after all the information is imported to sheet on the
basis of column having create date
On Thu, Oct 4, 2012 at 10:06 PM, Best Of Luck wrote:
> Prince Dubey ,
>
> Thanks for the last code update it works great. I have one other problem
> how can I modify this code where
> Range("I" & i) = f.Name is soreted so that the oldest file is displayed
> on top?
>
> thnaks in advance.
>
>
> On Thursday, September 27, 2012 10:52:04 PM UTC-5, Prince Dubey wrote:
>
>> Hi Friend,
>>
>> I hope this will help you.
>>
>> Private Sub FolderRead(ByRef myFolder)
>> Dim countf As String
>> countf = 0
>>
>>For Each f In myFolder.Files
>> Var = f.Path
>> If Right(f.Name, 4) = ".pdf" Or Right(f.Name, 4) = ".tif" Then
>> i = i + 1
>> ActiveSheet.Hyperlinks.Add Anchor:=Range("A" & i), _
>> Address:=f.Path, TextToDisplay:=f.Name & " " & f
>> Range("I" & i) = f.Name 'mer added
>> Range("J" & i) = rootfolder & "\" 'mer added
>>* Range("K" & i) = f.DateCreated*
>> countf = countf + 1
>> End If
>>
>>Next f
>>Range("E1") = "# Of Documents is: " & countf
>> countf = 0
>> End Sub
>>
>>
>> Regards
>> Prince
>>
>>
>> On Friday, September 28, 2012 3:21:11 AM UTC+5:30, Best Of Luck wrote:
>>>
>>> Hello Group:
>>>
>>> *I am using the code below to read a directory and create hyperlinks
>>> from the files but now I need to insert the file creation date also .How
>>> can modify this code to do this.*
>>> *Here is the code*:
>>>
>>> *Private Sub FolderRead(ByRef myFolder)
>>> Dim countf As String
>>> countf = 0
>>>For Each f In myFolder.Files
>>> Var = f.Path
>>> If Right(f.Name, 4) = ".pdf" Or Right(f.Name, 4) = ".tif" Then
>>> i = i + 1
>>> ActiveSheet.Hyperlinks.Add Anchor:=Range("A" & i), _
>>> Address:=f.Path, TextToDisplay:=f.Name & " " & f
>>>
>>> Range("I" & i) = f.Name 'mer added
>>> Range("J" & i) = rootfolder & "\" 'mer added
>>> countf = countf + 1
>>> End If
>>>
>>>Next f
>>>Range("E1") = "# Of Documents is: " & countf
>>> countf = 0
>>> End Sub*
>>>
>> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or 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.
>
>
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*
P Before printing, think about the environment.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ 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.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or 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.
$$Excel-Macros$$ Re: Modify code below to also insert the file creation date
Prince Dubey ,
Thanks for the last code update it works great. I have one other problem
how can I modify this code where
Range("I" & i) = f.Name is soreted so that the oldest file is displayed on
top?
thnaks in advance.
On Thursday, September 27, 2012 10:52:04 PM UTC-5, Prince Dubey wrote:
> Hi Friend,
>
> I hope this will help you.
>
> Private Sub FolderRead(ByRef myFolder)
> Dim countf As String
> countf = 0
>
>For Each f In myFolder.Files
> Var = f.Path
> If Right(f.Name, 4) = ".pdf" Or Right(f.Name, 4) = ".tif" Then
> i = i + 1
> ActiveSheet.Hyperlinks.Add Anchor:=Range("A" & i), _
> Address:=f.Path, TextToDisplay:=f.Name & " " & f
> Range("I" & i) = f.Name 'mer added
> Range("J" & i) = rootfolder & "\" 'mer added
>* Range("K" & i) = f.DateCreated*
> countf = countf + 1
> End If
>
>Next f
>Range("E1") = "# Of Documents is: " & countf
> countf = 0
> End Sub
>
>
> Regards
> Prince
>
>
> On Friday, September 28, 2012 3:21:11 AM UTC+5:30, Best Of Luck wrote:
>>
>> Hello Group:
>>
>> *I am using the code below to read a directory and create hyperlinks
>> from the files but now I need to insert the file creation date also .How
>> can modify this code to do this.*
>> *Here is the code*:
>>
>> *Private Sub FolderRead(ByRef myFolder)
>> Dim countf As String
>> countf = 0
>>For Each f In myFolder.Files
>> Var = f.Path
>> If Right(f.Name, 4) = ".pdf" Or Right(f.Name, 4) = ".tif" Then
>> i = i + 1
>> ActiveSheet.Hyperlinks.Add Anchor:=Range("A" & i), _
>> Address:=f.Path, TextToDisplay:=f.Name & " " & f
>>
>> Range("I" & i) = f.Name 'mer added
>> Range("J" & i) = rootfolder & "\" 'mer added
>> countf = countf + 1
>> End If
>>
>>Next f
>>Range("E1") = "# Of Documents is: " & countf
>> countf = 0
>> End Sub*
>>
>
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ 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.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or 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.
RE: $$Excel-Macros$$ macro: delete base on table
Hi,
Use this Code, Just Create Two Name Ranges,
Sheet1!B2="rngRange"
Sheet2!B2 =" MapDelete"
Sub ExcludeFromList()
Dim objDicMap As Object
Dim VarArrData
Dim VarArrResult
Dim rngCell As Range
Dim lngCOunt As Long
VarArrData = Intersect(Range("rngRange").CurrentRegion,
Range("rngRange").CurrentRegion.Offset(1))
Set objDicMap = CreateObject("Scripting.Dictionary")' Dictionary
Object get Mapping
'Filling Dictionary
For Each rngCell In Intersect(Range("MapDelete").CurrentRegion,
Range("MapDelete").CurrentRegion.Offset(1))
If Not objDicMap.exists(rngCell.Value) Then objDicMap.Add
rngCell.Value, rngCell.Value
Next rngCell
'Filling Result Array From Data List which would not Include Mapping
Data
For lngCOunt = LBound(VarArrData) To UBound(VarArrData)
If Not objDicMap.exists(VarArrData(lngCOunt, 1)) Then
If Not IsArray(VarArrResult) Then
ReDim VarArrResult(0 To 0)
VarArrResult(0) = VarArrData(lngCOunt, 1)
Else
ReDim Preserve VarArrResult(UBound(VarArrResult) + 1)
VarArrResult(UBound(VarArrResult)) = VarArrData(lngCOunt, 1)
End If
End If
Next lngCOunt
'Clear Old List
Range("rngRange").CurrentRegion.Offset(1).Clear
'Replace with new list
Range("rngRange").Offset(1).Resize(UBound(VarArrResult)).Value =
Application.Transpose(VarArrResult)
Set objDicMap = Nothing
Set rngCell = Nothing
End Sub
Keep Excelling J
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of pawel lupinski
Sent: 04 October 2012 9:30
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ macro: delete base on table
Hi All,
I'd like to ask you for favour, can you help me with these. I have a table
"code" with codes. From this table I'd like to excclude all codes for table
"to delete" (tab table). Right now I'm using "or" function in vba, but when
I want to add something, each time I need to open VB and change it. Is there
any way that I can manage it from "to delete" table?
Thanks
Pawel
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ 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.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or 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.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ 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.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or 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.
Re: $$Excel-Macros$$ Fwd: Job | Urgent Opening for Assistant Manager MIS for a NBFC at SantNagar (Near Nehru Place)
BAN On Thu, Oct 4, 2012 at 9:51 PM, Paul Schreiner wrote: > You probably mean "BAN" > > Definitions: > > Bane: "A source of harm or ruin" > > Ban: "To prohibit (especially by legal means)" > > > *Paul* > > - > *“Do all the good you can, > By all the means you can, > In all the ways you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > *- > > > -- > *From:* Prince Dubey > *To:* excel-macros@googlegroups.com > *Sent:* Thu, October 4, 2012 12:18:25 PM > *Subject:* Re: $$Excel-Macros$$ Fwd: Job | Urgent Opening for Assistant > Manager MIS for a NBFC at SantNagar (Near Nehru Place) > > Bane this > > regards > prince > > On Thursday, October 4, 2012 6:22:01 PM UTC+5:30, Rajan_Verma wrote: >> >> *What to do with this??* >> >> * * >> >> * * >> >> *Regards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> * * >> >> *From:* excel-...@googlegroups.com [mailto:excel-...@ googlegroups.com] *On >> Behalf Of *Prince Sethi >> *Sent:* 04 October 2012 5:07 >> *To:* amarjeet...@rediffmail. com; anita...@gmail.com; appro...@gmail.com; >> bhardwa...@rocketmail.com ; gyan...@gmail.com; handsom...@yahoo.com; >> ishu_d...@rediffmail.com; kamleshb...@gmail.com; kuma...@yahoo.com; >> nikhil.npk...@gmail. >> com; nizam@gmail.com; om.ha...@gmail.com; pooja...@gmail.com; >> prave...@gmail.com; pushp...@yahoo.com; raj009...@rediffmail.com; >> rajend...@gmail.com; rajeshpo...@yahoo.co.in; rajput...@yahoo.in; >> rawat@gmail.com; rupesh...@yahoo.com; saurav...@yahoo.com; >> subhash...@gmail.com; subod...@futurecapital.in; sunny...@yahoo.com; >> sunnyxxx...@gmail.com; sushilku...@yahoo.com; syedane...@hcl.com; >> Abineet Katiyar (Exl-Homemove); Aditya Sharma; Aditya Sharma; Afroj Alam >> (Airtel); afsher khan; Ajay Semwal (BMMR); Alok Kumar (Imbalance); Alok >> Kumar (MIS); AMIT PAL; AMIT PAL; Anant Sharma (Airtel); Aneet (Topaz C5); >> Anil Rawat (Airtel); Anita Bansal (Chandigarh); ankiit.jaiin; Ankit Rastogi >> (Igate); Ankit Rastogi (Igate); Ankur Aggarwal (BMMR); Anu Bajaj; anuj >> Sharma; Arun Jindal (Friend); Arvind Tiwari (Imbalance); Arwind Rawat >> (InoData); Arwind Rawat (InoData); Ashish Tripathi (HomeMove); Ashok; Ashok >> Biswas (FIS); Avinash Kumar (Patni); Bhaskar Rawat; Brij Bhushan; Brijpal >> Rawat; Bupinder Singh Negi (IGate); chandan jha; chandan_negi2003 >> (Acqusition); chandrashekhar jha (Igate); DEBASHISH KARMAKAR (Airtel); >> deepak gupta, HCLBPO, HCL BSERV; Deepak Singh Rana (MIS); Deepak Tau; >> Deepesh Jain (MIS); Dharmendra (Device); Dharmendra (Patni); Digvijay >> (Airtel); Dinesh Singh Rana; Excel Group; Geetika (Igate); Geetika (Patni); >> Himanshu Kukreti (Imabalance); Hitesh Dhuria; Itee Shree (BMMR); jay >> subhash; Kamal Khurana (Travellers Rohtak); Kapil; Kirti Jaiswal; Krishna >> (FIS); Kuhu (AM-EXL); kumartia; Lalit Arya (Igate); Lalit Bisht (BMMR); >> Lalit Sharma (C1); Leepu; Manish Dhoundiyal; Manu Sood; Meenu Bajaj; Mihir >> (EXL); Mohd. Gaffar; Mohd. Maroof Ali; Mukesh (Topaz c5); Naresh Sharma; >> Naseem (Airtel); Naveen Agarwal; Naveen Aggarwal; Netrapal (Igate); Nishant >> (EXL); Nishant Arora; Nitin Sharma; Padam (Airtel); Pallavi Bajaj; Pankaj >> (Hewitt); parveen kumar; Pawan Tayal; Pawan Tayal; Piyush Duklan; PIYUSH >> SAHOO (Airtel); Poonam Chugh; pradeep singh; Prashant (Ienergizer); Preeti >> Jaiswal; Prince (Gmail); Prince (Hotmail); Prince Sethi; Prince Sethi; >> R.kumar; rahul sharma; Raj; Raj Kumar (Airtel); Rajeev Rana (Acqusition); >> Rajendra Negi (Home Move); Rajendra Negi; Rajesh Kumar (Device); Rajiv >> (Exl-iGate); Raju Rao (Device); Rakesh Rangra; Ram Maurya; Rama kant >> (Patni); Ramjan ali (C6); Ravinder (cab); Reena Makhloga (BMMR); Reetiza >> shastri (Sas); Renu Bisht (Home Move); Renu Sammi (Imbalance); Riti Sunny >> Talwar; Ritu Saxena (HTS); Rohit (HCL); Rupendra Singh (Barclays); rupesh >> kumar; Sabir Khan; Sachin Sharma (BMMR); Salil Bhandari (HCL); Sanjay >> (Airtel); Sanjay (Device); Sanjay Panwar; Sanjay Thakur (Shalimar Garden); >> Santosh (Tech Mahendra); Sarvesh Tiwari (Imbalance); Shailesh Dube; Shallu >> Arora (Sis in law); Sham Sunder; sharma.aditya1211; shekhar verma; shelly >> Juneja; Shishupal (Compitent); Shiwani (EXL C-6); subodh kumar; Subodh >> Kumar (HTS); Sukhwinder EXL; Sumit Bansal (BMMR); SUMIT KUJUR (Igate); >> Sunil (FIS); Sunil Kumar (Igate); Surender Sharma (EXL); Surender Suri >> (Imbalance); Sushant Sarangi (Vaccants); Teeath Singh (EXL); Tej (HCL); Tej >> Pal (InoData); Varun Malik (Device); Veenu Taneeja (Igate); Vijay (Airtel); >> Vijay (Airtel); Vinod Singh Rana (Device); Vinod Singh Rana (Device); Vipal >> Kochar; Virendra Rawat; Vishal (SAS); Vivek (Exl C-6); (imbalance); >> Yatinder Gaur (Home move); Yesh Gupta (Accenture); Yogesh (Jodhpur) >> *Subject:* $$Excel-Macros$$ Fwd: Job | Urgent Opening for Assistant
Re: $$Excel-Macros$$ Fwd: Job | Urgent Opening for Assistant Manager MIS for a NBFC at SantNagar (Near Nehru Place)
You probably mean "BAN" Definitions: Bane: "A source of harm or ruin" Ban: "To prohibit (especially by legal means)" Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Prince Dubey To: excel-macros@googlegroups.com Sent: Thu, October 4, 2012 12:18:25 PM Subject: Re: $$Excel-Macros$$ Fwd: Job | Urgent Opening for Assistant Manager MIS for a NBFC at SantNagar (Near Nehru Place) Bane this regards prince On Thursday, October 4, 2012 6:22:01 PM UTC+5:30, Rajan_Verma wrote: What to do with this?? > > >Regards >Rajan verma >+91 7838100659 [IM-Gtalk] > >From:excel-...@googlegroups.com [mailto:excel-...@ googlegroups.com] On Behalf >Of Prince Sethi >Sent: 04 October 2012 5:07 >To: amarjeet...@rediffmail. com; anita...@gmail.com; appro...@gmail.com; >bhardwa...@rocketmail.com ; gyan...@gmail.com; handsom...@yahoo.com; >ishu_d...@rediffmail.com; kamleshb...@gmail.com; kuma...@yahoo.com; >nikhil.npk...@gmail. com; nizam@gmail.com; om.ha...@gmail.com; >pooja...@gmail.com; prave...@gmail.com; pushp...@yahoo.com; >raj009...@rediffmail.com; rajend...@gmail.com; rajeshpo...@yahoo.co.in; >rajput...@yahoo.in; rawat@gmail.com; rupesh...@yahoo.com; >saurav...@yahoo.com; subhash...@gmail.com; subod...@futurecapital.in; >sunny...@yahoo.com; sunnyxxx...@gmail.com; sushilku...@yahoo.com; >syedane...@hcl.com; Abineet Katiyar (Exl-Homemove); Aditya Sharma; Aditya >Sharma; Afroj Alam (Airtel); afsher khan; Ajay Semwal (BMMR); Alok Kumar >(Imbalance); Alok Kumar (MIS); AMIT PAL; AMIT PAL; Anant Sharma (Airtel); >Aneet >(Topaz C5); Anil Rawat (Airtel); Anita Bansal (Chandigarh); ankiit.jaiin; >Ankit >Rastogi (Igate); Ankit Rastogi (Igate); Ankur Aggarwal (BMMR); Anu Bajaj; anuj >Sharma; Arun Jindal (Friend); Arvind Tiwari (Imbalance); Arwind Rawat >(InoData); >Arwind Rawat (InoData); Ashish Tripathi (HomeMove); Ashok; Ashok Biswas (FIS); >Avinash Kumar (Patni); Bhaskar Rawat; Brij Bhushan; Brijpal Rawat; Bupinder >Singh Negi (IGate); chandan jha; chandan_negi2003 (Acqusition); chandrashekhar >jha (Igate); DEBASHISH KARMAKAR (Airtel); deepak gupta, HCLBPO, HCL BSERV; >Deepak Singh Rana (MIS); Deepak Tau; Deepesh Jain (MIS); Dharmendra (Device); >Dharmendra (Patni); Digvijay (Airtel); Dinesh Singh Rana; Excel Group; Geetika >(Igate); Geetika (Patni); Himanshu Kukreti (Imabalance); Hitesh Dhuria; Itee >Shree (BMMR); jay subhash; Kamal Khurana (Travellers Rohtak); Kapil; Kirti >Jaiswal; Krishna (FIS); Kuhu (AM-EXL); kumartia; Lalit Arya (Igate); Lalit >Bisht >(BMMR); Lalit Sharma (C1); Leepu; Manish Dhoundiyal; Manu Sood; Meenu Bajaj; >Mihir (EXL); Mohd. Gaffar; Mohd. Maroof Ali; Mukesh (Topaz c5); Naresh Sharma; >Naseem (Airtel); Naveen Agarwal; Naveen Aggarwal; Netrapal (Igate); Nishant >(EXL); Nishant Arora; Nitin Sharma; Padam (Airtel); Pallavi Bajaj; Pankaj >(Hewitt); parveen kumar; Pawan Tayal; Pawan Tayal; Piyush Duklan; PIYUSH SAHOO >(Airtel); Poonam Chugh; pradeep singh; Prashant (Ienergizer); Preeti Jaiswal; >Prince (Gmail); Prince (Hotmail); Prince Sethi; Prince Sethi; R.kumar; rahul >sharma; Raj; Raj Kumar (Airtel); Rajeev Rana (Acqusition); Rajendra Negi (Home >Move); Rajendra Negi; Rajesh Kumar (Device); Rajiv (Exl-iGate); Raju Rao >(Device); Rakesh Rangra; Ram Maurya; Rama kant (Patni); Ramjan ali (C6); >Ravinder (cab); Reena Makhloga (BMMR); Reetiza shastri (Sas); Renu Bisht (Home >Move); Renu Sammi (Imbalance); Riti Sunny Talwar; Ritu Saxena (HTS); Rohit >(HCL); Rupendra Singh (Barclays); rupesh kumar; Sabir Khan; Sachin Sharma >(BMMR); Salil Bhandari (HCL); Sanjay (Airtel); Sanjay (Device); Sanjay Panwar; >Sanjay Thakur (Shalimar Garden); Santosh (Tech Mahendra); Sarvesh Tiwari >(Imbalance); Shailesh Dube; Shallu Arora (Sis in law); Sham Sunder; >sharma.aditya1211; shekhar verma; shelly Juneja; Shishupal (Compitent); >Shiwani >(EXL C-6); subodh kumar; Subodh Kumar (HTS); Sukhwinder EXL; Sumit Bansal >(BMMR); SUMIT KUJUR (Igate); Sunil (FIS); Sunil Kumar (Igate); Surender Sharma >(EXL); Surender Suri (Imbalance); Sushant Sarangi (Vaccants); Teeath Singh >(EXL); Tej (HCL); Tej Pal (InoData); Varun Malik (Device); Veenu Taneeja >(Igate); Vijay (Airtel); Vijay (Airtel); Vinod Singh Rana (Device); Vinod >Singh >Rana (Device); Vipal Kochar; Virendra Rawat; Vishal (SAS); Vivek (Exl C-6); > >(imbalance); Yatinder Gaur (Home move); Yesh Gupta (Accenture); Yogesh >(Jodhpur) >Subject: $$Excel-Macros$$ Fwd: Job | Urgent Opening for Assistant Manager MIS >for a NBFC at SantNagar (Near Nehru Place) > > >-- Forwarded message -- >From: Prince Sethi >Date: Mon, Oct 1, 2012 at 6:58 PM >Subject: Fwd: Job | Urgent Opening for Assistant Manager MIS for a NBFC at >Sant
Re: $$Excel-Macros$$ macro: delete base on table
Sub sample_code()
Application.ScreenUpdating = False
Dim a As Range
Dim SrchRnga As Range
Dim i As Long
Set SrchRnga = Sheets(1).Range("b1: b" &
Sheets(1).Range("b65356").End(xlUp).Row)
For i = 3 To Sheets("table").Range("b65356").End(xlUp).Row
Do
Set a = SrchRnga.Find(Sheets("table").Range("b" & i).Value,
LookIn:=xlValues)
If Not a Is Nothing Then a.EntireRow.Delete
Loop While Not a Is Nothing
Next
Application.ScreenUpdating = True
End Sub
On Thu, Oct 4, 2012 at 9:30 PM, pawel lupinski wrote:
> Hi All,**
> I'd like to ask you for favour, can you help me with these. I have a table
> "code" with codes. From this table I'd like to excclude all codes for table
> "to delete" (tab table). Right now I'm using "or" function in vba, but when
> I want to add something, each time I need to open VB and change it. Is
> there any way that I can manage it from "to delete" table?
> Thanks
> Pawel
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or 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.
>
>
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*
P Before printing, think about the environment.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ 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.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or 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.
$$Excel-Macros$$ Re: Need help
Hi Karthik, Pls see the attachment. regards Prince. On Thursday, October 4, 2012 7:14:56 PM UTC+5:30, karthik n wrote: > > Hi Team, > > Please help in the attachment file > > Regards > karthik.N > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. help_solved.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ macro: delete base on table
Hi All, I'd like to ask you for favour, can you help me with these. I have a table "code" with codes. From this table I'd like to excclude all codes for table "to delete" (tab table). Right now I'm using "or" function in vba, but when I want to add something, each time I need to open VB and change it. Is there any way that I can manage it from "to delete" table? Thanks Pawel -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. todelete.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Re: need guidance in learning macros and VBA
buy power programming by john walkenbach On Thu, Oct 4, 2012 at 6:39 PM, ram gopal yadav wrote: > Hi all, > > Thanks Prince, Rajan, Ashish You guys really shared wonderful info... > > As of now i m start reading the book and source on net. > > *BUT, is there any way to learn it by seeing video-Tutorials and yes is > there any kind of certification xam for the same which would be useful for > my Job prospects.* > * > * > *And i m very much thankful to u if u can suggest me someone in delhi who > taught the course or some online mentor.* > > > Thanks Again > > > > > > > > > > > On Sunday, 23 September 2012 09:57:47 UTC+5:30, ram gopal yadav wrote: >> >> Hi all, >> >> Please tell me the books or video links useful for learning macros and >> VBA. >> >> Looking for valuable advice. Thanks in advance. >> >> >> Regards. >> >> RAM GOPAL YADAV >> Mobile No's:- 08130155401, >> >> >> -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ 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. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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. > > > -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
Re: $$Excel-Macros$$
IF(ISERROR(B2-A2),"",B2-A2) format as [mm] On Thu, Oct 4, 2012 at 6:51 PM, Chandra Shekar wrote: > Hi, > > Could you please let me know how to ignore error in the rows? > > Regards, > > Chandra Shekar B > > On Wed, Oct 3, 2012 at 4:59 PM, Rajan_Verma wrote: > >> *Date2 Must be greater than Date1* >> >> * * >> >> * * >> >> *Regards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> * * >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar >> *Sent:* 03 October 2012 6:59 >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$ >> >> ** ** >> >> Hello, >> >> >> >> I tried the formula still its have some issues could you please check it >> out. >> >> >> >> Thanks in advance. >> >> >> >> >> >> >> >> On Wed, Oct 3, 2012 at 3:13 PM, Rajan_Verma >> wrote: >> >> * * >> >> * * >> >> *=B2-A2* >> >> * * >> >> *Apply [m] as custom format* >> >> * * >> >> *Regards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> * * >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar >> *Sent:* 03 October 2012 6:34 >> *To:* excel-macros@googlegroups.com >> *Subject:* $$Excel-Macros$$ >> >> >> >> Hello, >> >> >> >> Could you please help me in the attached file. >> >> >> >> Thanks in advance. >> >> >> >> Regards, >> >> >> >> Chandra Shekar B >> >> >> >> >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ 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. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or 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. >> >> >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ 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. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or 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. >> >> >> >> ** ** >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ 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. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss.
Re: $$Excel-Macros$$
IF(ISERROR(B2-A2),"",B2-A2) format as [mm] On Thu, Oct 4, 2012 at 6:51 PM, Chandra Shekar wrote: > Hi, > > Could you please let me know how to ignore error in the rows? > > Regards, > > Chandra Shekar B > > On Wed, Oct 3, 2012 at 4:59 PM, Rajan_Verma wrote: > >> *Date2 Must be greater than Date1* >> >> * * >> >> * * >> >> *Regards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> * * >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar >> *Sent:* 03 October 2012 6:59 >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$ >> >> ** ** >> >> Hello, >> >> >> >> I tried the formula still its have some issues could you please check it >> out. >> >> >> >> Thanks in advance. >> >> >> >> >> >> >> >> On Wed, Oct 3, 2012 at 3:13 PM, Rajan_Verma >> wrote: >> >> * * >> >> * * >> >> *=B2-A2* >> >> * * >> >> *Apply [m] as custom format* >> >> * * >> >> *Regards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> * * >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar >> *Sent:* 03 October 2012 6:34 >> *To:* excel-macros@googlegroups.com >> *Subject:* $$Excel-Macros$$ >> >> >> >> Hello, >> >> >> >> Could you please help me in the attached file. >> >> >> >> Thanks in advance. >> >> >> >> Regards, >> >> >> >> Chandra Shekar B >> >> >> >> >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ 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. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or 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. >> >> >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ 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. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or 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. >> >> >> >> ** ** >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ 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. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any lo
Re: $$Excel-Macros$$ Error Issue
can you attach the sample file and output of pivpt table On Thu, Oct 4, 2012 at 6:44 PM, Mangesh Vimay wrote: > Hi Friends, > > I am trying to create pivot table by using vba. > > While working, the following error generated - > > [image: Inline image 1] > > Please help me by providing suitable answer. > > > -- > With regards, > > *MaNgEsH* > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ 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. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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. > > > -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. <>
Re: $$Excel-Macros$$ Need help
See the attached file, its siolved Ashish On Thu, Oct 4, 2012 at 7:14 PM, karthik N wrote: > Hi Team, > > Please help in the attachment file > > Regards > karthik.N > > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ 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. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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. > > > -- Thanks & regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. help (solve).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Need help
Hi Team, Please help in the attachment file Regards karthik.N -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. help.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$
Hi, Could you please let me know how to ignore error in the rows? Regards, Chandra Shekar B On Wed, Oct 3, 2012 at 4:59 PM, Rajan_Verma wrote: > *Date2 Must be greater than Date1* > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar > *Sent:* 03 October 2012 6:59 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ > > ** ** > > Hello, > > > > I tried the formula still its have some issues could you please check it > out. > > > > Thanks in advance. > > > > > > > > On Wed, Oct 3, 2012 at 3:13 PM, Rajan_Verma > wrote: > > * * > > * * > > *=B2-A2* > > * * > > *Apply [m] as custom format* > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar > *Sent:* 03 October 2012 6:34 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ > > > > Hello, > > > > Could you please help me in the attached file. > > > > Thanks in advance. > > > > Regards, > > > > Chandra Shekar B > > > > > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ 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. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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. > > > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ 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. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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. > > > > ** ** > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ 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. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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. > > > > -- > Join of
$$Excel-Macros$$ Re: need guidance in learning macros and VBA
Hi all, Thanks Prince, Rajan, Ashish You guys really shared wonderful info... As of now i m start reading the book and source on net. *BUT, is there any way to learn it by seeing video-Tutorials and yes is there any kind of certification xam for the same which would be useful for my Job prospects.* * * *And i m very much thankful to u if u can suggest me someone in delhi who taught the course or some online mentor.* Thanks Again On Sunday, 23 September 2012 09:57:47 UTC+5:30, ram gopal yadav wrote: > > Hi all, > > Please tell me the books or video links useful for learning macros and > VBA. > > Looking for valuable advice. Thanks in advance. > > > Regards. > > RAM GOPAL YADAV > Mobile No's:- 08130155401, > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
$$Excel-Macros$$ Re: Introduce Yourself !!
Ram Gopal Yadav Research Analyst-Agri Commodities Noida New to VBA -- need help how to start i.e, from basic Hope i will be learn VBA.. On Saturday, 9 June 2012 00:51:59 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 > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
RE: $$Excel-Macros$$ Dual Monitors
Did try yet, can you explain what you do actually ? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of mburkett Sent: 04 October 2012 12:29 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Dual Monitors I am constantly moving my excel window from 1 screen to another. Does anyone know of vba code that would switch the excel window from one monitor to another? Thanks - Michael -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
Re: $$Excel-Macros$$ Urgently multiple if condition required in excel
Based on the pattern, it looks like you're wanting to round UP to the next increment of 5 However, there's might be a small problem. Are the numbers you're testing really %'s? That is.. is 50.3 really .503 represented as 50.3% or is it actually 50.3 and you're just CALLING it a %? If it's really a number like 50.3, then you can use: =ROUNDUP(A1/5,0)*5/100 If it's really a %, then you can use: =ROUNDUP(A1/0.05,0)*0.05 Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Dhartikumar Sahu To: excel-macros@googlegroups.com Sent: Thu, October 4, 2012 2:14:03 AM Subject: $$Excel-Macros$$ Urgently multiple if condition required in excel hi Group Can u please help me out in this problem. I have an query of Multiple if conditions if % Column true then result will be shown in solution. % if Solution 37 >50 – 55% 0.55 50.3 >55 – 60% 0.6 50.09 >60 – 65% 0.65 62.43 >65 – 70% 0.7 68.39 >70 – 75% 0.75 30.43 >75 – 80% 0.8 50.71 >80 – 85% 0.85 59.97 >85 – 90% 0.9 75 >90 – 95% 0.95 37.45 >95 – 100% 1 -- Regards, Dhartikumar Sahu Sr.Database Manager - Institutional Equities IDBI Capital Markets Services Ltd 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21 Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
Re: $$Excel-Macros$$ How to give the conditional formatting for the full data
Yes, Actually I apply conditional formating for A2 and then copy it to all cells... thats y date formatting get change.. On Thu, Oct 4, 2012 at 4:19 PM, Pravin Gunjal wrote: > *Thanks Ahmed & Swapnil* > * > * > *Yes there was some date formatting went wrong in Swapnil's file.* > * > * > *Ahmed : your file is absolutely fine. * > * > * > *Thanks a lot !* > * > * > *Pravin Gunjal* > > > > On Thu, Oct 4, 2012 at 4:08 PM, Ahmed Honest wrote: > >> Dear Pravin, >> >> PFA with Revised and Swapnil one solution is also the same but it is >> disturbing the Date Column which has been undisturbed in my file. Choose >> which ever suits your requirement. >> >> Thanks, >> >> On Thu, Oct 4, 2012 at 1:15 PM, Ahmed Honest wrote: >> >>> Dear Pravin. >>> >>> *PFA* >>> >>> On Thu, Oct 4, 2012 at 1:01 PM, Pravin Gunjal wrote: >>> *Hello Friends,* * * *I require a help on the subject matter. The file is attached for your reference.* * * *I have used the conditional formatting as mentioned in the excel file. And I required that the same formatting has to be given for the full data i.e. from A2 to E12 cells.* * * *Kindly help on this matter. Thank you.* * * *Regards* *Pravin Gunjal* * * -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. >>> >>> >>> >>> -- >>> Ahmed Bawazir >>> *احمد باوزير* >>> >>> >> >> >> -- >> Ahmed Bawazir >> *احمد باوزير* >> >> > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ 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. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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. > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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
$$Excel-Macros$$ Re: Help Required
Hi neeraj , you can use this =IF(HOUR(TIMEVALUE(RIGHT(A2,8)))<12,"Night","Day") On Thursday, 4 October 2012 14:40:45 UTC+5:30, neeraj chauhan wrote: > > Dear Experts > > > > Kindly see the attached sheet and urgently req. > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
Re: $$Excel-Macros$$ How to give the conditional formatting for the full data
*Thanks Ahmed & Swapnil* * * *Yes there was some date formatting went wrong in Swapnil's file.* * * *Ahmed : your file is absolutely fine. * * * *Thanks a lot !* * * *Pravin Gunjal* On Thu, Oct 4, 2012 at 4:08 PM, Ahmed Honest wrote: > Dear Pravin, > > PFA with Revised and Swapnil one solution is also the same but it is > disturbing the Date Column which has been undisturbed in my file. Choose > which ever suits your requirement. > > Thanks, > > On Thu, Oct 4, 2012 at 1:15 PM, Ahmed Honest wrote: > >> Dear Pravin. >> >> *PFA* >> >> On Thu, Oct 4, 2012 at 1:01 PM, Pravin Gunjal wrote: >> >>> *Hello Friends,* >>> * >>> * >>> *I require a help on the subject matter. The file is attached for your >>> reference.* >>> * >>> * >>> *I have used the conditional formatting as mentioned in the excel file. >>> And I required that the same formatting has to be given for the full data >>> i.e. from A2 to E12 cells.* >>> * >>> * >>> *Kindly help on this matter. Thank you.* >>> * >>> * >>> *Regards* >>> *Pravin Gunjal* >>> * >>> * >>> >>> -- >>> Join official facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES (1120+ 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. >>> >>> 6) Jobs posting is not allowed. >>> >>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >>> >>> NOTE : Don't ever post personal or 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. >>> >>> >>> >> >> >> >> -- >> Ahmed Bawazir >> *احمد باوزير* >> >> > > > -- > Ahmed Bawazir > *احمد باوزير* > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
Re: $$Excel-Macros$$ Help - To create chart based on the chart type select by using VBA
Hi Mangesh Can you send file as Excel 2003.Then I will try to solved your problem. On 10/3/12, Mangesh Vimay wrote: > Hi Rajan, > > Its sample data I have provided but the data range would remain same. > > Please provide solution. > Thanks !!! > > On Wed, Oct 3, 2012 at 6:43 PM, Rajan_Verma > wrote: > >> *Is your data suitable for all chart type ? * >> >> * * >> >> * * >> >> *Regards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> * * >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Mangesh Vimay >> *Sent:* 03 October 2012 6:39 >> *To:* excel-macros@googlegroups.com; Mangesh Vimay >> *Subject:* $$Excel-Macros$$ Help - To create chart based on the chart >> type select by using VBA >> >> ** ** >> >> Hi Friends, >> >> ** ** >> >> I need to create a chart based on the chart type selected from the drop >> down list (created by data validation). The sample data is being provided >> in the sheet. Every time when we create the chart previous chart should >> get deleted. [Find the attachment]. >> >> ** ** >> >> Please do it by using VBA. >> >> ** ** >> >> Thanks in advance. >> >> ** ** >> >> >> >> >> ** ** >> >> -- >> With regards, >> >> ** ** >> >> *MaNgEsH* >> >> ** ** >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ 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. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or 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. >> >> >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ 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. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or 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. >> >> >> > > > > -- > With regards, > > *MaNgEsH* > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ 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. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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. >
$$Excel-Macros$$ Re: How to repair corrupted Excel file
How many Sheets this workbook have ? do you remember all worksheet name? you can write formual to recover the contain only but not formating ='fullpathofworkbook[WorksheetName]'!A1 Drag this formula below and right Rajan. On Thursday, 4 October 2012 08:57:17 UTC+5:30, B Sharma wrote: > > Dear Friends & Excel Experts, > I have a Excel 2007 file of around 5 MB (which I saved in binary format. > Last week it suddenly got corrupted and I am now unable to open it , > > While opening it says "The work book cannot be opened or repaired by MS > Excel because it is corrupt" > > Please help me in this, its one of the important file of mine. > > Secondly, please also tell me what are the risks of keeping excel files in > binary format. > I save some file to reduce the file size.. > > I have tried, "Open & Repair" option. I have also downloaded some > application which says that they can repair the excel file, but didn;t. > > > Thanks in advance. > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
Re: $$Excel-Macros$$ How to give the conditional formatting for the full data
Dear Pravin, PFA with Revised and Swapnil one solution is also the same but it is disturbing the Date Column which has been undisturbed in my file. Choose which ever suits your requirement. Thanks, On Thu, Oct 4, 2012 at 1:15 PM, Ahmed Honest wrote: > Dear Pravin. > > *PFA* > > On Thu, Oct 4, 2012 at 1:01 PM, Pravin Gunjal wrote: > >> *Hello Friends,* >> * >> * >> *I require a help on the subject matter. The file is attached for your >> reference.* >> * >> * >> *I have used the conditional formatting as mentioned in the excel file. >> And I required that the same formatting has to be given for the full data >> i.e. from A2 to E12 cells.* >> * >> * >> *Kindly help on this matter. Thank you.* >> * >> * >> *Regards* >> *Pravin Gunjal* >> * >> * >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ 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. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or 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. >> >> >> > > > > -- > Ahmed Bawazir > *احمد باوزير* > > -- Ahmed Bawazir *احمد باوزير* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. Conditional Formatting Solution.xlsb Description: Binary data
Re: $$Excel-Macros$$ How to give the conditional formatting for the full data
Hi Pravin, PFA solution excel. Regards, Swapnil. On Thu, Oct 4, 2012 at 3:31 PM, Pravin Gunjal wrote: > *Hello Friends,* > * > * > *I require a help on the subject matter. The file is attached for your > reference.* > * > * > *I have used the conditional formatting as mentioned in the excel file. > And I required that the same formatting has to be given for the full data > i.e. from A2 to E12 cells.* > * > * > *Kindly help on this matter. Thank you.* > * > * > *Regards* > *Pravin Gunjal* > * > * > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ 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. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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. > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. Conditional formating solution.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
Re: $$Excel-Macros$$ Help Required
Thanks jeet!! On Thu, Oct 4, 2012 at 3:27 PM, jeet singh wrote: > Dear Friend, > > Plz find the attached file. > > > > On Thu, Oct 4, 2012 at 2:40 PM, Neeraj wrote: > >> Dear Experts >> >> ** ** >> >> Kindly see the attached sheet and urgently req. >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ 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. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or 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. >> >> >> > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ 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. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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. > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
Re: $$Excel-Macros$$ How to give the conditional formatting for the full data
Dear Pravin. *PFA* On Thu, Oct 4, 2012 at 1:01 PM, Pravin Gunjal wrote: > *Hello Friends,* > * > * > *I require a help on the subject matter. The file is attached for your > reference.* > * > * > *I have used the conditional formatting as mentioned in the excel file. > And I required that the same formatting has to be given for the full data > i.e. from A2 to E12 cells.* > * > * > *Kindly help on this matter. Thank you.* > * > * > *Regards* > *Pravin Gunjal* > * > * > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ 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. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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. > > > -- Ahmed Bawazir *احمد باوزير* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. Conditional Formatting Solution.xlsb Description: Binary data
Re: $$Excel-Macros$$ Urgently multiple if condition required in excel
Hi, I didn't get what exactly you want. But attached solutin file as per my understanding. You cannot have more than 7 nested If conditions so I have used different formula. Formula: =IF(A2>50, IF(MROUND(A2, 5)wrote: > hi Group > > Can u please help me out in this problem. I have an query of Multiple if > conditions > > if % Column true then result will be shown in solution. > % if Solution 37 >50 – 55% 0.55 50.3 >55 – 60% 0.6 50.09 >60 – 65% > 0.65 62.43 >65 – 70% 0.7 68.39 >70 – 75% 0.75 30.43 >75 – 80% 0.8 50.71 >80 > – 85% 0.85 59.97 >85 – 90% 0.9 75 >90 – 95% 0.95 37.45 >95 – 100% 1 > > -- > > *Regards,* > > *Dhartikumar Sahu* > > Sr.Database Manager - Institutional Equities > > * **IDBI Capital Markets Services Ltd* > > 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21 > > Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450 > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ 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. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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. > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. multiple if condition required in excel_solution.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ How to give the conditional formatting for the full data
*Hello Friends,* * * *I require a help on the subject matter. The file is attached for your reference.* * * *I have used the conditional formatting as mentioned in the excel file. And I required that the same formatting has to be given for the full data i.e. from A2 to E12 cells.* * * *Kindly help on this matter. Thank you.* * * *Regards* *Pravin Gunjal* * * -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. Book1.xlsb Description: Binary data
Re: $$Excel-Macros$$ Help Required
Dear Friend, Plz find the attached file. On Thu, Oct 4, 2012 at 2:40 PM, Neeraj wrote: > Dear Experts > > ** ** > > Kindly see the attached sheet and urgently req. > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ 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. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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. > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. Book1 (8).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Help Required
Dear Experts Kindly see the attached sheet and urgently req. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. Book1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
