Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I safely enter information on two worksheets simultaneously w.
I am setting up a database that lists informationa about different contract
employees. The first worksheet will be a summary and then there will be a worksheet for each employee. The goal is to have a running count of the work each has done. If I have a summary line on each worksheet, could it also appear on the first worksheet? Then I could keep running totals on everyone without having to enter the info twice. Good idea? |
#2
|
|||
|
|||
Hi, abird;
It is. Copy the cells of the summary line in one of the worksheets, switch to your summary worksheet and Paste Special Paste Link into the row you want the info for that employee to appear. Repeat for each of the other employees. Regards, Ian. "abird" wrote: I am setting up a database that lists informationa about different contract employees. The first worksheet will be a summary and then there will be a worksheet for each employee. The goal is to have a running count of the work each has done. If I have a summary line on each worksheet, could it also appear on the first worksheet? Then I could keep running totals on everyone without having to enter the info twice. Good idea? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charting information from a number of worksheets | Charts and Charting in Excel | |||
How to protect and unprotect 30 worksheets in a file every month . | Excel Worksheet Functions | |||
Protect/unprotect all worksheets | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
data entry on multiple worksheets | Excel Discussion (Misc queries) |