Need help with report output....macro???
 

Looking to pull an overall report sheet for an individual month from
sheet that lists all data for all months without manually changing cel
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 individua
months which brings up pre programmed references to the correct month
data from the data sheet to make a nice month end report.

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

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

Need help with report output....macro???
 

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/