I will once again explain my query.
I have a table which contains data relating to about 100 schemes for 2500
dealers in the following format
DEALER CODE
DEALER NAME
RDS NAME
SCH-1
SCH-2
SCH-100
TOTAL EARNING
1
A
AA
100
90
190
2
B
BB
150
85
17
252
3
C
AA
200
200
4
D
CC
150
10
0
160
N
E
BB
700
80
15
795
Now I want the report in the following format for each dealer in a new page
DEALER CODE : 1
DEALER NAME: A
RDS : AA
SCH-1 100
SCH-2 90
TOTAL 190
DEALER CODE : 2
DEALER NAME: B
RDS : BB
SCH-1 150
SCH-2 85
SCH-3 17
TOTAL 252
Etc. for each dealer. If any scheme is blank for a dealer it should be omitted.
I hope I am clear this time.
Thanks & Regards...
CA Vivek Jain, FCA, DISA (ICAI)
Vivek Shantilal Jain & Co.
Chartered Accountants
3010 Ram Kumar Arcade,
Chatribari Road, A T Road,
Guwahati-781001
0361-2603895,9435019908
save earth
--
FORUM RULES (986+ 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
<<image001.jpg>>
