Dear Sorry! I have now attached the file please help me in this regard. Thanks for your quick response.
M. Rafique Ujjan On Nov 18, 4:46 pm, NOORAIN ANSARI <noorain.ans...@gmail.com> wrote: > Dear Rafique, > > Attachement is missing. > > On Fri, Nov 18, 2011 at 4:53 PM, MRafique Ujjan <imrafiqu...@gmail.com>wrote: > > > > > > > > > > > Dear Group Members, > > > I am attaching a sample data sheet here. In which following are the > > columns > > > 1. Union Council > > 2. Name of Deh > > 3. Name of Village > > 4. S. No > > 5. Full Name > > 6. N.I. C No > > 7. Nature of House > > > Now I have entered data in this sheet in thousands of names and > > hundreds of villages. > > 1) Now I want Column 1 to 3 top most data in the page should be > > repeated on each page when I print 100s of pages. > > 2) I want to know any special formatting for column 6 when i enter > > numbers dashes should automatically be inserted in the numbers like > > below > > > 4140564843677 this should be like thise 41405-6487367-7 > > > You can see this data in my sample worksheet. Please help me in this > > regard I shall remain thank full to you forever > > > -- > > FORUM RULES (934+ members already BANNED for violation) > > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > > will not get quick attention or may not be answered. > > > 2) Don't post a question in the thread of another member. > > > 3) Don't post questions regarding breaking or bypassing any security > > measure. > > > 4) Acknowledge the responses you receive, good or bad. > > > 5) Cross-promotion of, or links to, forums competitive to this forum in > > signatures are prohibited. > > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > > To post to this group, send email to excel-macros@googlegroups.com > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
