How to move the contents of one cell based on the contents of another cell:

Hello All,

I think this one will be pretty straightforward, but I can't figure it out.

I知 trying to build a macro that would complete the following task:
If cell A2 has a value (text or numbers)= move the contents of B3 to cell C2.

For this example I知 using specific cells, but this would need to be repeated throughout the spreadsheet, so if it could complete the movement based on the relative position of cells instead of specific cells, that would be awesome. The columns will always be the same; which rows it is applied to will not always be the same.

Also, does anyone here know a good place to start learning how I could this stuff myself? I知 pretty good at editing code I find, but not building it from scratch. I want to be more self-reliant. J

Unfortunately I have to post this from an iPad so I can't attach a sheet, but I hope it's straightforward enough without it.

Thanks in advance,

Chad

try this code

Please Login or Register  to view this content.

move the contents of B3 to cell C2

It is really B3 to C2 or is that a mistype?

Stnkynts- yes it is B3 to C2 - it's not a mistype. Thanks for checking.

Yassirkhalil- thanks for providing that. I'm trying to get the code you provided to work, but I get a syntax error at the "Cut Target" part. Any thoughts?

Also, can I incorporate this into a bigger macro, or does it need to be standalone?

Also, can I incorporate this into a bigger macro, or does it need to be standalone?

Do you want to have the macro trigger when you enter a value into a cell in column A, or do you want to be able to run a standalone routine that loops through all of column A?

Please post a sample workbook
I tested my code and it worked very well with no errors

Yassir- I think it was user error. I made a few changes and it's working now. Thanks so much!

Great
Glad to help you and thanks for the feedback
Don't forget to mark the thread as solved