Re: $$Excel-Macros$$ Formula based on some criteria
Try to create a formula but the main problem is to understand your query , IF(A2="AED",B2,VLOOKUP(Question!A2,'Master Sheet'!$A$3:$EC$8,MATCH($B$2,'Master Sheet'!$B$1:$EC$1,0)+1,0)) Clear one thing how the values are coming for rest of the i didn't found any JOD ,LPB in master even KWD values result you have shown coming from QAR row how is this possible what is the logic.? KWD SAR SAR SAR OMR BHD QAR JOD LBP EGP IQD On Sunday, 15 March 2015 10:23:44 UTC+5:30, Rameshwari wrote: > > Dear Team, > > Can any one help on this. > > Thanks, > Rameshwari > -- Forwarded message -- > From: rameshwari shyam > > Date: Fri, Mar 13, 2015 at 10:08 AM > Subject: Re: $$Excel-Macros$$ Formula based on some criteria > To: excel-...@googlegroups.com > > > Dear gaurav, > > required some more modification. if you can check AED in question sheet is > 15 then in Master sheet, search for 15 SAR. Below than that there is a AED > 15, KWD 15, SAR 1.5 OMR 1.5 BHD 15 QAR 1.25, > > Base currency will be AED in question sheet and in master sheet base > currency will be SAR > > > In simple words, need to do vlook up that is find AED value in master > sheet from cell reference "B2:EC8" once the currency get change it need to > change the display value. > > Every 13 row it need to change the reference. > > > Thanks, > Rameshwari > > > > > On Thu, Mar 12, 2015 at 4:54 PM, Gaurav Devrani > wrote: > >> Hi Rameshwari , >> >> >> Please check the file. Let me know if it does not work for you. >> >> Regards >> Gaurav Devrani >> >> On Thu, Mar 12, 2015 at 5:47 PM, Rameshwari > > wrote: >> >>> Hello team, >>> >>> I stuck with one formula, please help me on this. Formula based on some >>> criteria. >>> >>> >>> >>> Sheet “Question” having currency name with the prices, based on currency >>> name & prices need to update the value in answer filed. >>> >>> >>> >>> Master sheet will be a reference for the currency. Every 13 row need to >>> change the reference. >>> >>> What I am looking ;- if AED is 15 then need to search in master file SAR >>> 15 update the value of AED based on SAR, for KWD update the value of KWD >>> based on SAR, it means in question sheet AED will be base and in Master >>> sheet SAR will be the base. >>> >>> JOD, LBP, EGP, & IQD will be the same as mention. Please urgent help >>> required. >>> >>> Regards, >>> >>> Rameshwari >>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros...@googlegroups.com . >>> To post to this group, send email to excel-...@googlegroups.com >>> . >>> Visit this group at http://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> >> -- >> >> *Thanks & Regards* >> *Gaurav Devrani* >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros...@googlegroups.com . >> To post to this group, send email to excel-...@googlegroups.com >> . >> Visit t
Re: $$Excel-Macros$$ Re: Help with combination formula
l'm sorry please see attachment On Sun, Mar 15, 2015 at 2:45 AM, sahemur khan wrote: > On Saturday, 14 March 2015 15:06:13 UTC+5:30, Will Sob wrote: > > Hi, > > Please I need help with the attached file. I want a formula that > calculates how many times (10, 13, 17) combination has appeared within the > range D5:I32 > > > > > > > > > > > > > > > > > > > > > > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? > It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > > > FORUM RULES > > > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Jobs posting is not allowed. > > 6) Sharing copyrighted material and their links is not allowed. > > > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > > --- > > You received this message because you are subscribed to the Google > Groups "MS EXCEL AND VBA MACROS" group. > > To unsubscribe from this group and stop receiving emails from it, send > an email to excel-macros...@googlegroups.com. > > To post to this group, send email to excel-...@googlegroups.com. > > Visit this group at http://groups.google.com/group/excel-macros. > > For more options, visit https://groups.google.com/d/optout. > > > > -- > > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? > It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > > > FORUM RULES > > > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Jobs posting is not allowed. > > 6) Sharing copyrighted material and their links is not allowed. > > > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > > --- > > You received this message because you are subscribed to the Google > Groups "MS EXCEL AND VBA MACROS" group. > > To unsubscribe from this group and stop receiving emails from it, send > an email to excel-macros...@googlegroups.com. > > To post to this group, send email to excel-...@googlegroups.com. > > Visit this group at http://groups.google.com/group/excel-macros. > > For more options, visit https://groups.google.com/d/optout. > > > > > > > > Attachments area > > > > Preview attachment Paks.xlsx > > > > > > > > > > > > > > > > > > > > Paks.xlsx > > Attachments not found > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is n
$$Excel-Macros$$ Re: To Select a Pivot Item
Try this code it will help as per your requirement , if you are using your own code use this line pf.CurrentPage = "W001" Sub Create_pivot() Dim pt As PivotTable Dim pf As PivotField Dim rng As Range Set rng = ActiveSheet.UsedRange ActiveSheet.Range("A1").Select Set pt = ActiveSheet.PivotTableWizard Set pf = pt.PivotFields("Month") pf.Orientation = xlRowField Set pf = pt.PivotFields("Year") pf.Orientation = xlRowField Set pf = pt.PivotFields("Customer") pf.Orientation = xlPageField pf.CurrentPage = "W001" Set pf = pt.PivotFields("Sales") pf.Orientation = xlDataField pf.Function = xlSum End Sub Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/VBAEXCELSQL?ref=hl https://www.linkedin.com/profile/view?id=312532939 On Friday, 13 March 2015 13:34:46 UTC+5:30, Faisal PK wrote: > > I have the below code to select an item from the Pivotfield "Customer". > > Request if anybody can help with a code which don't loop through each item > because it leads slow performance as actual data has more items than in > sample sheet provided. > > Sub Test() > Dim Pt As PivotTable > Dim Pf As PivotField > Dim Pi As PivotItem > Dim PtSheet As Worksheet > Set PtSheet = Sheet2 > Set Pt = PtSheet.PivotTables(1) > For Each Pi In Pt.PivotFields("Customer").PivotItems > Pi.Visible = True > If Pi.Value = "W001" Then > Pi.Visible = True > Else > Pi.Visible = False > End If > Next Pi > End Sub > > Thanks for your helps. > > Regards, > Faisal PK > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Re: Help with combination formula
Check this attachment achieved with a macro. Change your numbers combination as per your requirement. Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/VBAEXCELSQL?ref=hl https://www.linkedin.com/profile/view?id=312532939 On Sunday, 15 March 2015 23:04:26 UTC+5:30, Will Sob wrote: > > l'm sorry please see attachment > > On Sun, Mar 15, 2015 at 2:45 AM, sahemur khan > wrote: > >> On Saturday, 14 March 2015 15:06:13 UTC+5:30, Will Sob wrote: >> > Hi, >> > Please I need help with the attached file. I want a formula that >> calculates how many times (10, 13, 17) combination has appeared within the >> range D5:I32 >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> > >> > FORUM RULES >> > >> > 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> > 2) Don't post a question in the thread of another member. >> > 3) Don't post questions regarding breaking or bypassing any security >> measure. >> > 4) Acknowledge the responses you receive, good or bad. >> > 5) Jobs posting is not allowed. >> > 6) Sharing copyrighted material and their links is not allowed. >> > >> > NOTE : Don't ever post confidential data in a workbook. Forum owners >> and members are not responsible for any loss. >> > --- >> > You received this message because you are subscribed to the Google >> Groups "MS EXCEL AND VBA MACROS" group. >> > To unsubscribe from this group and stop receiving emails from it, send >> an email to excel-macros...@googlegroups.com. >> > To post to this group, send email to excel-...@googlegroups.com. >> > Visit this group at http://groups.google.com/group/excel-macros. >> > For more options, visit https://groups.google.com/d/optout. >> > >> > -- >> > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> > >> > FORUM RULES >> > >> > 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> > 2) Don't post a question in the thread of another member. >> > 3) Don't post questions regarding breaking or bypassing any security >> measure. >> > 4) Acknowledge the responses you receive, good or bad. >> > 5) Jobs posting is not allowed. >> > 6) Sharing copyrighted material and their links is not allowed. >> > >> > NOTE : Don't ever post confidential data in a workbook. Forum owners >> and members are not responsible for any loss. >> > --- >> > You received this message because you are subscribed to the Google >> Groups "MS EXCEL AND VBA MACROS" group. >> > To unsubscribe from this group and stop receiving emails from it, send >> an email to excel-macros...@googlegroups.com. >> > To post to this group, send email to excel-...@googlegroups.com. >> > Visit this group at http://groups.google.com/group/excel-macros. >> > For more options, visit https://groups.google.com/d/optout. >> > >> > >> > >> > Attachments area >> > >> > Preview attachment Paks.xlsx >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > Paks.xlsx >> >> Attachments not found >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros...@googlegroups.com . >> To post to this group, send email to excel-...@googlegroups.com >> . >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of t
$$Excel-Macros$$ Extract Pages From Website
Hi, Normally I can do this, but I can't with this particular site starting at this page. - http://contests.covers.com/Handicapping/topHandicappers.aspx?sportid=9 - Each page contains 50 records. - Somehow, something needs to be macro programed (if possible), so that it goes to the next page and extract the next 50 records - so on and so forth until it encounters the end. - The hyperlinks must remain in tact (the same as attached. If this cannot be done in Excel, can anyone suggest a good relatively inexpensive third party software that can do this ? Thanks !! -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. TEST0016.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Re: Help with combination formula
thanks but it is not working when l use other values On Sun, Mar 15, 2015 at 7:11 PM, Mandeep baluja wrote: > Check this attachment achieved with a macro. Change your numbers > combination as per your requirement. > > Regards, > MandeepBaluja > Learningzmypassion. > https://www.facebook.com/VBAEXCELSQL?ref=hl > https://www.linkedin.com/profile/view?id=312532939 > > > > On Sunday, 15 March 2015 23:04:26 UTC+5:30, Will Sob wrote: >> >> l'm sorry please see attachment >> >> On Sun, Mar 15, 2015 at 2:45 AM, sahemur khan wrote: >> >>> On Saturday, 14 March 2015 15:06:13 UTC+5:30, Will Sob wrote: >>> > Hi, >>> > Please I need help with the attached file. I want a formula that >>> calculates how many times (10, 13, 17) combination has appeared within the >>> range D5:I32 >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> > >>> > FORUM RULES >>> > >>> > 1) Use concise, accurate thread titles. Poor thread titles, like >>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>> Advice will not get quick attention or may not be answered. >>> > 2) Don't post a question in the thread of another member. >>> > 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> > 4) Acknowledge the responses you receive, good or bad. >>> > 5) Jobs posting is not allowed. >>> > 6) Sharing copyrighted material and their links is not allowed. >>> > >>> > NOTE : Don't ever post confidential data in a workbook. Forum owners >>> and members are not responsible for any loss. >>> > --- >>> > You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> > To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros...@googlegroups.com. >>> > To post to this group, send email to excel-...@googlegroups.com. >>> > Visit this group at http://groups.google.com/group/excel-macros. >>> > For more options, visit https://groups.google.com/d/optout. >>> > >>> > -- >>> > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> > >>> > FORUM RULES >>> > >>> > 1) Use concise, accurate thread titles. Poor thread titles, like >>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>> Advice will not get quick attention or may not be answered. >>> > 2) Don't post a question in the thread of another member. >>> > 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> > 4) Acknowledge the responses you receive, good or bad. >>> > 5) Jobs posting is not allowed. >>> > 6) Sharing copyrighted material and their links is not allowed. >>> > >>> > NOTE : Don't ever post confidential data in a workbook. Forum owners >>> and members are not responsible for any loss. >>> > --- >>> > You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> > To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros...@googlegroups.com. >>> > To post to this group, send email to excel-...@googlegroups.com. >>> > Visit this group at http://groups.google.com/group/excel-macros. >>> > For more options, visit https://groups.google.com/d/optout. >>> > >>> > >>> > >>> > Attachments area >>> > >>> > Preview attachment Paks.xlsx >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > Paks.xlsx >>> >>> Attachments not found >>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>> and members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros...@googlegroups.com. >>> To post to this group, send email to excel-...@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros. >>> For
Re: $$Excel-Macros$$ Extract Pages From Website
Have you tried using the xml feed on http://www.covers.com/rss/index.aspx ? That may be your best bet - use a xml schema to import to excel Ta Martin On 16 March 2015 at 09:28, Bill Q wrote: > Hi, > > Normally I can do this, but I can't with this particular site starting at > this page. > > - http://contests.covers.com/Handicapping/topHandicappers.aspx?sportid=9 > > - Each page contains 50 records. > > - Somehow, something needs to be macro programed (if possible), so that it > goes to the next page and extract the next 50 records - so on and so forth > until it encounters the end. > > - The hyperlinks must remain in tact (the same as attached. > > If this cannot be done in Excel, can anyone suggest a good relatively > inexpensive third party software that can do this ? > > Thanks !! > > > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Extract Pages From Website
Hi Martin, Thanks for the reply. I have no idea how to work with this. I am not overly savvy with this ? Can you give me any insight on how this can be done ? Is it relatively easy ? On Sunday, 15 March 2015 21:39:53 UTC-4, Martin Wheeler wrote: > Have you tried using the xml feed on http://www.covers.com/rss/index.aspx > ? That may be your best bet - use a xml schema to import to excel > > > Ta > Martin > > On 16 March 2015 at 09:28, Bill Q > > wrote: > >> Hi, >> >> Normally I can do this, but I can't with this particular site starting at >> this page. >> >> - http://contests.covers.com/Handicapping/topHandicappers.aspx?sportid=9 >> >> - Each page contains 50 records. >> >> - Somehow, something needs to be macro programed (if possible), so that >> it goes to the next page and extract the next 50 records - so on and so >> forth until it encounters the end. >> >> - The hyperlinks must remain in tact (the same as attached. >> >> If this cannot be done in Excel, can anyone suggest a good relatively >> inexpensive third party software that can do this ? >> >> Thanks !! >> >> >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros...@googlegroups.com . >> To post to this group, send email to excel-...@googlegroups.com >> . >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Extract Pages From Website
Nothing easily explained. I have done it years ago but would not remember how to. Any I have no experience with RSS, just xml Hopefully someone with experience will help. Try googling this "how to download rss feed into excel" and that should get you going in the right direction On 16 March 2015 at 15:07, Bill Q wrote: > Hi Martin, > > Thanks for the reply. I have no idea how to work with this. I am not > overly savvy with this ? > > Can you give me any insight on how this can be done ? Is it > relatively easy ? > > On Sunday, 15 March 2015 21:39:53 UTC-4, Martin Wheeler wrote: > >> Have you tried using the xml feed on http://www.covers.com/rss/index.aspx >> ? That may be your best bet - use a xml schema to import to excel >> >> >> Ta >> Martin >> >> On 16 March 2015 at 09:28, Bill Q wrote: >> >>> Hi, >>> >>> Normally I can do this, but I can't with this particular site starting >>> at this page. >>> >>> - http://contests.covers.com/Handicapping/topHandicappers. >>> aspx?sportid=9 >>> >>> - Each page contains 50 records. >>> >>> - Somehow, something needs to be macro programed (if possible), so that >>> it goes to the next page and extract the next 50 records - so on and so >>> forth until it encounters the end. >>> >>> - The hyperlinks must remain in tact (the same as attached. >>> >>> If this cannot be done in Excel, can anyone suggest a good relatively >>> inexpensive third party software that can do this ? >>> >>> Thanks !! >>> >>> >>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros...@googlegroups.com. >>> To post to this group, send email to excel-...@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. T
Re: $$Excel-Macros$$ To Select a Pivot Item
Dear Faisal, Can u pls elborate more detail? I unable to understand your requirement. Regards, Gawli Anil On Sat, Mar 14, 2015 at 3:34 PM, Faisal Pk wrote: > Can anybody help me with a solution. > > Regards, > Faisal PK > > On Fri, Mar 13, 2015 at 11:04 AM, Faisal Pk wrote: > >> I have the below code to select an item from the Pivotfield "Customer". >> >> Request if anybody can help with a code which don't loop through each >> item because it leads slow performance as actual data has more items than >> in sample sheet provided. >> >> Sub Test() >> Dim Pt As PivotTable >> Dim Pf As PivotField >> Dim Pi As PivotItem >> Dim PtSheet As Worksheet >> Set PtSheet = Sheet2 >> Set Pt = PtSheet.PivotTables(1) >> For Each Pi In Pt.PivotFields("Customer").PivotItems >> Pi.Visible = True >> If Pi.Value = "W001" Then >> Pi.Visible = True >> Else >> Pi.Visible = False >> End If >> Next Pi >> End Sub >> >> Thanks for your helps. >> >> Regards, >> Faisal PK >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Best Regards > Faisal PK > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Re: Help with combination formula
send me the values which you are trying to get On Monday, March 16, 2015 at 3:24:40 AM UTC+5:30, Will Sob wrote: > > thanks but it is not working when l use other values > > On Sun, Mar 15, 2015 at 7:11 PM, Mandeep baluja > wrote: > >> Check this attachment achieved with a macro. Change your numbers >> combination as per your requirement. >> >> Regards, >> MandeepBaluja >> Learningzmypassion. >> https://www.facebook.com/VBAEXCELSQL?ref=hl >> https://www.linkedin.com/profile/view?id=312532939 >> >> >> >> On Sunday, 15 March 2015 23:04:26 UTC+5:30, Will Sob wrote: >>> >>> l'm sorry please see attachment >>> >>> On Sun, Mar 15, 2015 at 2:45 AM, sahemur khan wrote: >>> On Saturday, 14 March 2015 15:06:13 UTC+5:30, Will Sob wrote: > Hi, > Please I need help with the attached file. I want a formula that calculates how many times (10, 13, 17) combination has appeared within the range D5:I32 > > > > > > > > > > > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. > To post to this group, send email to excel-...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. > To post to this group, send email to excel-...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > > > > Attachments area > > Preview attachment Paks.xlsx > > > > > > > > > > Paks.xlsx Attachments not found -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCE
Re: $$Excel-Macros$$ Re: Help with combination formula
thanks for your reply: l have loads of values, l am trying to build a template where when l place numbers it should tell me how many triplet combination exist within a range 10, 13, 17 1,19, 22 7, 21,22 On Mon, Mar 16, 2015 at 4:25 AM, Mandeep Baluja wrote: > send me the values which you are trying to get > > On Monday, March 16, 2015 at 3:24:40 AM UTC+5:30, Will Sob wrote: >> >> thanks but it is not working when l use other values >> >> On Sun, Mar 15, 2015 at 7:11 PM, Mandeep baluja >> wrote: >> >>> Check this attachment achieved with a macro. Change your numbers >>> combination as per your requirement. >>> >>> Regards, >>> MandeepBaluja >>> Learningzmypassion. >>> https://www.facebook.com/VBAEXCELSQL?ref=hl >>> https://www.linkedin.com/profile/view?id=312532939 >>> >>> >>> >>> On Sunday, 15 March 2015 23:04:26 UTC+5:30, Will Sob wrote: l'm sorry please see attachment On Sun, Mar 15, 2015 at 2:45 AM, sahemur khan wrote: > On Saturday, 14 March 2015 15:06:13 UTC+5:30, Will Sob wrote: > > Hi, > > Please I need help with the attached file. I want a formula that > calculates how many times (10, 13, 17) combination has appeared within the > range D5:I32 > > > > > > > > > > > > > > > > > > > > > > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? > It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > > > FORUM RULES > > > > 1) Use concise, accurate thread titles. Poor thread titles, like > Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need > Advice will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Jobs posting is not allowed. > > 6) Sharing copyrighted material and their links is not allowed. > > > > NOTE : Don't ever post confidential data in a workbook. Forum owners > and members are not responsible for any loss. > > --- > > You received this message because you are subscribed to the Google > Groups "MS EXCEL AND VBA MACROS" group. > > To unsubscribe from this group and stop receiving emails from it, > send an email to excel-macros...@googlegroups.com. > > To post to this group, send email to excel-...@googlegroups.com. > > Visit this group at http://groups.google.com/group/excel-macros. > > For more options, visit https://groups.google.com/d/optout. > > > > -- > > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? > It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > > > FORUM RULES > > > > 1) Use concise, accurate thread titles. Poor thread titles, like > Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need > Advice will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Jobs posting is not allowed. > > 6) Sharing copyrighted material and their links is not allowed. > > > > NOTE : Don't ever post confidential data in a workbook. Forum owners > and members are not responsible for any loss. > > --- > > You received this message because you are subscribed to the Google > Groups "MS EXCEL AND VBA MACROS" group. > > To unsubscribe from this group and stop receiving emails from it, > send an email to excel-macros...@googlegroups.com. > > To post to this group, send email to excel-...@googlegroups.com. > > Visit this group at http://groups.google.com/group/excel-macros. > > For more options, visit https://groups.google.com/d/optout. > > > > > > > > Attachments area > > > > Preview attachment Paks.xlsx > > > > > > > > > > > > > > > > > > > > Paks.xlsx > > Attachments not found > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? > It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like > Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need > Advice will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, goo