I have a daily sales workbook that I need to extract the sales from
yesterday, and have it filter to another worksheet for the current month. I
know to use the "Today()-1, to get the day before today. I need to know how
to get the information to filter onto another worksheet that will autofill
from the daily worksheet. Example worksheets "Daily", "Jan", "Feb", "Mar",
"YTD". I want to be able to use "Today()-1 to get the day befores date. Then
fill in to horizontal cells with dollar amounts, I have where they'll add
together on the "Daily", but how do I get the date and dollar amounts to fill
the respective month worksheets in succesion. Please help I'm pulling my hair
out!!!!!!!!!LOL
--
Best Regards,

Peter Raulin