![]() |
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
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?? |
| Ads |
|
#2
|
|||
|
|||
|
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 | |
| Display Modes | |
|
|
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 |