can I auto-populate cells on another sheet?

**[email protected]** · March 5th 07, 04:39 PM posted to microsoft.public.excel.setup

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??

**John C Harris** · March 5th 07, 07:41 PM posted to microsoft.public.excel.setup

Absolutely. Just select the cell you want the information to populate to,
type '=' sign, then select the first sheet and click the cell that the entry
is made into. This will link the cells together.

> wrote in message
ups.com...
>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??
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
can I auto-populate cells on another sheet?	Echo	Excel Discussion (Misc queries)	2	March 5th 07 06:27 PM
Auto Populate Cells	John	Setting up and Configuration of Excel	3	January 7th 07 09:22 AM
Auto populate cells	Laus	Excel Discussion (Misc queries)	5	December 3rd 06 04:39 PM
Link and auto-populate cells in workbooks	Larry	New Users to Excel	0	June 22nd 06 03:58 PM
Auto populate cells based on 2 cells division.	Chance224	Excel Discussion (Misc queries)	0	April 4th 05 09:35 PM