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.
Bookmarks