It works fine now. Thank you so much for helping. I would never have gotten there on my own. The single cell with a #Value error was causing the issue.
thanks for bearing with me
As a little tip - if you hover over the "x" or "y" on that line it shows you the row/column where the error exists
Happy to help
As for the tip - it would have helped if I could see your data
Click here for a guide on how to add code tags
Click here for a guide on how to mark a thread as solved
Click herefor a guide on how to upload a file with your post