P
Peter Raulin
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
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