D
Driftwood
All my staff have a daily activity report, in which they have columns in
which the input specific information.
One such column (CO) is used as a simple "LOG" in which they can type in
anything they think may be of concern.
Then in a master workbook, I have a formula in each cell to populate what I
want to pull from and see from each individual on a daily basis Example:
For the "LOG" column on a specific day, for a spefic member:
=IF('I:\Share\Quality Assurance\1QA
Associates\ROBBI\[DAR_RE09.xls]DAR'!CO232<>"",'I:\Share\Quality Assurance\1QA
Associates\ROBBI\[DAR_RE09.xls]DAR'!CO232,"")
The ONLY problem I have is that it will only read 260 characters of the up
to 1500 or so actually typed into a (wrapped text) cell by the associate.
I have tried to add the function "LEFT([DAR_RE09.xls]DAR'!CO232,2000)", but
the text still stops reading after the 260th character.
How can I get my IF - formula to read the entire cell input of a workbook it
is linked to? OR how do I format the MASTER to read more than it is currently?
Thanks in advance
Driftwood
which the input specific information.
One such column (CO) is used as a simple "LOG" in which they can type in
anything they think may be of concern.
Then in a master workbook, I have a formula in each cell to populate what I
want to pull from and see from each individual on a daily basis Example:
For the "LOG" column on a specific day, for a spefic member:
=IF('I:\Share\Quality Assurance\1QA
Associates\ROBBI\[DAR_RE09.xls]DAR'!CO232<>"",'I:\Share\Quality Assurance\1QA
Associates\ROBBI\[DAR_RE09.xls]DAR'!CO232,"")
The ONLY problem I have is that it will only read 260 characters of the up
to 1500 or so actually typed into a (wrapped text) cell by the associate.
I have tried to add the function "LEFT([DAR_RE09.xls]DAR'!CO232,2000)", but
the text still stops reading after the 260th character.
How can I get my IF - formula to read the entire cell input of a workbook it
is linked to? OR how do I format the MASTER to read more than it is currently?
Thanks in advance
Driftwood