Copy/Paste *values* from equation data on a separate sheet in the same workbook

Hello,

I am trying to learn more about VBA / Index & Match, as well as other options to look up data in adjacent sheets in my workbook, but I am encountering trouble. I am attempting to do the following:

1) Copy specific cells (P2 : W2) although, not in that order. I would have to extract each cell individually
2) Paste those values in specific cells in another sheet (Q2 Sheet 2, to P20 Sheet 1 + R2 Sheet 2, to Q20 Sheet 1, etc.)
- I imagine if a single example is shown, I can map the function to the other cells necessary

The major difficulty I am encountering is 1) Avoiding volatility (Want to avoid Offset 2) Difficulty writing the function itself & 3) Difficulty copying then pasting specifically the values from Sheet 2, not the equations themselves. For clarity, I am running on a Mac. I learned of a way to circumvent #3 using windows, but it isn't applicable as far as I know for Mac (In a single string, because I want to avoid right-clicking then pasting special)

Any help would be sincerely appreciated!

Thank you

Hello Davsth,

My apologies for the confusion. I have attached an example below.
I would like to move the highlighted yellow cells on sheet two (values only) to the area highlighted on sheet one.
My apologies for lacking data, the file size was too large.

Thank you for you time!

I think you need to explain more... because what's wrong with:

=Sheet2!B20

?? You're on a Mac?? I've never even pressed a single button on one...

Open this sheet...

In sheet 1 , type = in a cell, then switch to sheet 2 and click in a cell ... Q2 and hit ENTER.. What does it say in the starting cell in Sheet 1?

Originally Posted by SapphireZulu

The contents of the cell don't need to be a text value, right?

Can be anything. A blank cell wil return a 0. We can get rid of them later.

It's because of the space in the tab name. If there's a space it needs to look like

='Sheet 1'!B14