Hi,

I'm creating a work book with both a forecast sheet and a purchasing sheet,
I've 3D referenced these sheet to automatically create a purchasing list
based on a weekly forecasted total.

My issue is that I need my purchasing list to reference the forecast total
for the week. Then as new data is entered into the next week my purchasing
list automatically references the next week's forecast total.

Can this be done or is there a better way to accomplish this function?

--
thanks,

Ryan