$$Excel-Macros$$ What is pivot table, i could not do this.... Can any body help?
I started using Hlookup, Vlookup but what is pivot table and uses, if any body can tell.. Regards, Ashutosh -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
RE: $$Excel-Macros$$ What is pivot table, i could not do this.... Can any body help?
Pivot table is feature of excel that enable you to summarize the data very instantly , you can go through this link to get more information about pivot table: http://chandoo.org/wp/2009/08/19/excel-pivot-tables-tutorial/ Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashutosh Sharma Sent: 24 June 2012 1:52 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ What is pivot table, i could not do this Can any body help? I started using Hlookup, Vlookup but what is pivot table and uses, if any body can tell.. Regards, Ashutosh -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Re: Join Sql statement in VB using ADODB
Not necessarily! Regards, Sam On Sun, Jun 24, 2012 at 8:40 AM, David Grugeon da...@grugeon.com.au wrote: I thought SQL required all statements to end in a semicolon ?? On Sunday, 24 June 2012, TJ wrote: Thanks much I went ahead a copied that into the Editor and it looks like it added a few quotes and arranged some things automatically. Assume some sort of autocorrect mechanism. Ran it and it threw a Run Time error '424': Object Required on the VV_VESSEL_VISIT.VESSEL_ID , VV_VESSEL_VISIT.ARR_VOYAGE,line. Thanks again. Sub Get_Vessel_Schedule() Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Dim strSql As String Set cn = New ADODB.Connection Set rs = New ADODB.Recordset cn.Open ( _ User ID= _ ;Password= _ ;Data Source=mit.world _ ;Provider=MSDAORA.1) strSql = strSql = strSql vbLf select VESSEL.CODE, VESSEL.NAME, VV_VESSEL_VISIT.VESSEL_ID , VV_VESSEL_VISIT.ARR_VOYAGE, strSql = strSql vbLf VV_VESSEL_VISIT.DEP_VOYAGE, VV_VESSEL_VISIT.BERTH , VV_VESSEL_VISIT.MPH, strSql = strSql vbLf VV_VESSEL_VISIT.ESC_FORWARD_DRAFT, VV_VESSEL_VISIT.ATA , VV_VESSEL_VISIT.ATD, strSql = strSql vbLf VV_VESSEL_VISIT.ETA, VV_VESSEL_VISIT.ETD from VV_VESSEL_VISIT strSql = strSql vbLf join strSql = strSql vbLf VESSEL on VV_VESSEL_VISIT.VESSEL_ID=VESSEL.ID rs.Open strSql, cn Cells(6, 6).CopyFromRecordset rs End Sub On Friday, June 22, 2012 7:14:55 PM UTC-5, TJ wrote: Hello, Super new to thsi world but trying to put something together that will execute a simple SQL statement against on of our Oracle Databases and return the results. The Code for the Macro is below but I am getting Data Type is not Supported. Anyone help with that. Also, another question which may be simple sytax I do nto know, what is a good mechanism to break out the SQL statments accross various lines instead of one line? BTW, using Excel 2010. Thanks In Advance. Sub Get_Vessel_Schedule() Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Set cn = New ADODB.Connection Set rs = New ADODB.Recordset cn.Open ( _ User ID=User _ ;Password=Pass _ ;Data Source=My DB _ ;Provider=MSDAORA.1) rs.Open select VESSEL.CODE, VESSEL.NAME, VV_VESSEL_VISIT.VESSEL_ID, VV_VESSEL_VISIT.ARR_VOYAGE, VV_VESSEL_VISIT.DEP_VOYAGE, VV_VESSEL_VISIT.BERTH, VV_VESSEL_VISIT.MPH, VV_VESSEL_VISIT.ESC_FORWARD_ **DRAFT, VV_VESSEL_VISIT.ATA, VV_VESSEL_VISIT.ATD, VV_VESSEL_VISIT.ETA, VV_VESSEL_VISIT.ETD from VV_VESSEL_VISIT join VESSEL on VV_VESSEL_VISIT.VESSEL_ID=VESS**EL.ID http://VESSEL.ID, cn Cells(6, 6).CopyFromRecordset rs End Sub -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- David Grugeon -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Sam Mathai Chacko -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing
$$Excel-Macros$$ Re: VLOOKUP OR SUMPRODUCT FORMULA HELP
Hello Amit, Try this in G15 and copy down across. =SUMPRODUCT(ISNUMBER(MATCH($F15|$F$5:$F$9,$A$5:$A$21|$B$5:$B$21,0))+0,G$5:G$9) Regards, Haseeb -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ What is pivot table, i could not do this.... Can any body help?
Hi All, I even can't imagine my entire life without this Group.. Agar mai successful raha to The contribution of this excel group would be 99.99% to my success. 0.01% I would like to keep for myself. Thanks 2 All !!! On 6/24/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Ashutosh, Please find attached Pivot Table sample workbook. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Sun, Jun 24, 2012 at 1:51 PM, Ashutosh Sharma ashulov...@gmail.comwrote: I started using Hlookup, Vlookup but what is pivot table and uses, if any body can tell.. Regards, Ashutosh -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Macro to copy a macro from one workbook to another
I would like to create a macro to copy a macro from one workbooks module area to another workbooks ThisWorkbook area. The first workbook is the master and any other workbook would be subsets of the master. The idea is to have a macro that will further lock cells from input (sub workbook_open) on the child workbooks. Any help would be appreciated Rich -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Interesteing Problem : - Morefunc Addin - Why it could not be embedded like in Excel 2003?
Hi all, Good Morning. There is an exciting challenge ahead of me. Has any one worked on Morefunc Addin ? Mconcat fn is used as an add - in in excel 2003. There is a Big 200 MB Model, where in one of the worksheets, Mconcat fn ( utility of the add-in) is used. This add-in can easily be embedded in excel 2003, means when we are transferring the file from one system to another, u don't explicitly need to install add in again go the system. But issue is when we are moving this model from 2003 to 2010 version. We can't embed the same and each time we need to explicitly install the add - in into every system. There is an issue of it being able to be embedded into Excel 2003 but not in excel 2007/ 2010 which cannot be solved. Need particulaly help in 2 things :- 1. There is an issue of it being able to be embedded into Excel 2003 but not in excel 2007/ 2010 which cannot be solved according to me. Still if someone knows the trick, please let me know. 2. If anyone has used Mconcat function. ? What does it do and whats the way around, can we replace mconcat function using the addi-n by complex excel formula ? Please help ! Warm Regards Ankur Aggarwal Analyst -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ age month days calculations - Reg
Thanks noorain babu..!! sir this command is very useful for me, Thanks so much for u. On Sat, Jun 23, 2012 at 12:08 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Mothilal, If you don't want in Text Format Please use =DATEDIF(D2,E2,d) select formula cell, press ctrl+1 and type in custom yy mm dd See attached sheet -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Fri, Jun 22, 2012 at 12:55 PM, jmothilal gjmothi...@gmail.com wrote: Dear any one i want find age month days calculations in between two days. pls help me thanks with -- J.Mothilal : Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2 -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2* -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com