Copy Value from selected cells to a new workbook sheet

Dear all,

I hope you are all well.

I am having a issue copying contents from a selection of cells (Workbook "A") to another Workbook "B".

Both worksheets from both files are identical with the difference that the original (A) has Data Validation; Conditional Formatting and formulas, but the file "B", it's only static data from file "A".

I have managed to copy the contents of file "A" to file "B" but I can't manage to paste values only. It copies all formatting from file "A" and I just want the values.

The other thing is, after running the Macro to copy data from file "A" to "B", the file "B" looses some formulas that I have outside the range that is been paste.
E.g. I want to copy the contents of file "A" from cells F1:Z1 as paste them to the same range in file "B". If I have a formula on file "B" in cell A1, after running the macro, this cell looses the formula and shows only the value.

Here's the code I am using:

Please Login or Register  to view this content.

Is there something wrong on the code or something missing?

As mentioned, the file "A" = "Administration 2013.xlsm"
File "B" (where data is been transported/copied) = "Workload Tool 2013.xlsx"

Your assistance on this will be highly appreciated.

Many thanks in advance and kind regards,
Filipe Oliveira

Hi Holger,

Thanks a million for your reply.

This formula worked as I want it to. That's brilliant and much easier and less code for what I have because I need to do the same for 3 different worksheets.

I am really appreciated with your help here

Best regards,
Filipe Oliveira.

Hehehe

Yes, I did. I didn't wanted to tell you as it could sound bad. You helped me a lot already.

Thanks a million,
Filipe Oliveira