AUTO COPY CELL SHEET1 to SHEET2

[RJ1969]

Hello,

Is there any other way to write this in the VBA code?

Please Login or Register  to view this content.

\

Please Login or Register  to view this content.

I have to type this code on every single cells in Sheet2 which I have a lot.

My range are let say…. A1, B1, D4, E9, etc.

Thank you in advance.

[mehmetcik]

Makes no sense to me.

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[RJ1969]

Here you go. Thank you.

[mehmetcik]

Right Click On Your Sheet Name At the Bottom Of Excel and Select View Code
Paste this code in the module that opens and close it.

Please Login or Register  to view this content.

[RJ1969]

mmm... not working.

A1 sheet1 should go to A1 Sheet2
A2 Sheet1 should go to C5 Sheet2
A3 sheet1 should go to B10 Sheet2

[chronjy]

it works well, you put the code on 'Sheets(1) Module' not 'General Module '