acsishere
06-16-2008, 11:47 AM
I have a workbook contains sheets named 1) "LIST", 2) "MYDATA"
In LIST sheet, data contains something like this:
ColA / ColB/ ColC
4 / A / QUALITY1
4 / B / QUALITY2
4 / C / QUALITY3
5 / B / QUALITY4
3 / A / QUALITY5 ..... and so on.
In MYDATA sheet, the data contains more than 50-60 columns. A sample is:
ColA TO ColAZ
4 / A / NAME1 / DOB1 / DOA1 / ADDRESS1 /....
(4 / A more than 100 records)
4 / B / NAME101 / DOB101 / DOA101 / ADDRESS101 /....
(4 / B also more than 100 records)
and in a similar way other records (4/C, 5/B, 3/A) are also appear.
Now, I need to sort the data according to first by ColA and then by ColB of MYDATA sheet. Then the pagebreak should also be done according to the same value. (Ex. Just after last row of 3/A, then after last row of 4/A, then after last row of 4/B, then after last row of 4/C, then after last row of 5/B).
When I need to print, concerned page should be like this:
(If I am printing page of 3/A, then) in the header right side: 3/A: QUALITY5 (Vlookup from LIST sheet)
(If I am printing page of 4/A, then) in the header right side: 4/A: QUALITY1 (Vlookup from LIST sheet)
(If I am printing page of 4/B, then) in the header right side: 4/B: QUALITY2 (Vlookup from LIST sheet)
I do agree that this is a little bit tough task, but I hope some wizards will guide me to accomplish this target in no time.
Thanks in advance.
acsishere.
In LIST sheet, data contains something like this:
ColA / ColB/ ColC
4 / A / QUALITY1
4 / B / QUALITY2
4 / C / QUALITY3
5 / B / QUALITY4
3 / A / QUALITY5 ..... and so on.
In MYDATA sheet, the data contains more than 50-60 columns. A sample is:
ColA TO ColAZ
4 / A / NAME1 / DOB1 / DOA1 / ADDRESS1 /....
(4 / A more than 100 records)
4 / B / NAME101 / DOB101 / DOA101 / ADDRESS101 /....
(4 / B also more than 100 records)
and in a similar way other records (4/C, 5/B, 3/A) are also appear.
Now, I need to sort the data according to first by ColA and then by ColB of MYDATA sheet. Then the pagebreak should also be done according to the same value. (Ex. Just after last row of 3/A, then after last row of 4/A, then after last row of 4/B, then after last row of 4/C, then after last row of 5/B).
When I need to print, concerned page should be like this:
(If I am printing page of 3/A, then) in the header right side: 3/A: QUALITY5 (Vlookup from LIST sheet)
(If I am printing page of 4/A, then) in the header right side: 4/A: QUALITY1 (Vlookup from LIST sheet)
(If I am printing page of 4/B, then) in the header right side: 4/B: QUALITY2 (Vlookup from LIST sheet)
I do agree that this is a little bit tough task, but I hope some wizards will guide me to accomplish this target in no time.
Thanks in advance.
acsishere.