Macro copy paste value between worksheets

Hi,

I'm kinda new to Excel, so if someone could please help me.


I want to write a macro which:

If F43 on sheet 2 = 'x', then copy F43's 'x' to G324:330, G332:334 on sheet 4
and then also copies text from H43 (sheet 2) to H324:330, H332:334 on sheet 4.


Thanks in advance.
-Absel

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.


To add a file to a post

Hi Absel

Welcome to the Forum....
Can give this a go:

Please Login or Register  to view this content.

Here's the file.

Hi sintek, thanks for the reply.

This is something I've been looking for, but unfortunately, it doesn't work.
As I said, I'm kinda new to Excel. I've done some stuff with VBA in Visual Studio before, so I know some things. However, Excel works quite differently.

I tried to adjust it, so that it would work but with no positive result. This is the code now:

Please Login or Register  to view this content.

(*Note: I adjusted some cells and numbers to run properly with the uploaded file.)

When this runs, it says "Compile error: A variable is not defined". When this error appears, "Sub CopyX()" is highlighted in yellow and "Sheet2 =" is highlighted blue (like when you highlight something with your mouse).

What's wrong?

No No No....Here you go:

Please Login or Register  to view this content.

Oh my word...I made a newbie error lol...Too hasty

Please Login or Register  to view this content.

sintek,

Thank you very much! It works now, I really appreciate it. Will click on that fancy star button next to your post

Thanks again!

pleasure Absel, tx for rep