aamirsq Member Feb 8, 2015 #1 Hi, how can i search and move date to other sheet as shown on sheet 2. Attachments sample-proj.xlsx 10.6 KB · Views: 4
A amrit1186 Member Feb 8, 2015 #2 Dear Aamir See if the attached file help. I have added a helper column to simplify the formula. Regards Amritansh Attachments sample-proj.xlsx 11.4 KB · Views: 6
Dear Aamir See if the attached file help. I have added a helper column to simplify the formula. Regards Amritansh
aamirsq Member Feb 10, 2015 #3 adding the helper column did work but there is still a problem the values for January are not coming correct as it is counting the values for sub tasks as well. Attachments sample-proj 2.xlsx 12.3 KB · Views: 6
adding the helper column did work but there is still a problem the values for January are not coming correct as it is counting the values for sub tasks as well.
