Sorry I forgot to attach sheet. Now I have attached the sheet ---------- Forwarded message ---------- From: MRafique Ujjan <imrafiqu...@gmail.com> Date: Fri, Nov 18, 2011 at 4:23 PM Subject: How can I repeat top most data of a column on each page To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
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
Sample Worksheet.xls
Description: MS-Excel spreadsheet
