Filter only date and copy to new with entire columns

Hi,

Seeking some one help to create vba macro. I have large data in Excel CSV File. Header row start from Row 6. From column C6 to be filtered with date (to be excluded text and blank cells) and the the filtered data of entire columns to be pasted in new worksheet. kindly help me.

Hey SARAN89 … Try the below code, I assume there are no numbers in column C other than the dates. Make sure the sheet name is the same as per your workbook

Please Login or Register  to view this content.

Hi Nankw83. Thank you so much for your help.

Code is working as expected but its missed to copy and paste of Header Row (ROW 6 is my header). Please help to include that and also requesting please mention active sheet instead mentioning sheet name as "Sample File" (it will be different type of sheets) Thanks

How about below code

Please Login or Register  to view this content.

Hi Nankw83.

Thanks this code is working fine as expected. now header also coming. Column 6 dont have any numbers however some numbers i have in another column, on out put file its pasting that number row also (though i have no date in same row under column "C")

Column 6 dont have any numbers

Column 6 ? It is based on the attached file in post #1 ? If not, post another file to see

Hi Nankw83

Attached supporting file with numbers on other column also attached out put file for your reference. Refer cell AH23 on out put file.

I was checking the last row in column C but it seems your data is not fixed ... I have changed the code to look for the last columns used in the sheet instead ... Try the below

Please Login or Register  to view this content.

Perfect. Now its 100% fine. thanks for your support.

Hi nankw83
Is it possible to close the first workbook (where we are copying data,) after pasting in to new workbook. I tried the below code but its not closing.
"Workbooks(1).Close"

I have added lines to close the first workbook

Please Login or Register  to view this content.

Sorry its not closing the first workbook.

What is closing ? You placed the macro in the workbook where you copy the data from ?

Hi Nankw83.

I placed the macro in personal macro excel workbook. Once data copied and pasted in new workbook. the initial workbook want to close it automatically.

Oh ok I see … Then change wb = ThisWorkbook to wb = ActiveWorkbook

Great.....its worked. thanks for your support...............

Hi Nankw83. I slightly modified the code for my exact requirement. Code is working fine.

Currently the code is copying specific data from one worksheet( Say Workbook A) and pasting in new worksheet (Say Workbook B).i want to modify the code with your help as below.

Need to select multiple files, the code should copy one by one from source work book, and then to be pasted in new worksheet.
Example copy and paste first source file to one workbook (We can save this work book as "Main File"). Then the second source file data to be copied and pasted in last row of main file.similarly for all source file i am selecting. Can you please help me to modify the code?

Formula:

Please Login or Register  to view this content.

I suggest that you start a new thread since your new request is irrelative to this thread question which is marked as solved. In your new thread, be more specific as if all the files in question are in the same folder or not & don't include your code in post # 17 since it has nothing to do with your request so members could provide you with the proper solution.

understood. will create new thread.