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
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
