Macro copies values in other workbook

  • Thread starter Thread starter bren
  • Start date Start date
B

bren

Hi,

I need a macro that copies two results of workbook1 in two different
cells of workbook2. Example:

I have in A1 a value result of a sum function and in A2 another value
result of another sum function. What I need to do is to copy and paste
both values in workbook2. But the A1 value in c1 (workbook2) and A2
value in d1 (workbook2) as values and not as formula.

Details:

Workbook2 will be closed.
If c1 and d1 from workbook2 have any value, then the macro should
paste values in the next empty row C2 and d2 for example.

Thank you so much for your help!
 
Back
Top