Excel 2007 : Peoblem of Opening and Closing Stock

[Kirti Jain]

Hi,

I have provided drop down of Date through Data Validation.

I want Closing stock of Previous day should become Opening Stock of Next Day if I change Date in Drop down.

How i can do that????

[SCLai]

Welcome to the forums

Sorry, but can you provide a more specific example, or perhaps a mock worksheet?

SC

[Kirti Jain]

Hi

Please find attachment for more clarification

Thanks