How to "clone" cells (other than move-copy an entire tab)

[trippknightly]

Every couple years / versions I wonder if this is doable. I think the answer is still no, but for a workaround, but prove me wrong.

Suppose I have a range of cells with all kinds of formatting, formulas (relative and absolute references, you name it). Now I want to take that range of cells exactly as they are and morph them into something different. I wish there was a Copy-Paste Special-"Clone" so as to create an exactly alike copy of the original range. The only workaround I can think of is to Move-Copy the whole tab and then on the new tab slash and burn what I don't need then move the clone back to the original. That gets cumbersome.

 

[Micron]

I might be confused because these 2 statement seem contradictory:

morph them into something different

create an exactly alike copy of the original range

This dialog is not sufficient?

 

[trippknightly]

I might be confused because these 2 statement seem contradictory:



This dialog is not sufficient?
View attachment 108795

Thx, nope, and yes I know about Paste Special since I mention it in my post.

If you copy a range that has relative cell references, and paste that copy, say somewhere else on the tab, the relative references will have changed accordingly. That's not a clone.

 

[Micron]

I imagine the only solution is a real code-heavy procedure if the sheet isn't copied first. Given that you only do this once per year, it what you're doing might not make it worth it. Perhaps if the range to be kept is static, then maybe code to copy the sheet then have the code "slash and burn" what you don't want.