Hi Kanwal, Sorry for being late. Here is your Solution attached with the mail. It was more easy than before. By putting HLookup, you're half done already.
Do tell us, if more help needed. Thanks and Regards Ashish Jain For more tips, tricks, downloads and problem solutions: visit --> http://www.excelitems.com ------------------------------------------------------------------------ Regards *Ashish **Jain* Analyst, CSC Microsoft Certified Application (Excel) Specialist Technical Trainer - Excel and VBA Author -> www.excelitems.com +91-9999-40-48-43 ---------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------- On Tue, Mar 10, 2009 at 12:10 AM, kanwal_no1 <kanwal...@gmail.com> wrote: > > Hi Ashish, > > I still need some help with that........ > > > On Mar 8, 5:18 am, Ashish Jain <26may.1...@gmail.com> wrote: > > Ya Kanwal - I've received your file. > > > > On Mar 7, 2:41 am, kanwal_no1 <kanwal...@gmail.com> wrote: > > > > > Hi Ashish, > > > > > Have you got the file ? > > > > > Regards > > > Kanwaljit > > > > -- Regards Ashish Jain --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
VBA form Auto Resizing.xls
Description: MS-Excel spreadsheet