Copy and paste a range form one sheet to another.

**RinorM** · 11-28-2014, 10:20 AM

Hi,

I have this issue in which I would appreciated if I can get some help.

What I want it to do is that if you choose a value in cell "F4" Sheet "Blad1", I want it to pick a range from the sheet "Fönstertyp".

Example.

If it says "As-11" in cell F4 Sheet Blad 1 I the code to copy values from Sheet "Fönstertyp" Range "E114:F124" and paste it in Sheet Blad1 Cell B8. In Sheet "Fönstertyp" cell E112 you can find the value of the cell that is in Sheet "Blad1" cell "F4".

Would appreciate some help.

Bok1.xlsx

**TMS** · 11-28-2014, 01:32 PM

Please Login or Register  to view this content.

Regards, TMS

**TMS** · 11-28-2014, 01:39 PM

This is better. It clears the Target range before copying and pasting.

Please Login or Register  to view this content.

Regards, TMS

**RinorM** · 11-29-2014, 06:01 PM

Hi TMS,

Thank you very much for this answer. Do I copy and paste the code in the alt-f11 sheet 3? And how do I get the values to be shown in sheet "Blad1"? Would it be more simple if you just add it in the workbook I added in my first thread (bok1.xlsx)

?

Regards,

**RinorM** · 11-29-2014, 06:15 PM

Hi, I managed to fix it.

Again, THANK YOU! By the way nice website, I will definitely recommend it to people who is in need of help of Excel consulting services.

Regards,