Macro copies values in other workbook

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to Keeping Same Display Value on 2 Workbooks 1
How to access a function from a different workbook 1
Vlookup or Match VBA 6
Workbook Variables 2
Cut from workbook1, paste to workbook2, get automatic link in workbook1 1
Macro in 2nd Open workbook 1
find first empty cell in range and then copy from another workbook 1
Copying data from one workbook to another dependent on user select 1

Top