data transfer from cell to cell

Copper Contributor

Hello

I hope I explain it well:

I have a numerical value in cell B9 (there is also a formula in that cell)

I need this value to be transferred to cell B12

What way:
- I just click on cell B12
- or I just write any character in cell B12. For example: a, +, etc..

Next step: to make it work in the range: B12-B42:J12-J42
It is possible?

Well thank you
Martin

2 Replies

@Martin_Szalay 

You can use a formula to replicate the value from cell B9 to a range of cells (B12:J42).

Here is how you can do it:

  1. In cell B12, enter the following formula:

=B9

  1. Press Enter to confirm the formula. This will copy the value from cell B9 to cell B12.
  2. Select cell B12.
  3. Place your cursor at the bottom right corner of cell B12 until it turns into a small square "fill handle."
  4. Click and drag the fill handle across the range of cells you want to populate (B12:J42).
  5. Release the mouse button to fill the selected range with the value from cell B9.

This method uses a formula to copy the value from cell B9 to cell B12 and then uses Excel's fill handle to extend that formula to the desired range. However, please note that this is not a dynamic solution, meaning it will not automatically update if the value in cell B9 changes. You would need to manually repeat this process if the value in B9 changes and you want the updated value in the range B12:J42.

 

To automatically transfer the numerical value from cell B9 to cell B12 and then populate a range of cells (B12 to J42) with that value, you can use a simple VBA (Visual Basic for Applications) macro. Here is a step-by-step guide on how to achieve this:

  1. Press ALT + F11 to open the Visual Basic for Applications (VBA) editor in Excel.
  2. In the VBA editor, click Insert > Module to insert a new module.
  3. Copy and paste the following VBA code into the module window:

Vba code:

Sub TransferValue()
    Dim sourceCell As Range
    Dim targetRange As Range
    
    ' Define the source cell (B9) and the target range (B12:J42)
    Set sourceCell = ThisWorkbook.Sheets("Sheet1").Range("B9")
    Set targetRange = ThisWorkbook.Sheets("Sheet1").Range("B12:J42")
    
    ' Copy the value from the source cell to the target range
    targetRange.Value = sourceCell.Value
End Sub
  1. Modify the code as needed to specify the worksheet and cell ranges you want to work with. In the example above, it assumes you are working with "Sheet1" and copying from B9 to B12:J42. Change "Sheet1" to the name of your worksheet if it is different.
  2. Close the VBA editor.
  3. To run the macro, press ALT + F8 to open the "Macro" dialog box, select "TransferValue," and click "Run."

Now, the value from cell B9 will be copied to cell B12 and then populated in the range B12:J42. You can run this macro whenever you need to transfer the value.

Please note that using VBA macros requires enabling macros in your Excel settings. Also, make sure to save your Excel workbook with macros as a macro-enabled workbook with the ".xlsm" file extension. The text and steps were edited with the help of AI.

 

My answers are voluntary and without guarantee!

 

Hope this will help you.

Was the answer useful? Mark them as helpful and like it!

This will help all forum participants.

Thank you very much!
I will definitely try and play around with it!
Martin