Dear Tom,
I am so thankful to you for taking time and providing me this sheet...It
would really help me a lot with my work..
I am sorry for the delayed reply as i am not able to login regularly, any
how keep up the good work going..
God Bless,
Dollar
On Tue, Mar 3, 2009 at 8:30 PM, Tom Jeffries wrote:
> Take a look at the attached workbook. I believe it does what you want.
> IAL-R&D.xls serves as a template and can be re-used with any SC file as
> long as the format does not change.
>
> To use the workbook
> (1) Launch Workbook IAL-R&D.xls
>
> (2) Click "Import SC" Button and enter name/location of input SC file for
> example c:\SC.xls
> A worksheet (SC) will be added and the SC data will be imported to
> it.
>
> (3) Click "Build" button
> HC worksheet is populated using imported SC data
> IAL worksheet is populated using imported SC data
> HC worksheet is exported as a seprate workbook c:\HC.xls
> IAL worksheet is exported as a text file c:\IAL.txt
> Counts are filled in on Sheet1
>
> IF you want, the completed workbook can be saved UNDER A DIFFERENT NAME.
> Do not save the original workbook.
>
> If you have any questions let me know.
>
> Tom
>
>
> 2009/2/28 DOLLAR CHANDE
>
>> Dear Tom,
>>
>> So thkful to u for your kind efforts, i really appreciate the help.
>>
>>
>> Pls ref to some points:
>>
>>
>>
>>1. Sheet HC needs to be generated from a macro from sheet SC and
>>exported in the same format in excel and saved in C drive or the desktop
>>(Attached file IAL-DBX9107-OCL.xls for reference).
>>2. Same ways the text file should be like the space delimited text
>>file created by saving sheet IAL – R & D. I have attached a text file
>>(Format.txt) that can be used as guidance. The column width/no of
>> characters
>>required in text file is marked in sheet IAL – R & D from column A – Q.
>>The Gross wt. (column D in HC & IAL R & D) should contain 5
>>characters ( ex. 02.20 or 26.40 or 04.00 or 15.00)
>>3. Pls give your suggestion as to hw i can use this workbook every
>>time i need to use it. I mean should i copy the main sheet (SC) or the
>> whole
>>workbook ? Cause i tried to copy to a new sheet bt it did not work. Kindly
>>suggest the best possible way that wud not eat up lot of space on my pc.
>>
>> I really am amazed learning the tricks viewing the vba code that u put
>> in bt i feel i am not competent enough to ustand it fully. Pls advice if any
>> doubts for the above file and thanks a lot for your kind help. This will
>> help me a lot.
>>
>> Requesting all the wizards to pour in with their views and suggestions,
>>
>> Best regards,
>> Dollar Chande
>>
>> On Wed, Feb 25, 2009 at 6:25 AM, Tom Jeffries wrote:
>>
>>> Take a look at the attached workbook and see if it does what you want. I
>>> placed buttons on the "SC" worksheet for each function you describe. I
>>> wasn't sure how you wanted to export the SC worksheet as text so I exported
>>> it as tab-delimited. If you have any questions let me know.
>>> Tom
>>>
>>> On Mon, Feb 23, 2009 at 7:32 AM, DOLLAR CHANDE
>>> wrote:
>>>
Dear Wizards (esp. Paul, Tom etc..)
Ref to attached workbook, pls help meThis is a very simple task for
you guys bt can b very time saving for me and help me in my job.
I have given the instructions in Sheet 1, bt pls feel free to contact me
for any further requirements. I am a novice and so have made some
hap-hazard
macros in the workbook which u guys can change/delete to better one. Pls
also help to keep the size of the workbook small, so that i can copy n
create a new one everytime i need to use it.
Thx to all of you and anticipate a positive outcome..
Best Regards,
Dollar Chande
>>>
>>>
>>>
>>
>>
>>
>> CTR410882CAXU326023702.202200E CHS MCFITOCL1N
>> CTR430686CAXU674050102.202200E NYC MCFITOCL1N
>> CTR410482CAXU676561802.202200E CHS MCFITOCL1N
>> CTR260188CAXU900997504.004400E CHS MCFITOCL1N
>> CTR261086CLHU850721004.004400E CHS MCFITOCL1N
>> CTR410682FCIU312824802.202200E CHS MCFITOCL1N
>> CTR101086GATU837412004.004400E CHS MCFITOCL1N
>> CTR260688IRNU400481504.004300E NYC MCFITOCL1N
>> CTR431282OOLU103900402.202200E CHS MCFITOCL1N
>> CTR431084OOLU109316002.202200E CHS MCFITOCL1N
>> CTR411086OOLU116979602.202200E NYC MCFITOCL1N
>> CTR410886OOLU117824702.202200E NYC MCFITOCL1N
>> CTR430682OOLU117936702.202200E NYC MCFITOCL1N
>> CTR410584OOLU121053902.202200E NYC MCFITOCL1N
>> CTR430886OOLU129270602.202200E NYC MCFITOCL1N
>> CTR430482OOLU136109402.202200E CHS MCFITOCL1N
>> CTR430484OOLU144218002.202200E NYC MCFITOCL1N
>> CTR431286OOLU149405502.202200E CHS MCFITOCL1N
>> CTR410384OOLU150501502.202200E NYC MCFITOCL1N
>> CTR411082OOLU157505402.202200E CHS MCFITOCL1N
>> CTR431284OOLU158307002.202200E CHS MCFI