Hi shane476

Have you try DataAutofilter in the menubar

--
Regards Ron de Bruin
http://www.rondebruin.nl


"shane476 " wrote in message ...
Looking to pull an overall report sheet for an individual month from a
sheet that lists all data for all months without manually changing cell
references everytime.

Setup for data pages is:
Sales Cost Etc......
Jan
Feb
March
etc......

have seen before where you can have a pull down menu of individual
months which brings up pre programmed references to the correct months
data from the data sheet to make a nice month end report.

Any help greatly appreciated. If any more info is needed, please advise


---
Message posted from http://www.ExcelForum.com/