Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting cells to show length of time in Days and hours | Excel Discussion (Misc queries) | |||
Formatting cells to show length of time in Days and hours | Excel Discussion (Misc queries) | |||
Maximum Length For Linked Workbook Path? | Excel Worksheet Functions | |||
Linked Cells Staying With Cells Once Linked Workbook Update. | Excel Worksheet Functions | |||
Show cells have been read - linked | Excel Discussion (Misc queries) |