azizrasul
Well-known Member
- Joined
- Jul 7, 2003
- Messages
- 1,304
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Using
=OFFSET(tblReports!$G$2,0,0,COUNTA(tblReports!G:G))
I create a dynamic range of data called "Reports" in sheet "tblReports". However when I select a cell on another sheet called "Main", and do a Data Validation on a cell and select List and make the Source =Reports, I still get blanks appearring in the drop down! What can I be doing wrong?
=OFFSET(tblReports!$G$2,0,0,COUNTA(tblReports!G:G))
I create a dynamic range of data called "Reports" in sheet "tblReports". However when I select a cell on another sheet called "Main", and do a Data Validation on a cell and select List and make the Source =Reports, I still get blanks appearring in the drop down! What can I be doing wrong?