How to copy an array without changing relative cell refferences?

Hello specialists!
How to copy an array to an array of the same size without changing relative
cell references in the formulas?
Best regards,
Dima

One way is to change the formulas so that Excel will not recognize them as
formulas, do the copy and paste, then change them back.
Do this:
Select the range (the array) that you want to copy.
Click on Edit - Replace.
In the "Find what:" box, type "=" without the quotes.
In the "Replace with:" box type "Dmitry" without the quotes.
Click OK.
Copy and paste.
Now select the new range and reverse the process.
Done
HTH Otto
"Dmitry" <[email protected]> wrote in message
news:[email protected]...
> Hello specialists!
> How to copy an array to an array of the same size without changing
> relative
> cell references in the formulas?
> Best regards,
> Dima
>
>

Just another take on Otto's suggestion.

Using Dmitry may not be the best solution for you. If you have your name in any
other cell, you may mess those up when you're doing the second half.

I try to use a unique value ($$$$$=) when I do it.

Otto Moehrbach wrote:
>
> One way is to change the formulas so that Excel will not recognize them as
> formulas, do the copy and paste, then change them back.
> Do this:
> Select the range (the array) that you want to copy.
> Click on Edit - Replace.
> In the "Find what:" box, type "=" without the quotes.
> In the "Replace with:" box type "Dmitry" without the quotes.
> Click OK.
> Copy and paste.
> Now select the new range and reverse the process.
> Done
> HTH Otto
> "Dmitry" <[email protected]> wrote in message
> news:[email protected]...
> > Hello specialists!
> > How to copy an array to an array of the same size without changing
> > relative
> > cell references in the formulas?
> > Best regards,
> > Dima
> >
> >

--

Dave Peterson

That's a good idea Dave, Thanks. Otto
"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> Just another take on Otto's suggestion.
>
> Using Dmitry may not be the best solution for you. If you have your name
> in any
> other cell, you may mess those up when you're doing the second half.
>
> I try to use a unique value ($$$$$=) when I do it.
>
> Otto Moehrbach wrote:
>>
>> One way is to change the formulas so that Excel will not recognize them
>> as
>> formulas, do the copy and paste, then change them back.
>> Do this:
>> Select the range (the array) that you want to copy.
>> Click on Edit - Replace.
>> In the "Find what:" box, type "=" without the quotes.
>> In the "Replace with:" box type "Dmitry" without the quotes.
>> Click OK.
>> Copy and paste.
>> Now select the new range and reverse the process.
>> Done
>> HTH Otto
>> "Dmitry" <[email protected]> wrote in message
>> news:[email protected]...
>> > Hello specialists!
>> > How to copy an array to an array of the same size without changing
>> > relative
>> > cell references in the formulas?
>> > Best regards,
>> > Dima
>> >
>> >
>
> --
>
> Dave Peterson

That's a good idea Dave, Thanks. Otto
"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> Just another take on Otto's suggestion.
>
> Using Dmitry may not be the best solution for you. If you have your name
> in any
> other cell, you may mess those up when you're doing the second half.
>
> I try to use a unique value ($$$$$=) when I do it.
>
> Otto Moehrbach wrote:
>>
>> One way is to change the formulas so that Excel will not recognize them
>> as
>> formulas, do the copy and paste, then change them back.
>> Do this:
>> Select the range (the array) that you want to copy.
>> Click on Edit - Replace.
>> In the "Find what:" box, type "=" without the quotes.
>> In the "Replace with:" box type "Dmitry" without the quotes.
>> Click OK.
>> Copy and paste.
>> Now select the new range and reverse the process.
>> Done
>> HTH Otto
>> "Dmitry" <[email protected]> wrote in message
>> news:[email protected]...
>> > Hello specialists!
>> > How to copy an array to an array of the same size without changing
>> > relative
>> > cell references in the formulas?
>> > Best regards,
>> > Dima
>> >
>> >
>
> --
>
> Dave Peterson

I once suggested a generic unique string and the poster used the apostrophe.

And that was a mess (for the poster)--not so much for me <bg>.

