In a source sheet I have values:
I want to insert Apple
value from source sheet into a destination sheet multiple times. And I don't want to do it manually (sorry, Russian language excel, it might mean =Sheet3!B2
):
If I select an Apple
cell in a destination sheet and drag a mouse down with Ctrl
pressed, Excel copies values from source sheet "as-is", which is not what I want:
How to duplicate only one specific value from source sheet into another sheet?