I have a spreadsheet that has all of it's data linked to several different
worksheets. I need to add information to the spreadsheet and want to keep
things in numerical order. this means moving cells down and across two pages.
How can I do this and not loose the links that have already been set up?

The default behavior of a move operation or a cut & paste is to maintain
those links. So moving those cells shouldn't cause a problem.
So just drag and drop or cut & paste

George


Russ wrote:
I have a spreadsheet that has all of it's data linked to several different
worksheets. I need to add information to the spreadsheet and want to keep
things in numerical order. this means moving cells down and across two pages.
How can I do this and not loose the links that have already been set up?

When I move the information on my spreadsheet, it changes the data on each of
the individual worksheets. I need the data that I am moving to keep the link
it has to each worksheet.

"George" wrote:

The default behavior of a move operation or a cut & paste is to maintain
those links. So moving those cells shouldn't cause a problem.
So just drag and drop or cut & paste

George


Russ wrote:
I have a spreadsheet that has all of it's data linked to several different
worksheets. I need to add information to the spreadsheet and want to keep
things in numerical order. this means moving cells down and across two pages.
How can I do this and not loose the links that have already been set up?

OK. I found a way to do this. I had to have all 212 worksheets open while I
moved the cells on my spreedsheet. This allowed my links on my worksheets to
move with the corresponding data.

"Russ" wrote:

When I move the information on my spreadsheet, it changes the data on each of
the individual worksheets. I need the data that I am moving to keep the link
it has to each worksheet.

"George" wrote:

The default behavior of a move operation or a cut & paste is to maintain
those links. So moving those cells shouldn't cause a problem.
So just drag and drop or cut & paste

George


Russ wrote:
I have a spreadsheet that has all of it's data linked to several different
worksheets. I need to add information to the spreadsheet and want to keep
things in numerical order. this means moving cells down and across two pages.
How can I do this and not loose the links that have already been set up?