DashboardNovice
Member
On tab B I have a data validation list that points to a range on tab A (both tabs are in the same workbook). When I select the data validation list, the cursor starts below the list of values, making it appear that the list is blank, but you have to scroll up to see the values that are present. I want the data validation cursor to start at the top of the list, so I used this formula:
Here is what my data validation formula looks like:
Here is the error I am getting:
How can I get this error when my reference is within the same workbook and not another workbook?
Code:
=OFFSET(Sheet3!$A$1,0,0,COUNTA(Sheet3!$A:$A)-1,1)
Here is what my data validation formula looks like:
Here is the error I am getting:
How can I get this error when my reference is within the same workbook and not another workbook?