Draging info from master sheet to other sheets

[ajk125]

Hi all, I hope you might be able to help me.

I am not sure if Excel can do what i need it to do...

I have a master sheet With information upon it.
I also have two other sheets. Cut and Broken.

I need excel to only drag information from Columns A, B, D, E. Only if the Illness column contains specific info.

Eg. any animal with Broken in the 'Illness' Column (C) it will put it in the Broken sheet with all the info contained in A B D E.

I hope this makes sense.

Thank you for your help!
Anthony

[arshad.99.ali]

Hi
Try attached file to segregate the data

Thank you...

[ajk125]

Thank you.

Can i ask how difficult it is to do or code?

thanks again!

[vcoolio]

Hello Anthony,

Here's another version:-

Please Login or Register  to view this content.

Following is the link to my test work book (this site's file uploader isn't working for me):-

https://www.dropbox.com/s/hab3bwydsw...r%29.xlsm?dl=0

I hope that this helps.

Cheerio,
vcoolio.

[peterrc]

Hi Anthony,

I have attached an alternative solution using Pivot Tables.
See attached.

Regards

peterrc

[arshad.99.ali]

Hi Anthony,

It is quite easy to learn VBA Codings, we just need to have a logical thinking on how to get the output and rest of the codings we can able to learn by working experience

If your thread is solved kindly mark your thread as SOLVED and add reputation points from below.

Happy to help !!!!