Otto Moehrbach wrote:
>
> That's a good idea Dave, Thanks. Otto
> "Dave Peterson" <[email protected]> wrote in message
> news:[email protected]...
> > Just another take on Otto's suggestion.
> >
> > Using Dmitry may not be the best solution for you. If you have your name
> > in any
> > other cell, you may mess those up when you're doing the second half.
> >
> > I try to use a unique value ($$$$$=) when I do it.
> >
> > Otto Moehrbach wrote:
> >>
> >> One way is to change the formulas so that Excel will not recognize them
> >> as
> >> formulas, do the copy and paste, then change them back.
> >> Do this:
> >> Select the range (the array) that you want to copy.
> >> Click on Edit - Replace.
> >> In the "Find what:" box, type "=" without the quotes.
> >> In the "Replace with:" box type "Dmitry" without the quotes.
> >> Click OK.
> >> Copy and paste.
> >> Now select the new range and reverse the process.
> >> Done
> >> HTH Otto
> >> "Dmitry" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > Hello specialists!
> >> > How to copy an array to an array of the same size without changing
> >> > relative
> >> > cell references in the formulas?
> >> > Best regards,
> >> > Dima
> >> >
> >> >
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson

Thanks Otto Moehrbach!
Dependents on the target destination will lose their precedents if I
override the target destination by pasting the array.
"Otto Moehrbach" <[email protected]> сообщил/сообщила в новостях
следующее: news:uy%23%237%[email protected]...
> One way is to change the formulas so that Excel will not recognize them as
> formulas, do the copy and paste, then change them back.
> Do this:
> Select the range (the array) that you want to copy.
> Click on Edit - Replace.
> In the "Find what:" box, type "=" without the quotes.
> In the "Replace with:" box type "Dmitry" without the quotes.
> Click OK.
> Copy and paste.
> Now select the new range and reverse the process.
> Done
> HTH Otto
> "Dmitry" <[email protected]> wrote in message
> news:[email protected]...
> > Hello specialists!
> > How to copy an array to an array of the same size without changing
> > relative
> > cell references in the formulas?
> > Best regards,
> > Dima
> >
> >
>
>

Thanks Dave Peterson!
"Dave Peterson" <[email protected]> ???????/???????? ? ????????
?????????: news:[email protected]...
> Just another take on Otto's suggestion.
>
> Using Dmitry may not be the best solution for you. If you have your name
in any
> other cell, you may mess those up when you're doing the second half.
>
> I try to use a unique value ($$$$$=) when I do it.
>
> Otto Moehrbach wrote:
> >
> > One way is to change the formulas so that Excel will not recognize them
as
> > formulas, do the copy and paste, then change them back.
> > Do this:
> > Select the range (the array) that you want to copy.
> > Click on Edit - Replace.
> > In the "Find what:" box, type "=" without the quotes.
> > In the "Replace with:" box type "Dmitry" without the quotes.
> > Click OK.
> > Copy and paste.
> > Now select the new range and reverse the process.
> > Done
> > HTH Otto
> > "Dmitry" <[email protected]> wrote in message
> > news:[email protected]...
> > > Hello specialists!
> > > How to copy an array to an array of the same size without changing
> > > relative
> > > cell references in the formulas?
> > > Best regards,
> > > Dima
> > >
> > >
>
> --
>
> Dave Peterson

I was wrong that Dependents will lose their precedents.
"Dmitry" <[email protected]> сообщил/сообщила в новостях следующее:
news:[email protected]...
> Thanks Otto Moehrbach!
> Dependents on the target destination will lose their precedents if I
> override the target destination by pasting the array.
> "Otto Moehrbach" <[email protected]> сообщил/сообщила в новостях
> следующее: news:uy%23%237%[email protected]...
> > One way is to change the formulas so that Excel will not recognize them
as
> > formulas, do the copy and paste, then change them back.
> > Do this:
> > Select the range (the array) that you want to copy.
> > Click on Edit - Replace.
> > In the "Find what:" box, type "=" without the quotes.
> > In the "Replace with:" box type "Dmitry" without the quotes.
> > Click OK.
> > Copy and paste.
> > Now select the new range and reverse the process.
> > Done
> > HTH Otto
> > "Dmitry" <[email protected]> wrote in message
> > news:[email protected]...
> > > Hello specialists!
> > > How to copy an array to an array of the same size without changing
> > > relative
> > > cell references in the formulas?
> > > Best regards,
> > > Dima
> > >
> > >
> >
> >
>
>

Maybe you just want to Edit|Cut instead of Edit|copy???

