How to extract same data twice from one cell in one sheet to two cells of another sheet of the same workbook?

[Stevekent]

My workbook has 2 worksheets. Worksheet 1 cell A1 contain ABC, cell A2 contain DEF. Now, how can I automatically extract these data to worksheet 2 cell A1 as ABC, cell A2 also ABC, and Cell A3 is DEF, A4 also same DEF

 

[jolivanes]

We don't need bold text over the whole question. It's like shouting.

Regarding your question.
Is that just for these two cells, A1 and A2? Or do you have a range of cells that needs to be doubled?

And what do you consider "automatically"" Press of a macro Button? When changing a certain cell?

 

[jolivanes]

When changing either Cell A1 or Cell A2 in Sheet1 (Automatically)
Code goes in Sheet1 Module

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("A1:A2")) Is Nothing Then
        Sheets("Sheet2").Range("A1:A2").Value = Sheets("Sheet1").Range("A1").Value
        Sheets("Sheet2").Range("A3:A4").Value = Sheets("Sheet1").Range("A2").Value
    End If
End Sub

Or with a Macro Button or Keyboard Shortcut.
Code goes in a regular Module

Sub With_Macro_Button()
    Sheets("Sheet2").Range("A1:A2").Value = Sheets("Sheet1").Range("A1").Value
    Sheets("Sheet2").Range("A3:A4").Value = Sheets("Sheet1").Range("A2").Value
End Sub

 

[Stevekent]

Sorry, I didn't notice I bold it.
I didn't really mean automatically, I just want an Excel formula to do it.
BTW, beside the Macro you suggest, is there a formula to do it.
Thank you very much

 

[My Aswer Is This]

Sorry, I didn't notice I bold it.
I didn't really mean automatically, I just want an Excel formula to do it.
BTW, beside the Macro you suggest, is there a formula to do it.
Thank you very much

If you just want a formula, you will just enter a formula like this in the cell you want in sheet2.

=Sheet1!A1
or:
=Sheet1!A2

And so, on

 

[Stevekent]

If you just want a formula, you will just enter a formula like this in the cell you want in sheet2.

=Sheet1!A1
or:
=Sheet1!A2

And so, on

This is not what I want. What I want is sheet2 A1 and A2 has the same value of sheet1 A1, and sheet2 A3 and A4 has same value as sheet1A2 and so on.

 

[My Aswer Is This]

This is not what I want. What I want is sheet2 A1 and A2 has the same value of sheet1 A1, and sheet2 A3 and A4 has same value as sheet1A2 and so on.

Yes. I just gave you an example.
Just modify to your needs.

 

[Stevekent]

Yes. I just gave you an example.
Just modify to your needs.

If I use your method, I have to enter every cells and it'll be very tedious and a lot of works. What I want is just a formula to insert in the cell and drag it down

 

[My Aswer Is This]

If I use your method, I have to enter every cells and it'll be very tedious and a lot of works. What I want is just a formula to insert in the cell and drag it down

This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.

 

[Stevekent]

Please, could someone help me on this. Thank you in advance