Jun 26 2021 11:57 AM
Hello, all
I am rather new to Excel & am needing some help on what might seem pretty basic to the rest of you with more experience. So thank you in advance for the help & the patience in my lack of understanding how things work
I am wanting to push the content of a range of cells on 1 sheet appear on another sheet in a way where it will auto update any changes made to the original source
So instead of having to copy & paste the content from a range of cells from Sheet A to Sheet B I can make an *exact instance* of this range from Sheet A appear on Sheet B. That is to say, if I edit the content in the original sheet's range (Sheet A) then the content will also update in the range that is on the other sheet (Sheet B) without having to manually jump to each sheet & edit them both manually
If I copy & paste an item, even though the content appears on both sheets, it will not update so this is not really a viable option
What I have been trying to do is use *=* in a cell in Sheet B, jump to Sheet A & select 3 cells for example, & press enter. I was expecting the range of 3 cells to now appear on Sheet B but I only get the 1st cell (not all 3)
Does this feature not exist or am I doing something wrong?
If it helps/ matters I am using Office Home & Student 2019
Thank you for all the help. Just a reminder that I am new to Excel so please remember I might not understand all terms used so if you could explain things a little more that would be helpful
Jun 26 2021 12:54 PM
Select the entire source range.
Copy it by clicking the Copy button on the Home tab of the ribbon or by pressing Ctrl+C.
Activate the target sheet, and select the top left cell of the target range.
Click the lower half of the Paste button on the Home tab of the ribbon.
Click 'Paste Link'.
Excel will paste a link formula for each of the cells in the source range.
Jun 26 2021 01:40 PM
Jun 26 2021 01:57 PM
Excel doesn't have a "short" shortcut for Paste Link, but you can use Alt+H V N
Jun 26 2021 02:15 PM
Jun 26 2021 02:18 PM
SolutionAnother couple of options
Ctrl+Alt+V (which pops up Paste Special window) and her character associated with menu item. In this case Ctrl+Alt+V+L
Ctrl+V, Ctrl (Paste Special icons will appear), arrow Down, Down, Down, Right, Enter
Jun 26 2021 02:18 PM
Jun 26 2021 02:21 PM
Jun 26 2021 02:18 PM
SolutionAnother couple of options
Ctrl+Alt+V (which pops up Paste Special window) and her character associated with menu item. In this case Ctrl+Alt+V+L
Ctrl+V, Ctrl (Paste Special icons will appear), arrow Down, Down, Down, Right, Enter