Posts by jpmurph

    The worksheet attached works great thanks junho!

    But what would I have to change if I wanted to put all the results on the same worksheet, stacked on top of eachother. would I just need to remove the worksheets.add? I tried this but can't get it to work properly.

    In my first worksheet I have a list of states and state abrivations I want to refreence each of the states and return their results on a new worksheet. I've been able to scrap together most of the code, but i'm missing the first part of the code which declares the reference...I Think?!

    Looking forward to you input, thanks!