Monthly Report
 

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!


--
aprillachlan
------------------------------------------------------------------------
aprillachlan's Profile: http://www.excelforum.com/member.php...o&userid=29785
View this thread: http://www.excelforum.com/showthread...hreadid=494911

Monthly Report
 

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

"aprillachlan" wrote:


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!


--
aprillachlan
------------------------------------------------------------------------
aprillachlan's Profile: http://www.excelforum.com/member.php...o&userid=29785
View this thread: http://www.excelforum.com/showthread...hreadid=494911