Monthly Report

[aprillachlan]

I have a spreadsheet containing sales invoice information (invoice
number, date, amount, etc). I want to create a separate worksheet
within the spreadsheet that allows me to view only the invoices raised
for a certain month. I want to be able to enter a date range and then
have excel return the details within that specified range. (a query
basically)

I dont know if its a query or report or macro that I need to use. I do
not have any real experience using macros.

I want the process to be automated so that any idiot can type in the
date range and get the right information.

I would be so grateful for info, or details on where i can get a
template or something. I have been working on this for days and cant
seem to figure it out.

Many thanks!

 

[Guest]

You can do it all on the same sheet as your data...........check out Data >
Filter > AutoFilter..............use the custom selection with greater/lesser
than choices on your date column..........

Vaya con Dios,
Chuck, CABGx3