I have data on sheet "Extracted Data" in Cols A to P.
I have dates in Col H for eg 2016/11/25, 2016/10/15, 2016/09/15 etc
I would like a macro to extract the data from Col A to P to a sheet called "Current Data" based on the month to be selected via an input box message or any other method that is suitable. For eg If I want to extract all data pertaining to Nov (which is 11 in the date format eg 2016/11/25) in Col H , the user will Input Nov or 11 and all the data pertaining to Nov from sheet Extracted data to be copied to sheet "Current Data"
Your assistance in this regard is most appreciated
I have dates in Col H for eg 2016/11/25, 2016/10/15, 2016/09/15 etc
I would like a macro to extract the data from Col A to P to a sheet called "Current Data" based on the month to be selected via an input box message or any other method that is suitable. For eg If I want to extract all data pertaining to Nov (which is 11 in the date format eg 2016/11/25) in Col H , the user will Input Nov or 11 and all the data pertaining to Nov from sheet Extracted data to be copied to sheet "Current Data"
Your assistance in this regard is most appreciated