Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
creating summary table of input from other worksheets
Appreciate if someone can help me with using excel, I am very much a novice
but am really intrigued by what it can do. I have inherited excel workbooks, containing worksheets of a roster of duties by the week, ie each work week is on a different tab. Pls see example below - basically in row 3,5,7, the type of case is rostered (in a validation drop-down list), and the case identification no. is input in the cell directly below, ie rows 4,6,8. TAB 1 Row A B C D E Mon 10/8/09 Tue 11/8/09 AM PM AM PM Adam b3 c3 d3 e3 b4 c4 d4 e4 Ben b5 c5 d5 e5 b6 c6 d6 e6 Carrie b7 c7 d7 e7 b8 c8 d8 e8 TAB 1 Row A B C D E Mon 10/8/09 Tue 11/8/09 AM PM AM PM Adam FC xx yy FC FC12/09 yy/09 FC14/09 Ben xx zz qq ff xx/09 zz/09 ff/09 Carrie xx FC FC ff xx/09 FC13/09 ff/09 I would like to create another tab within the same workbook, that detects the word €œFC€ in any cell on row 3,5,7, and on another worksheet, return the text below if a case no. has been assigned to the slot. Otherwise, it should be a blank. An example what is desired is provided below. TAB 2 Row A B C D E Mon 10/8/09 Tue 11/8/09 AM PM AM PM Adam FC12/09 FC14/09 Carrie FC FC13/09 Would really appreciate any help on how this can be achieved. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
creating summary table of input from other worksheets
Noviceee wrote:
Appreciate if someone can help me with using excel, I am very much a novice but am really intrigued by what it can do. I have inherited excel workbooks, containing worksheets of a roster of duties by the week, ie each work week is on a different tab. Pls see example below - basically in row 3,5,7, the type of case is rostered (in a validation drop-down list), and the case identification no. is input in the cell directly below, ie rows 4,6,8. TAB 1 Row A B C D E Mon 10/8/09 Tue 11/8/09 AM PM AM PM Adam b3 c3 d3 e3 b4 c4 d4 e4 Ben b5 c5 d5 e5 b6 c6 d6 e6 Carrie b7 c7 d7 e7 b8 c8 d8 e8 TAB 1 Row A B C D E Mon 10/8/09 Tue 11/8/09 AM PM AM PM Adam FC xx yy FC FC12/09 yy/09 FC14/09 Ben xx zz qq ff xx/09 zz/09 ff/09 Carrie xx FC FC ff xx/09 FC13/09 ff/09 I would like to create another tab within the same workbook, that detects the word €œFC€ in any cell on row 3,5,7, and on another worksheet, return the text below if a case no. has been assigned to the slot. Otherwise, it should be a blank. An example what is desired is provided below. TAB 2 Row A B C D E Mon 10/8/09 Tue 11/8/09 AM PM AM PM Adam FC12/09 FC14/09 Carrie FC FC13/09 Would really appreciate any help on how this can be achieved. Thanks! If I understand you correctly, in TAB 2 cell B3 you could use =IF('TAB 1'!B2="FC",'TAB 1'!B3,"") Fill this right and down as far as needed. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a pricing table - with 2 input fields. | Excel Discussion (Misc queries) | |||
Creating summary table from detail table | Excel Worksheet Functions | |||
Creating a summary sheet from data across multiple worksheets | Excel Discussion (Misc queries) | |||
Creating A Summary Sheet With Information From Several Worksheets | Excel Discussion (Misc queries) | |||
creating a pivot table w/ ranges from 2 worksheets | Excel Discussion (Misc queries) |