Help with macro copying from one workbook into a new worksheet in another workbook

[mjryan12]

Hey guys,

I'm struggling with this one and this forum has never let me down.

This is what I'm trying to do:

I have 3 worksheets. Worksheet A is my macro, worksheet B is reference and always will be, worksheet C is where the data is being manipulated by the macro.

- My macro VBA data is in workbook A.

- I'm trying to copy rows A and B from workbook B and paste them into a new worksheet in workbook C.

- I'm then instructing cells in workbook C to populate based on values in another worksheet already populated in workbook C.

How can I do that?

Thanks!!!