Hi all,
I have a set of data that is organized by branch # and name, and includes 3 critical dates for each branch. The data is set up like this (with lots of other columns of data in and around it - yes it's already in Excel... I'm just using Code to make it easier to read)
I'm trying to create an integrated schedule that would look like the example below, and know a pivot table is the solution, but can't seem to get it right.
Critical pieces:
- Incorporates all 3 dates for each row (site).
- Is sorted by date
- Uses the Branch #/Name AND the visit type (column heading of the date) to describe each event
Bonus points:
- For being able to group the events by week,
- For being able to total the number of events by week or month.
If this were a snap shot of the data, I know how to do this manually, but want to be able to update dates, and have the integrated schedule change accordingly.
Any help at all is greatly appreciated!
Virtum =)
[Note - there is some simple VB in the workbook already, so if that is the solution, I can implement that as well.]
I have a set of data that is organized by branch # and name, and includes 3 critical dates for each branch. The data is set up like this (with lots of other columns of data in and around it - yes it's already in Excel... I'm just using Code to make it easier to read)
Code:
Branch # Branch Name Visit 1 Visit 2 Visit 3
12345 San Francisco 11/05/05 12/13/05 1/27/06
55555 New York 12/13/05 12/24/05 2/08/06
... (for about 300 branches)
Code:
11/05/05 12345 San Francisco Visit 1
12/13/05 12345 San Francisco Visit 2
12/13/05 55555 New York Visit 1
12/24/05 55555 New York Visit 2
1/27/06 12345 San Francisco Visit 3
2/08/06 55555 New York Visit 3
... (for about 900 events)
- Incorporates all 3 dates for each row (site).
- Is sorted by date
- Uses the Branch #/Name AND the visit type (column heading of the date) to describe each event
Bonus points:
- For being able to group the events by week,
- For being able to total the number of events by week or month.
If this were a snap shot of the data, I know how to do this manually, but want to be able to update dates, and have the integrated schedule change accordingly.
Any help at all is greatly appreciated!
Virtum =)
[Note - there is some simple VB in the workbook already, so if that is the solution, I can implement that as well.]