Hi,

I have a worksheet with multiple tasks that need to be updated on a monthly basis.

Im trying to find a formula or macro that assigns a number in column A to each row in that spreadsheet in the format of 2014-01, 2014-02, 2014-03...

Also, that number needs to be specific to that row even when being sorted.

Thanks for your help!