Data copy and paste to multiple sheets by renaming the names

Hello,

I have a spreadsheet with few lines of data and I need to copy & paste the data based on the column A to multiple sheets based on the invoice numbers.
Based on the invoice numbers, new sheet has to be inserted and has to be renamed with the invoice number and the data matches to the invoice number has to be copied and paste to the sheets.

I did try this with Auto filter and is working fine except renaming the file names with invoice number and it has to automatically stop once the unique number reaches to the last in the filter.

enslosed the sample file and tried with EXcel record macros.split.xls

Regards,
Ignesh.

Hi,

The code really helps if the data is only in two columns but the real data what I have fluctuates in many columns and hence the copy & paste has to happen for entire rows and not only for two columns which had in SPLIT sheet.

I tried modifying it, but was not successful else the code is perfect and working correctly as desired.

can you tweak the code so that the copy & paste happens to entire rows.

Regards,
Ignesh.