Dmitry wrote:
>
> I was wrong that Dependents will lose their precedents.
> "Dmitry" <[email protected]> сообщил/сообщила в новостях следующее:
> news:[email protected]...
> > Thanks Otto Moehrbach!
> > Dependents on the target destination will lose their precedents if I
> > override the target destination by pasting the array.
> > "Otto Moehrbach" <[email protected]> сообщил/сообщила в новостях
> > следующее: news:uy%23%237%[email protected]...
> > > One way is to change the formulas so that Excel will not recognize them
> as
> > > formulas, do the copy and paste, then change them back.
> > > Do this:
> > > Select the range (the array) that you want to copy.
> > > Click on Edit - Replace.
> > > In the "Find what:" box, type "=" without the quotes.
> > > In the "Replace with:" box type "Dmitry" without the quotes.
> > > Click OK.
> > > Copy and paste.
> > > Now select the new range and reverse the process.
> > > Done
> > > HTH Otto
> > > "Dmitry" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > Hello specialists!
> > > > How to copy an array to an array of the same size without changing
> > > > relative
> > > > cell references in the formulas?
> > > > Best regards,
> > > > Dima
> > > >
> > > >
> > >
> > >
> >
> >

--

Dave Peterson

Will Edit|Cut instead of Edit|copy brake a link with Dependents on the
target destination, without replacing =?
"Dave Peterson" <[email protected]> ???????/???????? ? ????????
?????????: news:[email protected]...
> Maybe you just want to Edit|Cut instead of Edit|copy???
>
> Dmitry wrote:
> >
> > I was wrong that Dependents will lose their precedents.
> > "Dmitry" <[email protected]> сообщил/сообщила в новостях следующее:
> > news:[email protected]...
> > > Thanks Otto Moehrbach!
> > > Dependents on the target destination will lose their precedents if I
> > > override the target destination by pasting the array.
> > > "Otto Moehrbach" <[email protected]> сообщил/сообщила в новостях
> > > следующее: news:uy%23%237%[email protected]...
> > > > One way is to change the formulas so that Excel will not recognize
them
> > as
> > > > formulas, do the copy and paste, then change them back.
> > > > Do this:
> > > > Select the range (the array) that you want to copy.
> > > > Click on Edit - Replace.
> > > > In the "Find what:" box, type "=" without the quotes.
> > > > In the "Replace with:" box type "Dmitry" without the quotes.
> > > > Click OK.
> > > > Copy and paste.
> > > > Now select the new range and reverse the process.
> > > > Done
> > > > HTH Otto
> > > > "Dmitry" <[email protected]> wrote in message
> > > > news:[email protected]...
> > > > > Hello specialists!
> > > > > How to copy an array to an array of the same size without changing
> > > > > relative
> > > > > cell references in the formulas?
> > > > > Best regards,
> > > > > Dima
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
>
> --
>
> Dave Peterson

If you want the dependent cells to point at the new location, I think you're
going to have to use Edit|Cut.

But try it and see if it works.

Dmitry wrote:
>
> Will Edit|Cut instead of Edit|copy brake a link with Dependents on the
> target destination, without replacing =?
> "Dave Peterson" <[email protected]> ???????/???????? ? ????????
> ?????????: news:[email protected]...
> > Maybe you just want to Edit|Cut instead of Edit|copy???
> >
> > Dmitry wrote:
> > >
> > > I was wrong that Dependents will lose their precedents.
> > > "Dmitry" <[email protected]> сообщил/сообщила в новостях следующее:
> > > news:[email protected]...
> > > > Thanks Otto Moehrbach!
> > > > Dependents on the target destination will lose their precedents if I
> > > > override the target destination by pasting the array.
> > > > "Otto Moehrbach" <[email protected]> сообщил/сообщила в новостях
> > > > следующее: news:uy%23%237%[email protected]...
> > > > > One way is to change the formulas so that Excel will not recognize
> them
> > > as
> > > > > formulas, do the copy and paste, then change them back.
> > > > > Do this:
> > > > > Select the range (the array) that you want to copy.
> > > > > Click on Edit - Replace.
> > > > > In the "Find what:" box, type "=" without the quotes.
> > > > > In the "Replace with:" box type "Dmitry" without the quotes.
> > > > > Click OK.
> > > > > Copy and paste.
> > > > > Now select the new range and reverse the process.
> > > > > Done
> > > > > HTH Otto
> > > > > "Dmitry" <[email protected]> wrote in message
> > > > > news:[email protected]...
> > > > > > Hello specialists!
> > > > > > How to copy an array to an array of the same size without changing
> > > > > > relative
> > > > > > cell references in the formulas?
> > > > > > Best regards,
> > > > > > Dima
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson

