HI,
I would like to create a formula that links certain data to other sheets when date is passed certain value.
All rows with date starting from 1 may 2013 should be in sheet april 2013
All rows with date starting from 1 June 2013 should be in sheet may 2013
All rows with date starting from 1 July 2013 should be in sheet June 2013
All rows with date starting from 2014 should be in sheet 2014
I also attached an example, I already copied the data in the correct sheets, but I would like to do it without copy pasting and use a formula
Hope someone can help me,
Much appreciated
Bookmarks