Compare to workbooks, and copy certain values if they have the same worksheetname

[Hjahren]

Hi,

I want to write a macro that does the following:
Compare workbook "A" to workbook "B".
Define a list of worksheetnames, for instance "C 01.00", "C 02.00".
If both A and B has the worksheet "C 01.00", then copy values from
Cell A1, B14, D11 from workbook A and paste it into same worskheet same cells in Workbook B.

I have to be able to define which cells to be copied given each worksheet.

Thanks!

Henrik

[HaHoBe]

Hi, Henrik ,

you would need to inform us where the code is to be located and if the workbooks are open or need to be opened.

This code assumes both workbooks to be open in one instance of Excel:

Please Login or Register  to view this content.

In case of multiple areas to copy I would suggest to use a table in a worksheet to store the information.

Ciao,
Holger

[Hjahren]

Hi again,

Thank you - this looks like the start of something.
The two workbooks are open, thats fine. I can handle the location of the code. I need help with the more advanced part

The workbook A and B are the same, the only difference is that some of the cells are protected for writing i workbook B (containing calculations etc). Is it from a to b, given that it is allowed by the workbook and that the worksheetname is the same?

[HaHoBe]

Hi, Henrik,

I havben´t considered the protection as it wasn´t mentioned (you could add a line to unprotect, run the copy part, protect the sheet again or have a look at the parameter UserInterfaceOnly within protect). You would need to give some information on how many different ranges for sheets you will have.

The code is designed to copy from wokbook B to workbook A by direct copying of values, not formulas.

HTH,
Holger

[Hjahren]

Hi Holger,

Thank you for your quick replies. As a wrote in the start:
"I have to be able to define which cells to be copied given each worksheet."
If I can define which cells to be copied, given that it is a different set of cells for each worksheet, then I don't have to unprotect the worksheet (I don't have the rights to do it).

I am not sure if I understood what you needed more info about:
The workbook contains approx 20 sheets, with different cells to be copied.

Cheers,
Henrik