VBA Extract Macro

Hello, I wonder whether someone could help me please.

I'm using the script below to copy data from one sheet to another.

Please Login or Register  to view this content.

The script looks at column E of the' Source' sheet for two values, either "Enhancements" or "OVH". When it finds these value inthe range, it then creates a unique distinct list and copies the data to column of the "Enhancements" (Destination) sheet. There is also additonal functionality which sums a 'Manhour' figure and places this under the relevant monthly column heading.

What I'd like to do is change this, so that if the value "OVH is found it copies the information to the "Overheads" sheet rather than the "Enhancements", but still keep the rest of the code intact, because it works without any problem.

However, despite spending several days on this, I've been unable to find a solution.

I just wondered whether someone could look at this please and offer some guidance on how I may be able to achieve this.

Many thanks

It is difficult to comment with out seeing how the code works within the actual sheet, so this code is Untested.

Please Login or Register  to view this content.

Hi @AB33, thank you very much for taking the time to reply to my post, and for the solution. The code runs without any errors, but unfortunately it doesn't quite produce the desired effect. I'd like, if at all possible, for when the script picks up the value "Enhancements" the information is paste into the "Enhancements" sheet and if the value of "OVH" is found, the paste into the "Overheads" sheet, rather than it's current functionality where everything is paste into the "Overheads" sheet. Many thanks and kind regards

Please attach the sample where the code was initially used. Go to advance then attachment.

Hi @AB33, thank you very much for taking the time to come back to me with this. Unfortuantely, because I'm at work, I'm unable to upload the file, but I will do this on my return home this evening if that's ok. Kind Regards

Hi, as promised, please find the link to my file here.

https://www.dropbox.com/s/jpftgi9gup...al%20Test2.xls

Many thanks and kind regards

Hi Hobbiton73,

Try the attached.