can I auto-populate cells on another sheet?

[Echo]

I am trying to see how employees use their time between the two
departments they code under. I want to be able to see the data by
person and by pay period, but because of the way my tables are set up,
I can't just transpose the data... Is there a way that I can get the
data I enter in a cell on sheet one to automatically enter into a cell
on sheet two??

 

[mdupris]

More detail on your current sheet/cell structure would be helpful here
-- the solution could be as trivial as a cell formula. It sounds like
a pivot table may be what you want, though. Have you looked into that
functinonality at all?

= Mike =

 

[Echo]

I couldn't figure it out with a pivot table...

First Spreadsheet:
In the columns I have data for hours by code and by employee (IE B is
employee 1 code 1; C is employee 1 code 2; D is employee 2 code 1,
etc.).

The rows signify each pay period.


Second Spreadsheet:
In the columns I have data for hours by code and by pay period (IE B
is under pay period 1 code 1; C is pay period 1 code 2; D is pay
period 2 code 1, etc.).

The rows signify each employee.

The data can't just be transposed horizontally because I would have to
skip a column for the other code's data, and in the reverse, I would
have to delete every other row in order to have the data transpose
vertically.