M
Michael
Here's my situation. I have a workbook that contains five worksheets. Sheets
1 and 3 are identical as are sheets 2 and 4. Sheet 5 is a summary page. The
information and formats of sheets 1 thru 5 must remain like they are. Sheets
1 and 3 each have about 56 columns and a couple hundred rows. In the middle
of these columns are two columns that contains the list. One column contains
the driver's name and the other column contains the customer the they
delivered to. Sheet 1 is for first shift and sheet 3 is for second shift. To
make it more complicated, about half way down these columns that contains my
list, is a span of about 12 rows that contains blank cells and other
information that is not apart of the list (see example). Like I already
mentioned, the information and formats in these worksheets must remain like
they are. What I would like to do is insert a new worksheet that will contain
a list of all of the drivers from both worksheets and then list all of the
customers that they delivered to in the order that they delivered (see
example).
A B C D E
Name Customer
Driver 1 Customer 1
Driver 2 Customer 2
Driver 3 Customer 3
Driver 1 Customer 4
Driver 2 Customer 5
Driver 3 Customer 6
Break in list
Driver 1 Customer 7
Driver 2 Customer 8
Driver 3 Customer 9
I would like for sheet 6 to look like this:
Driver 1 Customer 1
Customer 4
Customer 7
Driver 2 Customer 2
Customer 5
Customer 8
Driver 3 Customer 3
Customer 6
Customer 9
Is there a way to do this? Any suggestions that you have are greatly
appreciated.
1 and 3 are identical as are sheets 2 and 4. Sheet 5 is a summary page. The
information and formats of sheets 1 thru 5 must remain like they are. Sheets
1 and 3 each have about 56 columns and a couple hundred rows. In the middle
of these columns are two columns that contains the list. One column contains
the driver's name and the other column contains the customer the they
delivered to. Sheet 1 is for first shift and sheet 3 is for second shift. To
make it more complicated, about half way down these columns that contains my
list, is a span of about 12 rows that contains blank cells and other
information that is not apart of the list (see example). Like I already
mentioned, the information and formats in these worksheets must remain like
they are. What I would like to do is insert a new worksheet that will contain
a list of all of the drivers from both worksheets and then list all of the
customers that they delivered to in the order that they delivered (see
example).
A B C D E
Name Customer
Driver 1 Customer 1
Driver 2 Customer 2
Driver 3 Customer 3
Driver 1 Customer 4
Driver 2 Customer 5
Driver 3 Customer 6
Break in list
Driver 1 Customer 7
Driver 2 Customer 8
Driver 3 Customer 9
I would like for sheet 6 to look like this:
Driver 1 Customer 1
Customer 4
Customer 7
Driver 2 Customer 2
Customer 5
Customer 8
Driver 3 Customer 3
Customer 6
Customer 9
Is there a way to do this? Any suggestions that you have are greatly
appreciated.