C
Connie
Working with Excel 2000.
My workbook has four worksheets. Worksheet 4 is a summary
of some of the cells in the first three. One employee may
only be required to complete Worksheet 2, whereas another
is required to complete Worksheet 1 or 3. In Worksheet 4,
for example, Cell A1 is to be whatever was entered in A1
in either of the three other worksheets, depending on
which one was filled out. What formula do I put in A1 in
worksheet 4. If worksheet 2 was completed, A1 in
worksheet 4 needs to pick that up, but if worksheet 3 was
completed and not 2 or 1, then A1 in worksheet 4 needs to
pick that one up. Is this as clear as mud?
My workbook has four worksheets. Worksheet 4 is a summary
of some of the cells in the first three. One employee may
only be required to complete Worksheet 2, whereas another
is required to complete Worksheet 1 or 3. In Worksheet 4,
for example, Cell A1 is to be whatever was entered in A1
in either of the three other worksheets, depending on
which one was filled out. What formula do I put in A1 in
worksheet 4. If worksheet 2 was completed, A1 in
worksheet 4 needs to pick that up, but if worksheet 3 was
completed and not 2 or 1, then A1 in worksheet 4 needs to
pick that one up. Is this as clear as mud?