I am utilizing dependent drop down lists with an indirect function. The first drop down list is Column I, the second drop down list is Column J, and the indirect formula is running in Column N through Column Y. Everything is working great, except I cannot get the data validation in the 2nd drop down list to carry down correctly through column J. As you can see in the screenshot, I have J12 selected but the data validation is still referencing the cells in Row 11, not 12. I am having to go down through each cell and manually change the data validation reference to the correct row. It will NOT carry correctly when I do the handy little "auto-fill" function that sheets and excel use. Any one have any advice on this? I have hundreds of transactions to record and it is not time efficient to have to go through each cell like this. Help! Thank you!

I am utilizing dependent drop down lists with an indirect function. The first drop down list is Column I, the second drop down list is Column J, and the indirect formula is running in Column N through Column Y. Everything is working great, except I cannot get the data validation in the 2nd drop down list to carry down correctly through column J. As you can see in the screenshot, I have J12 selected but the data validation is still referencing the cells in Row 11, not 12. I am having to go down through each cell and manually change the data validation reference to the correct row. It will NOT carry correctly when I do the handy little "auto-fill" function that sheets and excel use. Any one have any advice on this?