copying data in VBA

[jeskit]

Hi

I was wondering if anyone could help me?

I have three workbooks: DEV, Template and Participation. I need a create a macro in the DEV workbook which opens the template and participation workbooks and copy the text values from the participation workbook in the cells in column A but only when the corresponding cells in Column O and AZ equal "True" and then paste them in the template workbook in sheet 1 cell range B2:CC2

I have a bit of code but it does not work. Can anyone help me?

Please Login or Register  to view this content.

Thank you

Jessica

[jeskit]

Dont worry managed to solve it myself! Recorded the macro so it placed an auto filter on the record and then set it to true and pasted it into the right document