To paste a cell from one worksheet to another by a reference cell

lyon2021

New Member
Joined
Jun 23, 2021
Messages
1
Office Version
  1. 2016
Platform
  1. Windows
Hi, I'm new on VBA. How to paste a cell from one worksheet to another through a reference cell? For example, I wrote a formula "=INDIRECT("'"&$G$1&"'!"&"A1")", G1 is from sheet 1 and contains the name of the other sheet. A1 is a cell of the other sheet. So if I put this formula into a cell of sheet 1, the content of A1 on the other sheet will be showing here.

Now I try to do in opposite. My question is : How to copy a cell from sheet 1 (like cell B1) and paste to A1 on the other sheet. Many Thx!!
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

RayFrye

Board Regular
Joined
Jan 31, 2005
Messages
125
Office Version
  1. 365
  2. 2019
Have you searched this forum or any other forum for an answer or even a clue?
Have you created a single line of VBA code?
If you have created a subroutine and it doesn't work for you, paste the code and someone will help you.
 

Forum statistics

Threads
1,148,236
Messages
5,745,545
Members
423,959
Latest member
Bismarkmensah

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top