I am not sure this is best placed in general, but here goes. I want to use a
seperate workbook to tally daily data inputs, which I have working just fine.
I then want to take some of the tallied data to another sheet, which only
needs current month data. Since the seperate workbook is built with each
month I need some sort of query or if, maybe lookup, function to look at a
selected month on the sheet where I want the data to go to and see that it
wants say january data to get only january data from the workbook, but when
it is changed to february or march, it automatically gets data from the
proper place. I am thinking I might be able to create an IF statement that
looks at selected data areas and finds the right month, then gets the data
from that months cell. I just don't know how to make that happen.