Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Mirroring Data
Im not sure this is possible, but im sure that this the place to telling whether it is. I am trying to create a tasklist for IT team. I am creating a Tasklist on the first worksheet, this will show all the tasks that need completing. Then on the next worksheets I am wanting to list the tasks for each individual person from the first worksheet. I can do this, however the only way I have found to do this is either simply using =Sheet1!B10 or with paste link. This doesnt however allow the individual to update the main list from his area. I havent explained that very well but hopefully you get the gist of it. Any help would be gratefully appriciated. Thanks Mick -- mickp ------------------------------------------------------------------------ mickp's Profile: http://www.excelforum.com/member.php...o&userid=35612 View this thread: http://www.excelforum.com/showthread...hreadid=553848 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Mirroring Data
There's one way to do this easily, but all sheets have to be duplicates of
each other - with duplicate layouts. You'd have to mark which tasks each individual is responsible for, but still have the others listed in the same order on each sheet. You could color code the ones for each individual or hide the ones not to be assigned. We could even work up some automation to do the hiding thing - but that's beyond the immediate problem. Set up a second column on the first sheet to record a "Completed" indicator. Now, assuming that the first worksheet for the individual IT persons is named ADAM and the last one is named ZIFF, and your task list is in column A and starts in row 2, put a formula like this one in cell B2: =IF(COUNTA(ADAM:ZIFF!B2)0,"Completed","") Drag that down the column to the end of the tasks list. Then as the IT folks complete their tasks, they put some indicator in column B on their individual sheets next to the task title and you'll know it was completed by someone in the stack. How it works: picture the ADAM:ZIFF!B2 portion as kind of a hole punch through the entire stack of worksheets starting with ADAM and ending with ZIFF and including any in between them in the workbook, and checking the specified cell on all of them at once. The 3-dimensional equivalent of a similar function used on a single sheet for a row or column of information. I used COUNTA() so that they can enter anything in their sheets in column B and it will be detected. It could be an "x" or the word "done" or the date completed, or just about any non-blank entry. "mickp" wrote: Im not sure this is possible, but im sure that this the place to telling whether it is. I am trying to create a tasklist for IT team. I am creating a Tasklist on the first worksheet, this will show all the tasks that need completing. Then on the next worksheets I am wanting to list the tasks for each individual person from the first worksheet. I can do this, however the only way I have found to do this is either simply using =Sheet1!B10 or with paste link. This doesnt however allow the individual to update the main list from his area. I havent explained that very well but hopefully you get the gist of it. Any help would be gratefully appriciated. Thanks Mick -- mickp ------------------------------------------------------------------------ mickp's Profile: http://www.excelforum.com/member.php...o&userid=35612 View this thread: http://www.excelforum.com/showthread...hreadid=553848 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't get data from a web page to chart in excel. Any solutions? | Excel Discussion (Misc queries) | |||
Excel: How to choose data on two separate rows in the same column | Excel Worksheet Functions | |||
Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |