Hi guys
Requesting your guidance to copy the cells (B:I and K) in each row in sheet " 7 Jan 14 " to cells B:J in sheet " 14 Jan 14 " when the text in K is " Still In Care", which is the condition. Please note the condition in "K" in sheet " 7 Jan 14 " is not copied to "K" in sheet " 14 Jan 14 " instead it should be copied in to cell J instead.
I have uploaded a workbook with data. As an example I have manually copied the data from sheet "7 Jan 2014" and paste it in "14 Jan 2014" just to show you how it will look like. You will notice the text in cell "K" of "07 Jan 2014" worksheet is copied to cell "J" in "14 Jan 2014". Rest of the data from "04 Jan 2014" are copied in to the same cells in "14 Jan 2014".
Looking forward for your valuable guidance.
Thanks
Malitec
Requesting your guidance to copy the cells (B:I and K) in each row in sheet " 7 Jan 14 " to cells B:J in sheet " 14 Jan 14 " when the text in K is " Still In Care", which is the condition. Please note the condition in "K" in sheet " 7 Jan 14 " is not copied to "K" in sheet " 14 Jan 14 " instead it should be copied in to cell J instead.
I have uploaded a workbook with data. As an example I have manually copied the data from sheet "7 Jan 2014" and paste it in "14 Jan 2014" just to show you how it will look like. You will notice the text in cell "K" of "07 Jan 2014" worksheet is copied to cell "J" in "14 Jan 2014". Rest of the data from "04 Jan 2014" are copied in to the same cells in "14 Jan 2014".
Looking forward for your valuable guidance.
Thanks
Malitec