Cross reference

[LaRana!]

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

 

[Pete_UK]

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