$$Excel-Macros$$ Re: Fwd: mACRO HELP
Hi Harpreet, I have recently joined this group its my pleasure to learn such wonderful things from you guys. I really thank you all.I am starting to learn Macro's kindly suggest me the right path tutorails which can really guide me additional to your personal help. Regards, Harish Pandey, Manager Operations Religare --- On Mon, 13/4/09, Harmeet Singh harmeet.hew...@gmail.com wrote: From: Harmeet Singh harmeet.hew...@gmail.com Subject: $$Excel-Macros$$ Re: Fwd: mACRO HELP To: excel-macros@googlegroups.com Cc: jayendra.gau...@gmail.com Date: Monday, 13 April, 2009, 9:49 PM Hi Jayendra, Finally, your request is complete. I hope that helps. The code is unprotected if you want you can learn and edit the code further as per you requirement. Regards, Harmeet. On Thu, Apr 9, 2009 at 6:43 AM, jayendra gaurav jayendra.gau...@gmail.com wrote: Still I am waiting ..Pls Help me in this regards.matter is most urgent. Dear All, Can you please help me write a macro to simplify finding the packing list. The required files are attached for your reference. The tedious job that we do is as under: Fin`ding the container number PONU7259344 from the daily vehicle entry file an excel file based on the container number finding from the same file whether this container belongs to which carline (GMDAT TCAR). Based upon the carline to search in the specific carline folder the packing list. the path is K:\Warehouse\Mahindra\Tcar Packing list (In this path we have packing list folders for each carlines). The packing list detail is as under : Invoice no prod_ordr_no cust_ordr_no cont_no case_no art_no part_name pack_qty TMAID85904A01 CAIN5847G002 0844PBP-01 MSKU0708994 X9026 96475810 ENGINE A 4 TMAID85904A01 CAIN5847G002 0844PBP-01 MSKU0708994 X9025 96475810 ENGINE A 4 On finding the packing list to filter the same paste in a seperate excel sheet. Setting print margins printing. An easy and simplified way of doing this job will help us save lot of our time, computer as a resource is not available full time. -- J.Gaurav Asst. Manager Mahindra logistics General Motor Hallol Baroda Cell - 9327348097 -- J.Gaurav Asst. Manager Mahindra logistics General Motor Hallol Baroda Cell - 9327348097 -- Thanks Regards, Harmeet Singh Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/ --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Fwd: mACRO HELP
Dear All, Can you please help me write a macro to simplify finding the packing list. The required files are attached for your reference. The tedious job that we do is as under: - Fin`ding the container number PONU7259344 from the daily vehicle entry file an excel file - based on the container number finding from the same file whether this container belongs to which carline (GMDAT TCAR). - Based upon the carline to search in the specific carline folder the packing list. the path is *K:\Warehouse\Mahindra\Tcar Packing list (In this path we have packing list folders for each carlines). The packing list detail is as under :* Invoice no prod_ordr_no cust_ordr_no cont_no case_no art_no part_name pack_qty TMAID85904A01 CAIN5847G002 0844PBP-01 MSKU0708994 X9026 96475810 ENGINE A 4 TMAID85904A01 CAIN5847G002 0844PBP-01 MSKU0708994 X9025 96475810 ENGINE A 4 - On finding the packing list to filter the same paste in a seperate excel sheet. - Setting print margins printing. An easy and simplified way of doing this job will help us save lot of our time, computer as a resource is not available full time. - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~--- --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Fwd: mACRO HELP
Dear Ashis , U helps to all member ,pls help me also.Mateer is most urgent Dear All, Can you please help me write a macro to simplify finding the packing list. The required files are attached for your reference. The tedious job that we do is as under: - Fin`ding the container number PONU7259344 from the daily vehicle entry file an excel file - based on the container number finding from the same file whether this container belongs to which carline (GMDAT TCAR). - Based upon the carline to search in the specific carline folder the packing list. the path is *K:\Warehouse\Mahindra\Tcar Packing list (In this path we have packing list folders for each carlines). The packing list detail is as under :* Invoice no prod_ordr_no cust_ordr_no cont_no case_no art_no part_name pack_qty TMAID85904A01 CAIN5847G002 0844PBP-01 MSKU0708994 X9026 96475810 ENGINE A 4 TMAID85904A01 CAIN5847G002 0844PBP-01 MSKU0708994 X9025 96475810 ENGINE A 4 - On finding the packing list to filter the same paste in a seperate excel sheet. - Setting print margins printing. An easy and simplified way of doing this job will help us save lot of our time, computer as a resource is not available full time. -- J.Gaurav Asst. Manager Mahindra logistics General Motor Hallol Baroda Cell - 9327348097 --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Fwd: mACRO HELP
Still I am waiting ..Pls Help me in this regards.matter is most urgent. Dear All, Can you please help me write a macro to simplify finding the packing list. The required files are attached for your reference. The tedious job that we do is as under: - Fin`ding the container number PONU7259344 from the daily vehicle entry file an excel file - based on the container number finding from the same file whether this container belongs to which carline (GMDAT TCAR). - Based upon the carline to search in the specific carline folder the packing list. the path is *K:\Warehouse\Mahindra\Tcar Packing list (In this path we have packing list folders for each carlines). The packing list detail is as under :* Invoice no prod_ordr_no cust_ordr_no cont_no case_no art_no part_name pack_qty TMAID85904A01 CAIN5847G002 0844PBP-01 MSKU0708994 X9026 96475810 ENGINE A 4 TMAID85904A01 CAIN5847G002 0844PBP-01 MSKU0708994 X9025 96475810 ENGINE A 4 - On finding the packing list to filter the same paste in a seperate excel sheet. - Setting print margins printing. An easy and simplified way of doing this job will help us save lot of our time, computer as a resource is not available full time. -- J.Gaurav Asst. Manager Mahindra logistics General Motor Hallol Baroda Cell - 9327348097 -- J.Gaurav Asst. Manager Mahindra logistics General Motor Hallol Baroda Cell - 9327348097 --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
