Hi,
I need a macro where the source information in one worksheet is copied to another worksheet however, it has to match the column headings and marked with X if it matches. I've attached an excel sheet which hopefully will show what I need to be done. The Subject, Cohort and Dose columns would be copied to match the source, but the Screening, day 1, etc would be placed with an X if it matched in the source.
I'm always adding data to this worksheet so it will be useful to have a macro to run when I update the source information.
Thanks!
And I apologize but I'm a complete newbie to macros.
Bookmarks