If Cell Contains then Referrence Sheet Cell

**rafyel** · 10-19-2007, 10:15 PM

I would like to format the cells of Sheet1 cells A1:A60 in such a way that the text of Sheet2 and Sheet3 cells A1:A30 be referenced in Sheet1 cells A1:A60 only if an “X” have been entered in the corresponding cells of column B.
This means that if the text entries of Sheet2 cells A1:A5 contain an “X” in corresponding cells of B1:B5 then the text entries of Sheet2 cells A1:A5 must be entered in Sheet1 cells A1:A5. And if the same statement is true for Sheet3 then the entries in Sheet1 must follow in cells A6:A10.
Note: Not all cells in sheets 2 and 3 cells A1:A30 contain text and a corresponding “X” in cell of column B. Therefore, this column will be empty. (Exp. A15 = No TextEntry, B15 = No “X” entry) Thanks.

**starguy** · 10-20-2007, 12:19 AM

Originally Posted by rafyel

I would like to format the cells of Sheet1 cells A1:A60 in such a way that the text of Sheet2 and Sheet3 cells A1:A30 be referenced in Sheet1 cells A1:A60 only if an “X” have been entered in the corresponding cells of column B.
This means that if the text entries of Sheet2 cells A1:A5 contain an “X” in corresponding cells of B1:B5 then the text entries of Sheet2 cells A1:A5 must be entered in Sheet1 cells A1:A5. And if the same statement is true for Sheet3 then the entries in Sheet1 must follow in cells A6:A10.
Note: Not all cells in sheets 2 and 3 cells A1:A30 contain text and a corresponding “X” in cell of column B. Therefore, this column will be empty. (Exp. A15 = No TextEntry, B15 = No “X” entry) Thanks.

Hi

See the attached file.

**rafyel** · 10-20-2007, 08:35 AM

This is exactly what I need. Is there anyway possible I could hide the errors? I ask because additionaly on Sheet1 I need to have a cell A61 calculate the subtotal of text entries.

I have attached the Spreadsheet that I am working on and the worksheet labeled Report is equivalent to Sheet1 in the demonstration. The the text entries in worksheet 'Report' has been entered manually and I need to it to populate based on your formula for each column but also providing a total of the entries.

**rafyel** · 10-20-2007, 03:48 PM

I've spent hours trying to figure out how to insert a empty line on Sheet1 A1 so that I may add a title there but I can not. I've tried duplicating this for the addition columns and titles but it doesnt work for me.

**rafyel** · 10-22-2007, 07:27 PM

I would like to format the cells in workbook 'Report' cells A2:A31 in such
a way that the text of workbooks Monday, Tuesday, 'Wednesday, Thursday,
and Friday cells B2:B31 be referenced in workbook Report cells A2:A31. However, this should
only occur if an “X” have been entered in the corresponding cells of
column C.

In another example this means that if the text entries in workbook 'Monday' cells B2:B6
contain an “X” in the corresponding cells of C2:C6 then the text
entries in workbook 'Monday' cells B2:B6 must be entered in workbook
'Report' cells A2:A6. And if the same statement is true for workbooks
'Tuesday' through 'Friday' then the entries in 'Report' must follow in cells
A7:A11 and so on.

Also, a selection of "X" in the remaining columns of workbooks 'Monday-Friday' should also populate in the under the respective columns in the workbooks name 'Report'.

Note: Not all cells in Monday through Friday cells A2:A31 contain text
and a corresponding “X” in cell of column B. Therefore, this column
will be empty. (Exp. A15 = No TextEntry, B15 = No “X” entry). *The
cell entries in A1 for each worksheet is for headings.