ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Can I safely enter information on two worksheets simultaneously w. (https://www.excelbanter.com/new-users-excel/15026-can-i-safely-enter-information-two-worksheets-simultaneously-w.html)

abird

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?

IanRoy

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?



All times are GMT +1. The time now is 03:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com