$$Excel-Macros$$ Automatic sum for three month
Dear experts I required formula as like Automatic sum for three month.PFA sheet with detailed Regards Amar -- 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. year.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Change date format
Dear experts, I have a data in which date format is Text, I want to change in date format to filter data date and month wise. I have change manually this thing by pressing FR and Enter key. Please provide Macro or function to change the format, the example file is attached herewith. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- 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. date.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Change date format
use this formula : CONCATENATE(DAY(C4),-,MONTH(C4),-,YEAR(C4)) On Wed, Jul 16, 2014 at 9:52 AM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, I have a data in which date format is Text, I want to change in date format to filter data date and month wise. I have change manually this thing by pressing FR and Enter key. Please provide Macro or function to change the format, the example file is attached herewith. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- 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. -- *Ahmed Bawazir* *احمد باوزير* -- 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$$ Change date format
Select one column at a time containing data, then goto Data Text to column (or just press Alt + D then E). Select Fixed width press Next 2 time, now select Date existing date format viz. DMY for Date-Month-Year and press finish. Cheers!! On Wed, Jul 16, 2014 at 12:22 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, I have a data in which date format is Text, I want to change in date format to filter data date and month wise. I have change manually this thing by pressing FR and Enter key. Please provide Macro or function to change the format, the example file is attached herewith. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- 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$$ - merge and pivot excels
Hello .. Need urgent help on this please.. Thanks. On Mon, Jul 14, 2014 at 8:49 PM, pradeep palande bunty5...@gmail.com wrote: Okay Pramod.. first of all Thanks for your quick response. I assume below is the help you needed to move forward on this topic. - There are 35 to 40 excels in similar format i receive every day - I want only ID wise summary and activity wise summary from second sheet needs to be consolidated from all these files in to one macro based fie - my objective is to have one monthly file.. like dialy 35 files and 2 sheets needs to be converted in one monthly file.. - after every days merging task - i want pivots to be prepared and refreshed automatically... i hope this explains what i need at high level.. Let me know if you need anything specific about this.. Thanks.. PP On Sun, Jul 13, 2014 at 3:06 PM, Pramod Singh pramod...@gmail.com wrote: Need more explain on this topic.plzzz Pramod On 13 Jul 2014 14:48, pradeep palande bunty5...@gmail.com wrote: Can someone help me on this please.. i am in need of this and looking for solution otherwise i have to keep suffering for hours every day. thanks in advance On Sun, Jul 13, 2014 at 1:11 AM, pradeep palande bunty5...@gmail.com wrote: Hello Macro Experts, Need your help… Please see attached excel report (entered all dummy data due to confidentiality). I receive almost 80 separate reports in same format. I need you experts to help me in creating macro which will merge and pivot these reports on daily basis. Some important point for you to know before writing / helping me in creating macro. - Daily basis 30 – 40 files I receive via mail in outlook - 2 tabs needs to be merged / copied in master file - I need file name to be copied in first column - Period which is mentioned on the top of the sheet needs to be copied in second column - Activity needs to be copied in third column - Then remaining data - The 2 sheet names “op summary” and “defect summary” are consistent across the excels - Master file is having same 2 sheets with similar names where inputs from all the files needs to be copied after last row - After merging pivot table needs to be generated for sheet one (op summary) o It should have summary with o IDs in column o By activity below data points in row o Pages checked o Pages with errors o Page wise alpha errors o Page wise number errors o Accuracy Similar type of pivot for other sheet too... Let me know if anyone can help me in to this urgently… I receive these files in xls format but I am using excel 2007 which is xlsx format so macro needs to be compatible with both the formats I belive.. -- 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
Re: $$Excel-Macros$$ Change date format
Oh Thanks to both of you, its very easy...Cheers!! Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Wed, Jul 16, 2014 at 12:29 PM, Amresh Maurya amreshkushw...@gmail.com wrote: see the attachment On Wed, Jul 16, 2014 at 12:22 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, I have a data in which date format is Text, I want to change in date format to filter data date and month wise. I have change manually this thing by pressing FR and Enter key. Please provide Macro or function to change the format, the example file is attached herewith. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their 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: How to direct multiple hyperlink ?
Dear Pramod sir, Can we get the link in exel too. I mean if the link data is pulling the data from web, than the same link should be capture with respect to its row. and than loop to next link, same the running link should be pasted in its respective rows till all the link is completed pulling data. Please refer below table: In End of the column there is link. Can it be done sir. Date HS Code Description Origin Country Port of Discharge Unit Quantity Value (INR) Per Unit (INR) Link 28-Jun-14 84433290 C31C598256/C5982560030 TM-T81-256: BOX PRINTER FOR POS MADEIN CHINA China Chennai Sea NOS 168 9,53,013 5,673 https://www.zauba.com/import-tm t81 printer pos-hs-code.html 28-Jun-14 84433290 C31C598256/C5982560030 TM-T81-256: BOX PRINTER FOR POS MADEIN CHINA China Chennai Sea NOS 336 19,06,027 5,673 https://www.zauba.com/import-tm t81 printer pos-hs-code.html 12-Jun-14 84433290 C31C598256/C5982560030 TM-T81-256: BOX PRINTER FOR POS MADEIN CHINA China Chennai Sea NOS 336 19,04,160 5,667 https://www.zauba.com/import-tm t81 printer pos-hs-code.html 12-Jun-14 84433290 C31C598256/C5982560030 TM-T81-256: BOX PRINTER FOR POS MADEIN CHINA China Chennai Sea NOS 168 9,52,080 5,667 https://www.zauba.com/import-tm t81 printer pos-hs-code.html 05-Jun-14 84433290 C31C598254/C5982540030 TM-T81-254: BOX PRINTER FOR POS MADEIN CHINA China Chennai Sea NOS 168 9,53,172 5,674 https://www.zauba.com/import-tm t81 printer pos-hs-code.html 23-May-14 84433290 C31C598256/C5982560030 TM-T81-256: BOX PRINTER FOR POS MADEIN CHINA China Chennai Sea NOS 336 17,16,988 5,110 https://www.zauba.com/import-tm t81 printer pos-hs-code.html 12-May-14 84433290 C31C598256/C5982560030 TM-T81-256: BOX PRINTER FOR POS MADEIN CHINA China Chennai Sea NOS 336 17,45,175 5,194 https://www.zauba.com/import-tm t81 printer pos-hs-code.html 05-May-14 84433290 C31C598256/C5982560030 TM-T81-256: BOX PRINTER FOR POS MADEIN CHINA China Chennai Sea NOS 336 17,22,127 5,125 https://www.zauba.com/import-tm t81 printer pos-hs-code.html 05-May-14 84433290 C31C598256/C5982560030 TM-T81-256: BOX PRINTER FOR POS MADEIN CHINA China Chennai Sea NOS 168 8,61,063 5,125 https://www.zauba.com/import-tm t81 printer pos-hs-code.htmlDate HS Code Description Origin Country Port of Discharge Unit Quantity Value (INR) Per Unit (INR) https://www.zauba.com/import-tm T82 printer pos-hs-code.html 28-Jun-14 84433290 C31CD52354/CD523540130 TM-T82II-354 BOX PRINTER FOR POS MADEIN CHINA China Chennai Sea NOS 27 1,69,146 6,265 https://www.zauba.com/import-tm T82 printer pos-hs-code.html 12-Jun-14 84433290 C31CD52354/CD523540130 TM-T82II-354: BOX PRINTER FOR POS MADE IN CHINA China Chennai Sea NOS 53 3,31,702 6,259 https://www.zauba.com/import-tm T82 printer pos-hs-code.html 12-Jun-14 84433290 C31CD52352/CD523520130 TM-T82II-352: BOX PRINTER FOR POS MADE IN CHINA China Chennai Sea NOS 80 5,00,683 6,259 https://www.zauba.com/import-tm T82 printer pos-hs-code.html 05-Jun-14 84433290 C31CD52352/CD523521030 TM-T82II-352: BOX PRINTER FOR POS MADE IN CHINA China Chennai Sea NOS 144 9,02,263 6,266 https://www.zauba.com/import-tm T82 printer pos-hs-code.html 29-May-14 84433290 C31CD52353/CD523530130 TM-T82II-353: BOX PRINTER FOR POS MADE IN CHINA China Chennai Sea NOS 20 1,21,261 6,063 https://www.zauba.com/import-tm T82 printer pos-hs-code.html 25-Apr-14 84433290 C31CD52352/CD523520130 TM-T82II-352: BOX PRINTER FOR POS MADE IN CHINA Hong Kong Chennai Sea NOS 44 2,38,487 5,420 https://www.zauba.com/import-tm T82 printer pos-hs-code.html 25-Apr-14 84433290 C31CD52354/CD523540130 TM-T82II-354: BOX PRINTER FOR POS MADE IN CHINA Hong Kong Chennai Sea NOS 97 5,25,755 5,420 https://www.zauba.com/import-tm T82 printer pos-hs-code.html 04-Apr-14 84433290 C31CD52354/CD523540130 TM-T82II-354: BOX PRINTER FOR POS MADE IN CHINA Hong Kong Chennai Sea NOS 81 4,30,271 5,312 https://www.zauba.com/import-tm T82 printer pos-hs-code.html 04-Apr-14 84433290 C31CD52352/CD523520130 TM-T82II-352: BOX PRINTER FOR POS MADE IN CHINA Hong Kong Chennai Sea NOS 25 1,32,800 5,312 https://www.zauba.com/import-tm T82 printer pos-hs-code.html Thanking you Regards, Nitya On Tue, Jul 15, 2014 at 12:10 PM, Nitya nityanandadole...@gmail.com wrote: Perfectly working, thank you Pramod sir and victor sir. Thanks to all experts. Regards, Nitya On Tue, Jul 15, 2014 at 11:19 AM, Pramod Singh pramod...@gmail.com wrote: Hi Nitya, Please find the Attached file. As per your requirement.. Hope This will fine for you. Warm Regards Pramod Bisht On Tue, Jul 15, 2014 at 9:23 AM, Nitya nityanandadole...@gmail.com wrote: Dear Experts, Any update on this. Thanks. From: Nitya nityanandadole...@gmail.com Date: Mon, Jul 14, 2014 at 5:17 PM Subject: How to direct multiple hyperlink ? To: excel-macros@googlegroups.com Dear Aii experts, Please help in my query!! Please find the attachment explained clearly. How to direct multiple hyperlink ? There are web hyperlink in left side: All the
$$Excel-Macros$$ common kgid no problem
Hi Friends, I need your help to find common kgid no (like aadhar card no) which is entered in A,B,C,D .up to n th column (up to n no of section) i tried conditional formatting, its too slow and not for regular work so i need macro code. The problem here is how to find out the kgid Nos who worked in many section along with section. ex 22898585916 worked in Section 1 Section 9. 19845984612 worked in 1,2,7,8 sections hope you understood. sir i need macro code for this Thanks in advance, Daya -- 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. common member kgid no with section.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ common kgid no problem
Hi Friends, I need your help to find common kgid no (like aadhar card no) which is entered in A,B,C,D .up to n th column (up to n no of section) i tried conditional formatting, its too slow and not for regular work so i need macro code. The problem here is how to find out the kgid Nos who worked in many section along with section. ex 22898585916 worked in Section 1 Section 9. 19845984612 worked in 1,2,7,8 sections hope you understood. sir i need macro code for this Thanks in advance, Daya -- 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. common member kgid no with section.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Re: How to direct multiple hyperlink ?
Yah this can be done I am busy right now .when I have time I must solve this one.. Pramod On 16 Jul 2014 12:37, Nitya nityanandadole...@gmail.com wrote: Dear Pramod sir, Can we get the link in exel too. I mean if the link data is pulling the data from web, than the same link should be capture with respect to its row. and than loop to next link, same the running link should be pasted in its respective rows till all the link is completed pulling data. Please refer below table: In End of the column there is link. Can it be done sir. Date HS Code Description Origin Country Port of Discharge Unit Quantity Value (INR) Per Unit (INR) Link 28-Jun-14 84433290 C31C598256/C5982560030 TM-T81-256: BOX PRINTER FOR POS MADEIN CHINA China Chennai Sea NOS 168 9,53,013 5,673 https://www.zauba.com/import-tm t81 printer pos-hs-code.html 28-Jun-14 84433290 C31C598256/C5982560030 TM-T81-256: BOX PRINTER FOR POS MADEIN CHINA China Chennai Sea NOS 336 19,06,027 5,673 https://www.zauba.com/import-tm t81 printer pos-hs-code.html 12-Jun-14 84433290 C31C598256/C5982560030 TM-T81-256: BOX PRINTER FOR POS MADEIN CHINA China Chennai Sea NOS 336 19,04,160 5,667 https://www.zauba.com/import-tm t81 printer pos-hs-code.html 12-Jun-14 84433290 C31C598256/C5982560030 TM-T81-256: BOX PRINTER FOR POS MADEIN CHINA China Chennai Sea NOS 168 9,52,080 5,667 https://www.zauba.com/import-tm t81 printer pos-hs-code.html 05-Jun-14 84433290 C31C598254/C5982540030 TM-T81-254: BOX PRINTER FOR POS MADEIN CHINA China Chennai Sea NOS 168 9,53,172 5,674 https://www.zauba.com/import-tm t81 printer pos-hs-code.html 23-May-14 84433290 C31C598256/C5982560030 TM-T81-256: BOX PRINTER FOR POS MADEIN CHINA China Chennai Sea NOS 336 17,16,988 5,110 https://www.zauba.com/import-tm t81 printer pos-hs-code.html 12-May-14 84433290 C31C598256/C5982560030 TM-T81-256: BOX PRINTER FOR POS MADEIN CHINA China Chennai Sea NOS 336 17,45,175 5,194 https://www.zauba.com/import-tm t81 printer pos-hs-code.html 05-May-14 84433290 C31C598256/C5982560030 TM-T81-256: BOX PRINTER FOR POS MADEIN CHINA China Chennai Sea NOS 336 17,22,127 5,125 https://www.zauba.com/import-tm t81 printer pos-hs-code.html 05-May-14 84433290 C31C598256/C5982560030 TM-T81-256: BOX PRINTER FOR POS MADEIN CHINA China Chennai Sea NOS 168 8,61,063 5,125 https://www.zauba.com/import-tm t81 printer pos-hs-code.htmlDate HS Code Description Origin Country Port of Discharge Unit Quantity Value (INR) Per Unit (INR) https://www.zauba.com/import-tm T82 printer pos-hs-code.html 28-Jun-14 84433290 C31CD52354/CD523540130 TM-T82II-354 BOX PRINTER FOR POS MADEIN CHINA China Chennai Sea NOS 27 1,69,146 6,265 https://www.zauba.com/import-tm T82 printer pos-hs-code.html 12-Jun-14 84433290 C31CD52354/CD523540130 TM-T82II-354: BOX PRINTER FOR POS MADE IN CHINA China Chennai Sea NOS 53 3,31,702 6,259 https://www.zauba.com/import-tm T82 printer pos-hs-code.html 12-Jun-14 84433290 C31CD52352/CD523520130 TM-T82II-352: BOX PRINTER FOR POS MADE IN CHINA China Chennai Sea NOS 80 5,00,683 6,259 https://www.zauba.com/import-tm T82 printer pos-hs-code.html 05-Jun-14 84433290 C31CD52352/CD523521030 TM-T82II-352: BOX PRINTER FOR POS MADE IN CHINA China Chennai Sea NOS 144 9,02,263 6,266 https://www.zauba.com/import-tm T82 printer pos-hs-code.html 29-May-14 84433290 C31CD52353/CD523530130 TM-T82II-353: BOX PRINTER FOR POS MADE IN CHINA China Chennai Sea NOS 20 1,21,261 6,063 https://www.zauba.com/import-tm T82 printer pos-hs-code.html 25-Apr-14 84433290 C31CD52352/CD523520130 TM-T82II-352: BOX PRINTER FOR POS MADE IN CHINA Hong Kong Chennai Sea NOS 44 2,38,487 5,420 https://www.zauba.com/import-tm T82 printer pos-hs-code.html 25-Apr-14 84433290 C31CD52354/CD523540130 TM-T82II-354: BOX PRINTER FOR POS MADE IN CHINA Hong Kong Chennai Sea NOS 97 5,25,755 5,420 https://www.zauba.com/import-tm T82 printer pos-hs-code.html 04-Apr-14 84433290 C31CD52354/CD523540130 TM-T82II-354: BOX PRINTER FOR POS MADE IN CHINA Hong Kong Chennai Sea NOS 81 4,30,271 5,312 https://www.zauba.com/import-tm T82 printer pos-hs-code.html 04-Apr-14 84433290 C31CD52352/CD523520130 TM-T82II-352: BOX PRINTER FOR POS MADE IN CHINA Hong Kong Chennai Sea NOS 25 1,32,800 5,312 https://www.zauba.com/import-tm T82 printer pos-hs-code.html Thanking you Regards, Nitya On Tue, Jul 15, 2014 at 12:10 PM, Nitya nityanandadole...@gmail.com wrote: Perfectly working, thank you Pramod sir and victor sir. Thanks to all experts. Regards, Nitya On Tue, Jul 15, 2014 at 11:19 AM, Pramod Singh pramod...@gmail.com wrote: Hi Nitya, Please find the Attached file. As per your requirement.. Hope This will fine for you. Warm Regards Pramod Bisht On Tue, Jul 15, 2014 at 9:23 AM, Nitya nityanandadole...@gmail.com wrote: Dear Experts, Any update on this. Thanks. From: Nitya nityanandadole...@gmail.com Date: Mon, Jul 14, 2014 at 5:17 PM Subject: How to
$$Excel-Macros$$ Transpose column to row basis column heading
Hi All, Attached file has two tabs (Raw Data OutCome). What I am trying to achieve is transposing column F G of the Raw Data onto OutCome tab. The catch is to transpose basis the role which is listed as heading of Outcome tab. If in the list we have more than open person with similar role, we can concatenate the names as done in cell L3 of OutCome tab. If there is no name for any role in the data we need to put a - in OutCome tab. Request your help to solve this with VBA. Thanks in advance for your help and efforts. -- 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. Resource data - 20140715.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ VBA to populate cells based on cirteria
Dear experts, I need your help to populate the cells in the attached spreadsheet. -- 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. Sample Test.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ common kgid no problem
hi do you want output to be shown in excel sheet? On Wed, Jul 16, 2014 at 2:10 PM, daya p princedaya2...@gmail.com wrote: Hi Friends, I need your help to find common kgid no (like aadhar card no) which is entered in A,B,C,D .up to n th column (up to n no of section) i tried conditional formatting, its too slow and not for regular work so i need macro code. The problem here is how to find out the kgid Nos who worked in many section along with section. ex 22898585916 worked in Section 1 Section 9. 19845984612 worked in 1,2,7,8 sections hope you understood. sir i need macro code for this Thanks in advance, Daya -- 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$$ VBA to populate cells based on cirteria
You're welcome! I just figured that if I simply supplies the formula, there would be some that would like to see how it came together, so I'd just take care of that right away! 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: Renton Cheung rentonche...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, July 16, 2014 9:41 AM Subject: Re: $$Excel-Macros$$ VBA to populate cells based on cirteria Hi Paul. This works quite well. Such a solution with well explanation! Thank you! On Wed, Jul 16, 2014 at 11:07 PM, Paul Schreiner schreiner_p...@att.net wrote: I used this formula in Cell E2: =IF(OR((COLUMN()-4)=$C3,MOD((COLUMN()-4)-$C3,$D3)=0),$B3,) then copied it to the other cells. Basically, it uses two concepts: the Data portion occupies (4) cells. A:D, so the column for year 1 is in column E. so, column() - 4 gives the Year Number of 1 for E, 2 for F, and so on. So, if the (column()-4) = the Initial Year, then it inserts the value from B. =IF((COLUMN()-4)=$C3,$B3,) Now, if to find if a given year is a multiple of the frequency offset by the initial year, I used: =IF(MOD((COLUMN()-4)-$C3,$D3)=0,$B3,) This uses the same column offset calculation: Column()-4 then subtracts the initial year value -$C3 This basically gives you the number of years since the initial value. the MOD() function basically takes this value and divides it by the frequency and returns the number left over. that is: for the first item, the initial year is 1 and the frequency is 2. So, looking at year #6 in column J, the column number is 10 column()-4 = 6 6-Initial Year (1) = 5 mod(5,2) is the same as 5/2 which is 2 with a remainder of 1, so mod(5,2) = 1 I test to see if it =0 (mod is EXACTLY a multiple of the frequency from the initial year) Since it is not, nothing is entered. but if we look at year number 7, the column number is 11 11-4 = 7 7-1 = 6 mod 6,2 = 0 so the value for item A WOULD appear in year 7. I then combined: COLUMN()-4)=$C3 MOD((COLUMN()-4)-$C3,$D3)=0 within an OR() statement: OR((COLUMN()-4)=$C3, MOD((COLUMN()-4)-$C3,$D3)=0) and used THAT as the conditional statement of the IF() function. give it a try and see if it works for you. 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: Huard rentonche...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, July 16, 2014 8:02 AM Subject: $$Excel-Macros$$ VBA to populate cells based on cirteria Dear experts, I need your help to populate the cells in the attached spreadsheet. -- 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
$$Excel-Macros$$ Urgent required QA Tester (Manual UI) - Anoka, MN
*Please respond to gurjant.si...@damcosoft.com gurjant.si...@damcosoft.com* *Position: QA Tester (Manual UI Tester) (4 positions)Location: Anoka, MNDuration: Long term* Best Rate: $40-42/hr MAXX Note: *Need complete educational details along with two professional references from two most recent projects at the time of resume submission.* Requirements/Skills: •Total Experience: 5-6+ years •Manual Test the UI applications •Review Documentation and see if it is aligned with actual requirements •Review already written test cases and see if that is aligned with requirements •Communicate with Business, tech teams to understand functionalities which may not be documented •Provide Test status, test metrics etc •Some Database Analysis experience Thanks and Regards, Gurjant Singh - (Gary) Technical Recruiter +1 212 389 9503 ext 208 E: gurjant.si...@damcosoft.com *NY Office: *112 W 34th St, 18th Floor, New York, NY 10120 *NJ Office: *894 Green Street, Suite B, Iselin, NJ 08830 Corporate: www.damcosoft.com *[image: Description: cid:image002.jpg@01CEDAE3.C3BE19D0]* *[image: Description: cid:image006.jpg@01CEDAE5.F56ED350]* *P** Please consider the planet before printing | Switch off as you go |**q**Recycle always |* *Your child deserves a better world* *CONFIDENTIALITY NOTICE:** This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message* -- 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.
$$Excel-Macros$$ Conditional Formatting for a cell based on another
I have an excel sheet and i want some cells to be highlighted by some colors if other 3 cells filled by text. please see the attached example: What i mean that Cell A to be highlighted Yellow if Cell A1 filled by text And to be highlighted Blue if Cell B1 filled by text And to be highlighted Green if Cell C1 filled by text -- 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. 111.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Data Logging
Hi There are a lot of commercial software based around Excel for live logging of incoming data from instruments etc. Where can I find a site that covers the vba required for receiving data. Say direct from data recorders and/or thru SMS and a website. That is a temperature is sent by SMS from a phone or equivalent device to a webpage and then on into the Excel workbook or whatever procedure is best to get data from a remote location (with phone coverage) to the office. Thanks Charles Harris -- 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.
$$Excel-Macros$$ Excel commands to Electronic user interface.
Hi Looking for vba requirements for exporting commands (on, off, etc) to a relay board for control of led lights etc. Can someone send me in the right direction etc. Do I need an add-in or activate some controls. Using 2000 at the moment but shortly onto Excel 2013. Thankyou Charles Harris -- 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.
$$Excel-Macros$$ Re: Excel commands to Electronic user interface.
Hi Charles, To interface with the 'outside world' as such you need to have a method of communication. Typically you would use something like a serial or network interface to send / receive commands to a programmable logic controller (PLC) and the controller would then do the actual work of firing relays etc... Both serial and network communications can be achieved at a good level of granular control through VBA, but before you head down either path you need to know how you are going to control the PLC and which PLC you are going to use. A common choice these days might be an Arduino for example. Sometimes manufacturers of lighting control systems have their own PLC's with their proprietary interfaces (same goes for many types of components) and perhaps you can interface directly to that. Others use 'head-end' control software (mostly for industrial applications) that usually have some sort of API that you can use to communicate with the software and issue commands / receive data with it. Do you have an approach you are going to use? If so we can probably figure out a way to get Excel talking to it. Cheers The Frog -- 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.
$$Excel-Macros$$ Re: Multiple Web Page Extraction
Pramod, Would you have any idea why it stops ? On Monday, July 14, 2014 7:16:58 AM UTC-4, Bill Q wrote: A great first effort Pramod. I called it up a few times. I always get the same 3 first lines returned - then I get the following error from your code and it stops: wk.Cells(i, x).Value = TDelement.innertext Perhaps it has something to do with the amount of time that the site needs to load. I also encounter pop ups often. The returned data is good, but does not return the hyperlink. Your data: *Rank**Member**WLT**Pct**RSI**Units**Record* *History**Status*1rlfishe 18-5-1 78.26%3.676250ViewView 2dragon5868 18-5-1 78.26%3.676250ViewView 3Eagle Sports 17-5-2 77.27%3.275750ViewView My Data: 1 *rlfishe* http://spaces.covers.com/rlfishe 18-5-1 78.26% 3.67 +6250 *View* http://contests.covers.com/sportscontests/recordsByDate.aspx?interval=overallcontestID=0ur=389029sportID=3 *View* http://contests.covers.com/sportscontests/profile.aspx?user=389029sportID=3 2 *dragon5868* http://spaces.covers.com/dragon5868 18-5-1 78.26% 3.67 +6250 *View* http://contests.covers.com/sportscontests/recordsByDate.aspx?interval=overallcontestID=0ur=397374sportID=3 *View* http://contests.covers.com/sportscontests/profile.aspx?user=397374sportID=3 3 *Eagle Sports* http://spaces.covers.com/B3450F20376A40C79BEDE2B805A4492C 17-5-2 77.27% 3.27 +5750 *View* http://contests.covers.com/sportscontests/recordsByDate.aspx?interval=overallcontestID=0ur=-7699sportID=3 *View* http://contests.covers.com/sportscontests/profile.aspx?user=-7699sportID=3 On Sunday, July 13, 2014 2:51:21 PM UTC-4, Bill Q wrote: Hi, I would like to have (hopefully) a simple code made to extra all the pages from a URL.This URL is static and requires that a next page button be pressed to get to the next page of data. I am not sure how easy or complicated this is. I would ideally like it to start extracting on the first page and continue until it reaches the last page. All hyperlinks must remain as in attached sample. The main URL page is in cell A1. Please see attached. Thank you. -- 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: Consolidating Multiple Categories from Separate New Workbooks Each Week
Hi, Thanks for your response. I have spent a little while going over the code to figure out what is going on. I really like the filename parsing for determining what column to put data in. That will be very useful. I don't think I explained the consolidating objective well enough and I am hoping you could offer some insight on this as well. For this, there are multiple rows that fall under the same categories. So in the example there are 2 rows of Yellow/A2/R. One has a value of 6 and the other has a value of 1. In the Overall spreadsheet, I'm trying to get a sum every time that happens. In this case the sum would be 7 for Yellow/A2/R. Would that change the size of the dictionary too much and make it incompatible with the Overall spreadsheet. In the example we would be going from 12 rows of data in the Weekly spreadsheet down to 8 in the Overall spreadsheet so it wouldn't be able to transfer from 1 cell in the Weekly to 1 cell in the Overall. I have looked around a bit and it seems like I might be able to do something like this with the Dictionary? And if I can do that, would that significantly change your example files? Best, Sean On Thursday, July 10, 2014 12:24:07 PM UTC-7, Paul Schreiner wrote: So, you receive a file whose NAME includes that date. Then, in your file, you have data that corresponds to the data in the received file and you wish to add the corresponding value from the Qty column to the correct row of data? it's actually pretty simple and straight-forward. there's some Preparation issues. What I'd do is: Use a FileDialog box to select the input file. Then, parse the file name to determine the date. Look across the columns for the matching date to find the column. If it doesn't find it, add it to the end. Next, read in the entire list from the summary and load a Dictionary object with the index being the concatenation of the color-category1-category2 and use this to save the row number. then, open the picked file and read the input data. use the concatenated color-category1-category2 to locate the row in the summary and store the qty. I threw together some sample files and a quick macro and functions. I've hard coded a startup folder (since you didn't say where the files would be stored) C:\temp\VBA\Consolidate if you put the sample file there, it should work. You can double-click on cell A1 in the Summary sheet and it should begin (or run the macro called Load_DataFile) I didn't put any comments in the code, so you'll have to use the Debugger to try to follow the flow. let me know if you have any questions. *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:* Sean M smc...@gmail.com javascript: *To:* excel-...@googlegroups.com javascript: *Sent:* Thursday, July 10, 2014 1:23 PM *Subject:* $$Excel-Macros$$ Re: Consolidating Multiple Categories from Separate New Workbooks Each Week Hi, Sorry for the delayed response. I could still use help on this project. It had been set aside since I wasn't able to get past this issue. On Monday, June 23, 2014 10:31:32 AM UTC-7, Sean M wrote: Hey Everyone, I'm having a hard time finding a solution to this issue and I'm hoping someone with more Excel/VBA knowledge than my novice self can offer some suggestions. Every week I receive a new Excel file that has information I would like to consolidate to a separate Overall Excel file. For example, I will get a new spreadsheet every week (named X_Year-Month-Day. xlsx) with data as follows: *Weekly File* *Color* *x* *x* *Category 1* *x* *Category 2* *Quantity* Yellow N/A N/A A1 N/A L 2 Yellow N/A N/A A2 N/A R 6 Yellow N/A N/A A1 N/A R 4 Yellow N/A N/A A2 N/A R 1 Green N/A N/A B2 N/A L 3 Green N/A N/A B2 N/A L 0 Green N/A N/A B1 N/A L 4 Green N/A N/A B1 N/A R 9 Blue N/A N/A C1 N/A L 8 Blue N/A N/A C2 N/A R 5 Blue N/A N/A C2 N/A R 1 Blue N/A N/A C1 N/A L 3 and I would like to create a macro that will update my Overall Excel file with the new values each week in the following format: *Overall File* *Color* *Category 2* *Category 1* *6/20/2014* *6/27/2014* *7/4/2014* Yellow L A1 2 Yellow R A1 4 Yellow R A2 7 Green L B1 4 Green L B2 3 Green R B1 9 Blue L C1 11 Blue R C2 6 The list of colors was too long to list here, so I made the example smaller for simplicity. I'm guessing the format will be the same. Right now I am consolidating and entering the quantity values by hand and would really like to automate the process a bit with a macro button or anything else I may not even know about yet. I have found
Re: $$Excel-Macros$$ Re: Multiple Web Page Extraction
Hi Bill, The website is so heavy so it is taking lot of time to load .I am also working on it from another method. Regard Pramod On Thu, Jul 17, 2014 at 7:23 AM, Bill Q ronsmith...@gmail.com wrote: Pramod, Would you have any idea why it stops ? On Monday, July 14, 2014 7:16:58 AM UTC-4, Bill Q wrote: A great first effort Pramod. I called it up a few times. I always get the same 3 first lines returned - then I get the following error from your code and it stops: wk.Cells(i, x).Value = TDelement.innertext Perhaps it has something to do with the amount of time that the site needs to load. I also encounter pop ups often. The returned data is good, but does not return the hyperlink. Your data: *Rank**Member**WLT**Pct**RSI**Units**Record* *History**Status*1rlfishe 18-5-1 78.26%3.676250ViewView 2dragon5868 18-5-1 78.26%3.676250ViewView 3Eagle Sports 17-5-2 77.27%3.275750ViewView My Data: 1 *rlfishe* http://spaces.covers.com/rlfishe 18-5-1 78.26% 3.67 +6250 *View* http://contests.covers.com/sportscontests/recordsByDate.aspx?interval=overallcontestID=0ur=389029sportID=3 *View* http://contests.covers.com/sportscontests/profile.aspx?user=389029sportID=3 2 *dragon5868* http://spaces.covers.com/dragon5868 18-5-1 78.26% 3.67 +6250 *View* http://contests.covers.com/sportscontests/recordsByDate.aspx?interval=overallcontestID=0ur=397374sportID=3 *View* http://contests.covers.com/sportscontests/profile.aspx?user=397374sportID=3 3 *Eagle Sports* http://spaces.covers.com/B3450F20376A40C79BEDE2B805A4492C 17-5-2 77.27% 3.27 +5750 *View* http://contests.covers.com/sportscontests/recordsByDate.aspx?interval=overallcontestID=0ur=-7699sportID=3 *View* http://contests.covers.com/sportscontests/profile.aspx?user=-7699sportID=3 On Sunday, July 13, 2014 2:51:21 PM UTC-4, Bill Q wrote: Hi, I would like to have (hopefully) a simple code made to extra all the pages from a URL.This URL is static and requires that a next page button be pressed to get to the next page of data. I am not sure how easy or complicated this is. I would ideally like it to start extracting on the first page and continue until it reaches the last page. All hyperlinks must remain as in attached sample. The main URL page is in cell A1. Please see attached. Thank you. -- 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. -- *PramodSingh* -- 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$$ common kgid no problem
Sir, thanks a lot it is very helpful to me my friends to work easy to complete work within seconds thank you ince again from: Daya On 16 July 2014 19:08, Vaibhav Joshi v...@vabs.in wrote: Refer this.. i made it more dynamic! Cheers!! On Wed, Jul 16, 2014 at 6:43 PM, Vaibhav Joshi v...@vabs.in wrote: Hi PFA, select the data click button to run macro. In sheet 2 you will get unique of ID no with column in which they are available. Cheers!! On Wed, Jul 16, 2014 at 5:33 PM, Vaibhav Joshi v...@vabs.in wrote: hi do you want output to be shown in excel sheet? On Wed, Jul 16, 2014 at 2:10 PM, daya p princedaya2...@gmail.com wrote: Hi Friends, I need your help to find common kgid no (like aadhar card no) which is entered in A,B,C,D .up to n th column (up to n no of section) i tried conditional formatting, its too slow and not for regular work so i need macro code. The problem here is how to find out the kgid Nos who worked in many section along with section. ex 22898585916 worked in Section 1 Section 9. 19845984612 worked in 1,2,7,8 sections hope you understood. sir i need macro code for this Thanks in advance, Daya -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their 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.
