creating summary table of input from other worksheets


N

Noviceee

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!
 
Ad

Advertisements

S

smartin

Noviceee said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top