Sorting and segregating alphanumeric code using VBA

Hi SubashP

Let me look at it for a bit...get back to you ASAP.

After transferring the data from the Master_Sheet to New and Old client sheets, do you want Master_sheet to be cleared? i.e. once a row for a new client from master sheet is transferred to the new client sheet, do you want to delete this row from the master sheet?

Originally Posted by sktneer

After transferring the data from the Master_Sheet to New and Old client sheets, do you want Master_sheet to be cleared? i.e. once a row for a new client from master sheet is transferred to the new client sheet, do you want to delete this row from the master sheet?

Sir, initially thank you for your reply.
If possible I want the data to be as it is in Master sheet.
If it creates any problem doing so it can be cleared once it is transferred to "New Clients" sheet or "Old Clients" sheet.
But I don't want it to be as a user form type because I've to paste huge number of data received from my colleagues which will not be possible by filling data one by one.

Thank you in advance.


Subash

Regards,

Please find the attached sheet. There are two codes for Worksheet_Activate Events and can be found on the New_Clients and Old_Clients Sheet Modules.
The code follows the following logic is......
1) Once you paste your data in the Master_Sheet and activate either New_Clients Sheet or Old_Client Sheet, the related data is transferred to the activated sheet (New or Old client sheet).

2) After the data is transferred from the Master Sheet to the one of other two sheets (New or Old sheets), data is cleared from the Master Sheet and is copied to the one more sheet called Backup_Master_Sheet.

See if this helps.

You're welcome and thanks for the feedback as well.