The dependent cells point at the new location now, before Edit|Cut. Will
Edit|Cut brake a link with Dependents on the new, target destination,
without replacing =?
"Dave Peterson" <[email protected]> ???????/???????? ? ????????
?????????: news:[email protected]...
> If you want the dependent cells to point at the new location, I think
you're
> going to have to use Edit|Cut.
>
> But try it and see if it works.
>
> Dmitry wrote:
> >
> > Will Edit|Cut instead of Edit|copy brake a link with Dependents on the
> > target destination, without replacing =?
> > "Dave Peterson" <[email protected]> ???????/???????? ? ????????
> > ?????????: news:[email protected]...
> > > Maybe you just want to Edit|Cut instead of Edit|copy???
> > >
> > > Dmitry wrote:
> > > >
> > > > I was wrong that Dependents will lose their precedents.
> > > > "Dmitry" <[email protected]> сообщил/сообщила в новостях следующее:
> > > > news:[email protected]...
> > > > > Thanks Otto Moehrbach!
> > > > > Dependents on the target destination will lose their precedents if
I
> > > > > override the target destination by pasting the array.
> > > > > "Otto Moehrbach" <[email protected]> сообщил/сообщила в
новостях
> > > > > следующее: news:uy%23%237%[email protected]...
> > > > > > One way is to change the formulas so that Excel will not
recognize
> > them
> > > > as
> > > > > > formulas, do the copy and paste, then change them back.
> > > > > > Do this:
> > > > > > Select the range (the array) that you want to copy.
> > > > > > Click on Edit - Replace.
> > > > > > In the "Find what:" box, type "=" without the quotes.
> > > > > > In the "Replace with:" box type "Dmitry" without the quotes.
> > > > > > Click OK.
> > > > > > Copy and paste.
> > > > > > Now select the new range and reverse the process.
> > > > > > Done
> > > > > > HTH Otto
> > > > > > "Dmitry" <[email protected]> wrote in message
> > > > > > news:[email protected]...
> > > > > > > Hello specialists!
> > > > > > > How to copy an array to an array of the same size without
changing
> > > > > > > relative
> > > > > > > cell references in the formulas?
> > > > > > > Best regards,
> > > > > > > Dima
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > >
> > > --
> > >
> > > Dave Peterson
>
> --
>
> Dave Peterson

I think I'm confused about what you want.

Maybe you could just do some small experiments to see what works best.

Dmitry wrote:
>
> The dependent cells point at the new location now, before Edit|Cut. Will
> Edit|Cut brake a link with Dependents on the new, target destination,
> without replacing =?
> "Dave Peterson" <[email protected]> ???????/???????? ? ????????
> ?????????: news:[email protected]...
> > If you want the dependent cells to point at the new location, I think
> you're
> > going to have to use Edit|Cut.
> >
> > But try it and see if it works.
> >
> > Dmitry wrote:
> > >
> > > Will Edit|Cut instead of Edit|copy brake a link with Dependents on the
> > > target destination, without replacing =?
> > > "Dave Peterson" <[email protected]> ???????/???????? ? ????????
> > > ?????????: news:[email protected]...
> > > > Maybe you just want to Edit|Cut instead of Edit|copy???
> > > >
> > > > Dmitry wrote:
> > > > >
> > > > > I was wrong that Dependents will lose their precedents.
> > > > > "Dmitry" <[email protected]> сообщил/сообщила в новостях следующее:
> > > > > news:[email protected]...
> > > > > > Thanks Otto Moehrbach!
> > > > > > Dependents on the target destination will lose their precedents if
> I
> > > > > > override the target destination by pasting the array.
> > > > > > "Otto Moehrbach" <[email protected]> сообщил/сообщила в
> новостях
> > > > > > следующее: news:uy%23%237%[email protected]...
> > > > > > > One way is to change the formulas so that Excel will not
> recognize
> > > them
> > > > > as
> > > > > > > formulas, do the copy and paste, then change them back.
> > > > > > > Do this:
> > > > > > > Select the range (the array) that you want to copy.
> > > > > > > Click on Edit - Replace.
> > > > > > > In the "Find what:" box, type "=" without the quotes.
> > > > > > > In the "Replace with:" box type "Dmitry" without the quotes.
> > > > > > > Click OK.
> > > > > > > Copy and paste.
> > > > > > > Now select the new range and reverse the process.
> > > > > > > Done
> > > > > > > HTH Otto
> > > > > > > "Dmitry" <[email protected]> wrote in message
> > > > > > > news:[email protected]...
> > > > > > > > Hello specialists!
> > > > > > > > How to copy an array to an array of the same size without
> changing
> > > > > > > > relative
> > > > > > > > cell references in the formulas?
> > > > > > > > Best regards,
> > > > > > > > Dima
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson