It would be a lot easier if your first sheet had only one set of
headings and if the date was included in its own column, like this:

Date OFFICER in out MANUAL
03/01 Agent1 14 15 30
03/01 Agent2 21 16 13
03/02 Agent1 14 15 30
03/02 Agent2 21 16 13

Any chance you could amend it like this?

Pete

On Mar 6, 12:02*am, LaRana! wrote:
I have one worksheet. One sheet has data in the following fashion
03/01
OFFICER - in * *- *out *- MANUAL
Agent1 * * 14 * * * 15 * * *30
Agent2 * * * * *21 * * * * * * 16 * * * * * *13

03/02
OFFICER - in * *- *out *- MANUAL
Agent1 * * 14 * * * 15 * * *30
Agent2 * * * * *21 * * * * * * 16 * * * * * *13

I want to use this data in a second sheet as follows:
Agent1 * * *03/01 * *03/02
In * * * * * * * 14 * * * * 14
Out * * * * * * 21 * * * * 21

How do can I reference my cells in the 2nd worksheet so that I can just drag
the cell across March?

Thanks,
EddieV