Hi I have setup a front sheet, using the offset with a combobox to select the
month
=OFFSET('2005 Budgets'!B5,,MonthCell-1)
=IF(MonthCell<12,OFFSET('2005 Budgets'!B5,,MonthCell),"Year end")

HTH
Frank

I could send you a working example?.

"Perry" wrote:

Hi. I have a work book w/ multiple worksheets with sales data.. for differnt
regions..who can i extract data that shows me which customer ordered 50 +
boxes on a seperate worksheet.. Please help