How does that relate to the sample provided? If you want for a DIFFERENT
sample, please provide. If not, tell us which columns you want to print and
why is the word do in the otherwise blank cells???
Don Guillett
SalesAid Software
dguille...@gmail.com
-----Original Message-----
From: MRafique Ujjan
Sent: Saturday, November 19, 2011 6:33 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Fwd: How can I repeat top most data of a
column on each page
Dear All,
I am thankful to all of friends who responded me well, but it is my
fault that i could not mention my problem clearly. Therefore I once
again try to mention please help me in this regard as earlier.
Problem:
Suppose I have one two columns A1 & B1. In column A1 I entered
Different Countries and in other column B1 I enter Sale in different
cities. So now i have entered thousands of entries in sale column. If
in the column A1 I enter every country name against column B1 for
sales. Then it looks like as below
A1 B1
============================
1. Pakistan Karachi
2. Pakistan Hyderabad
3. Pakistan Islamabad
4. India Delhi
5. India Kolkata
6. India Mumbai
1. Pakistan Karachi
2. Pakistan Hyderabad
3. Pakistan Islamabad
4. India Delhi
5. India Kolkata
6. India Mumbai
7. Pakistan Karachi
8. Pakistan Hyderabad
9. Pakistan Islamabad
10. India Delhi
11. India Kolkata
12. India Mumbai
and so on .................
Now if I have entered thousands of rows entries for both columns. Then
it looks bad to enter each country name against every city. So I
entered the data in this way.
A1 B1
============================
1. Pakistan Karachi
2. Hyderabad
3. Islamabad
4. India Delhi
5. Kolkata
6. Mumbai
7. Pakistan Karachi
8. Hyderabad
9. Islamabad
10. India Delhi
11. Kolkata
12. Mumbai
13. Pakistan Karachi
14. Hyderabad
15. Islamabad
16. India Delhi
17. Kolkata
18. Mumbai
Now as I have already told you that I have entered thousands of
entries like above. Therefore, when i print the data it looks like
this
Page 1
======
1. Pakistan Karachi
2. Hyderabad
3. Islamabad
4. India Delhi
5. Kolkata
6. Mumbai
7. Pakistan Karachi
8. Hyderabad
9. Islamabad
10. India Delhi
11. Kolkata
12. Mumbai
13. Pakistan Karachi
14. Hyderabad
15. Islamabad
16. India Delhi
17. Kolkata
18. Mumbai
Page 2
======
19. Karachi
20. Hyderabad
21. Islamabad
22. India Delhi
23. Kolkata
24. Mumbai
25. Pakistan Karachi
26. Hyderabad
27. Islamabad
28. India Delhi
29. Kolkata
30. Mumbai
31. Pakistan Karachi
32. Hyderabad
33. Islamabad
34. India Delhi
35. Kolkata
36. Mumbai
Now suppose in the page 2 there is no name mentioned in the Column A1
(1st row of page 2) against the column B1. In the page 1 the data is
clear to understand but in page 2 it is not clear.
Therefore I need a formula or macro for each page to show the name of
country automatically in the 1st row of each next page.
I have tried my level best to mention clearly my problem. I hope that
I will get the problem solved soon.
Thanking you in anticipation.
M. Rafique Ujjan
On Nov 19, 1:16 am, "dguillett1" <dguille...@gmail.com> wrote:
You can use the change event macro so when you type in the sample number
you will get what you requested.
However,I suspect that you want more
On the print question, you don’t tell us WHAT you intend to print......
Don Guillett
SalesAid Software
dguille...@gmail.com
From: M.Rafique MRU
Sent: Friday, November 18, 2011 9:47 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Fwd: How can I repeat top most data of a column
on each page
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
Rafique_Sample Worksheet1.xls
52KViewDownload
--
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
--
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
