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-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 <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.com>wrote: >>> >>>> Dear Wizards (esp. Paul, Tom etc..) >>>> >>>> Ref to attached workbook, pls help me....This 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 >> CTR410582OOLU171350702.202200E CHS MCFITOCL1N >> CTR070984OOLU172939702.202200E CHS MCFITOCL1N >> CTR430384OOLU282170102.202200E NYC MCFITOCL1N >> CTR410382OOLU283131402.202200E CHS MCFITOCL1N >> CTR430582OOLU283911002.202200E CHS MCFITOCL1N >> CTR410686OOLU284405502.202200E NYC MCFITOCL1N >> CTR410684OOLU285081802.202200E CHS MCFITOCL1N >> CTR431086OOLU289505202.202200E CHS MCFITOCL1N >> CTR430882OOLU301177302.202200E NYC MCFITOCL1N >> CTR410884OOLU303280002.202200E CHS MCFITOCL1N >> CTR430382OOLU327739902.202200E CHS MCFITOCL1N >> CTR410486OOLU352220102.202200E NYC MCFITOCL1N >> CTR431082OOLU361920702.202200E CHS MCFITOCL1N >> CTR430486OOLU362288002.202200E CHS MCFITOCL1N >> CTR430684OOLU365030502.202200E CHS MCFITOCL1N >> CTR411284OOLU370389502.202200E CHS MCFITOCL1N >> CTR410484OOLU371288102.202200E NYC MCFITOCL1N >> CTR050982OOLU372924602.202200E CHS MCFITOCL1N >> CTR260184OOLU573457604.004400E CHS MCFITOCL1N >> CTR100786OOLU576949004.004400E CHS MCFITOCL1N >> CTR260284OOLU578414004.004400E CHS MCFITOCL1N >> CTR260182OOLU578472504.004400E CHS MCFITOCL1N >> CTR260084OOLU578864904.004400E CHS MCFITOCL1N >> CTR260086OOLU579757404.004400E CHS MCFITOCL1N >> CTR541010OOLU713151904.004300E NYC MCFITOCL1N >> CTR540810OOLU718894104.004300E NYC MCFITOCL1N >> CTR260186OOLU731494704.004310E ORF MCFITOCL1N >> CTR541012OOLU742466704.004300E NYC MCFITOCL1N >> CTR260886OOLU754611404.004310E ORF MCFITOCL1N >> CTR261186OOLU761729104.004300E NYC MCFITOCL1N >> CTR540814OOLU782090304.004300E NYC MCFITOCL1N >> CTR260082OOLU807119004.004400E CHS MCFITOCL1N >> CTR260488OOLU814142404.004400E CHS MCFITOCL1N >> CTR260786OOLU814490604.004400E CHS MCFITOCL1N >> CTR260586OOLU814941004.004400E CHS MCFITOCL1N >> CTR260388OOLU829078904.004400E CHS MCFITOCL1N >> CTR101286OOLU830245204.004400E CHS MCFITOCL1N >> CTR260286OOLU835341804.004500E NYC MCFITOCL1N >> CTR261286OOLU850515104.004400E CHS MCFITOCL1N >> CTR100886OOLU863799104.004400E CHS MCFITOCL1N >> CTR260008OOLU871691423.734400F CHS MUNITOCL1N >> CTR260986OOLU874442804.004500E NYC MCFITOCL1N >> CTR430782TCKU340530102.202200E CHS MCFITOCL1N >> CTR100986TCNU843234604.004500E NYC MCFITOCL1N >> CTR260288TEXU556347504.004400E CHS MCFITOCL1N >> CTR070982TGHU245998002.202200E CHS MCFITOCL1N >> CTR260088TGHU723221604.004400E CHS MCFITOCL1N >> CTR260486TGHU762351904.004400E CHS MCFITOCL1N >> CTR541014TOLU363696004.004300E NYC MCFITOCL1N >> CTR100586TRLU531045404.004400E CHS MCFITOCL1N >> CTR260686TRLU755294504.004400E CHS MCFITOCL1N >> CTR260282TRLU763983404.004400E CHS MCFITOCL1N >> CTR260386TRLU825896104.004400E CHS MCFITOCL1N >> CTR430884TRLU936806902.202200E CHS MCFITOCL1N >> CTR411282TTNU366690902.202200E CHS MCFITOCL1N >> CTR540812TTNU499933404.004300E NYC MCFITOCL1N >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---