Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Update in Excel
I am having 2 excels. In first excel I am having user names in Column A(For
e.g Amit, Antony etc.). Daily we used to fill data against our name.Data entered will be in color and code(Like MG and cell is filled with color say Yellow to indicate project phase). On Second excel we havedifferent worksheets renamed as code (MG etc). On eacer worksheet we have project phases listed. In each phase we have users. I want whenever I entered any color and code in first excel it should look for worksheet with same code in secod excel, then on that worksheet it should look for same color in first column, then after finding that colour search for my name from next row untill you reach next color. In between if you find my name go and update the value present in 2 nd column by 1 present against my name. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sometimes formuli in workbook don't auto update with auto-recal on | Excel Worksheet Functions | |||
some excel fomulas don't update, even if I hit F9, auto calc = on | Excel Discussion (Misc queries) | |||
How do I make a name formula auto update in Excel | Excel Worksheet Functions | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions | |||
auto update an open excel sheet over network, with mutiple users | Excel Worksheet Functions |