Copy/Paste Range of Cells w/ References to other Sheets

Hi Phil,

It's not clear what you want to happen.

Sheet 1::Table 1

Formulas in row 2 filled right from the formula shown in B2.

B3 has a similar formula referencing B2 and using ROW() to determine the number of repeats.

With cells B2:D6 selected and copied, then Pasted with B2 selected on Sheet 2::Table 1

The results , after entering a single "k" in A2 were this (same cell selected to display formula below table):

What was your expectation?

Regards,

Barry

philfromjohnstown wrote:

I'm having trouble copying & pasting a range of cells with references on that sheet to other sheets - with the referenced cells remaining on the 1st sheet only.

Do you mean something like this?

Here I have the cells in column A of Table 1 referring to cells in column C of Table 1.

But when I select the cells in column A, Edit > Cut, and paste into Table 2, the formulas now refer to column C of Table 2 instead of the original cells in Table 1.

If you want to keep the reference to the original cells in Table 1, then instead of copy-paste you can just select the cells, hold down the "mouse" button (or trackpad equivalent) and drag them into Table 2.

Result:

SG

HI Phil,

You get only one "solved" and two "helpful" markers on a question. You can 'upgrade' a "helpful" to a "solved", but can't move in the other direction. Sometimes it's a good idea to wait a while before hitting the buttons.

Looking back at my post, I see I inserted the wrong screen shot for the second example. The table should look the same (as it does), but the content should be all "k"s instead of "1"s. My bad! Here's the one that better matches what I described.

Regards,

Barry

If I remember correctly the original poster can mark one post as Solved and two as Helpful. Those will then appear up near to top for the convenience of future searchers. Once marked they can't be changed. You already marked one as Solved and have the option of marking up to two others as Helpful.

SG

Was the explanation helpful?

SG

What works even better? The post you've marked 'Solved'?

SG