Copy specific row data with condition and paste into new workbook

Maybe:

Please Login or Register  to view this content.

Thanks for revert, John. I appreciate your efforts!!

Separate Workbooks are getting created on the name of the Group but it's data is not getting captured. These workbooks are actually blank.

Also, I want to set the path of a folder into which these workbooks should get saved one by one with desired data.

Moreover, these workbooks remain Open. these should get closed once data is been captured.

Thanks!!

When I tested it on a sample I created it copied the data too the newly created workbooks. Can you provide a sample, so I can see where the problem may be. Also provide a path folder for where you want the files stored, so I can make changes in the code. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

Here is the sample sheet with your script embedded. Please take a look and confirm.

I am using MS Excel 2010 version, hope this is not the problem area.

Folder path - anywhere in D Drive (D:\tdugga\......)

Maybe that was the problem. I at first had the files saving as .xls now I changed to .xlsx.

Please Login or Register  to view this content.

You need to make two changes in the code. I think you'll understand. They are highlighted in red. Again the code worked for me on the sample you provided.

Hi,

I am sorry but this time also it doesn't give end result in desired format.

1. This script is giving error at the time of closing new workbooks.
2. New Workbooks are getting created with its correct Group name but data is not getting pasted in it. Whole workbook is blank.
3. In Sample FAR.xlsm workbook, A blank row is getting inserted in between of non matching groups. (Below data is for reference)

Group Name
ACE sadflknsdj
ACE kfnjbasdjca
ACE inisdbaubc

ACCA mnnfdni
ACCA iknunc

ACE fikniens

LOAD jnwebcbd

ACCA iweybdeca

LOAD jjvbbfs

Please apply some different trick to function this.

Thanks for valuable time & efforts.!! Much appreciated.

Did you make the changes highlighted in Red? On of them is the name of your original workbook. The code I provided still works on the sample you provided when I test it. I don't know what else to offer?