Move Data From one work book based criteria

Hi,


I have attached a sample template.

I need the request below can it be done?

Looking to move data based column d to different work book

Data Raw - This file contains all the raw data (will changed each day). Now in column D Status Code these are constant to the data (Please see codes in sheet name codes these are all the codes)
Data Sorted - All the data from raw sheet should be moved to this file based on the code (all the sheet are named after the code)

The above is what I am trying to achieve.

Thanks in advance.

Try...

Please Login or Register  to view this content.

HI,

Sorry for the delay,

The data hides but is not copied to the file named Data Sorted file

Is the code placed in the Data Sorted file?

Placed in Data Raw file should I place it in Sorted?

Place the code it the Data Sorted workbook.

IT works wonders thank you,

i might need little tweaks Ill try if I face any bumps tweaking the code ill keep in touch,

Thank you again

Glad to hear!