DaveRadford
Board Regular
- Joined
- Feb 18, 2010
- Messages
- 63
I have an issue with attempting to remove blanks that appear within the drop down list.
The list is in a seperate tab within the same workbook (i understand you cant reference seperate workbooks) this however means that "remove Blanks" no longer works.
The good news is that all the blanks will be at the end of (bottom) of the column im referencing. This sheet is referencing a seperate workbook to overcome the issue of referencing seperate workbooks within a Validation list. As this seperate workbook sheet will continue to grow i am referencing cells that have not yet been filled.
I have used the following formula in order to change all the zeros i recieved in to blanks.
=IF(ISBLANK('\\Server\[live job list.xlsx]Live Job List.rpt'!A2135),"",'\\Server\[live job list.xlsx]Live Job List.rpt'!A2135)
I need something that will stop blanks from appearing within the Validation Drop Down Box.
The list is in a seperate tab within the same workbook (i understand you cant reference seperate workbooks) this however means that "remove Blanks" no longer works.
The good news is that all the blanks will be at the end of (bottom) of the column im referencing. This sheet is referencing a seperate workbook to overcome the issue of referencing seperate workbooks within a Validation list. As this seperate workbook sheet will continue to grow i am referencing cells that have not yet been filled.
I have used the following formula in order to change all the zeros i recieved in to blanks.
=IF(ISBLANK('\\Server\[live job list.xlsx]Live Job List.rpt'!A2135),"",'\\Server\[live job list.xlsx]Live Job List.rpt'!A2135)
I need something that will stop blanks from appearing within the Validation Drop Down Box.