HI friends,your's & alls requirement of PT.Challan is over, i have prepared P.T.Challan in automated excel format . you have fill only color cells in 1 part,other two copies get fill automatically. so use it freely & dont forget to give your response on LawangaleA/c , Income Tax/Sales Tax Consultant
You have tried Good but If You don'r mind than I would like to give to some suggection or feedback which will improve Your Work.
=Don't Just use Past function. In this sheet You have copy challan format fromYour other file name "TAX0910".Because When user open this file and Excel file doesn not find it path for "TAXO910"file, which path is always not same for user's PC as in Your PC so It's Show notification of linking Problem.
=TO avoid such type of problem use "Special paste function" when You copy some data from other file of EXCEL.
=Format date cells and put it in to date format.
=Amount is not converted in to Word. Use some logic and function to convert figure in to Word.
=Date of Entry is protected.
I hope This will help you to enhance your work quality.
Why Vote? User validation is extremely important for good content to prosper.