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 tjeff...@gmail.com wrote:
Take a look at the attached workbook. I believe it does what you want.
IAL-RD.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-RD.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 dollarcha...@gmail.com
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 tjeff...@gmail.com 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
dollarcha...@gmail.comwrote:
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 MCFITOCL1N
CTR411286OOLU161329902.202200E NYC MCFITOCL1N
CTR411084OOLU166622002.202200E CHS MCFITOCL1N
CTR430584OOLU170582002.202200E CHS MCFITOCL1N