Linked Cells and Sort Issues
 

Hi All.

I've created a workbook where a group of cells from one worksheet (worksheet
B) are populated by way of a link to another worksheet (worksheet A).
Worksheet B also has manual input in the column next to the columns that are
linked from worksheet A. When worksheet A gets sorted the manual input in
worksheet B doesn't sort with the other fileds.

How can I make them stay together?

Linked Cells and Sort Issues
 

Hi Geraldine;
If you can put the manual inputs into Sheet A and then it will work. If you
cannot do that then you'll have to write a macro that will retrieve the data
from Sheet A and put it into Sheet B plus the sorting.

I hope it helps,


"Geraldine" wrote:

Hi All.

I've created a workbook where a group of cells from one worksheet (worksheet
B) are populated by way of a link to another worksheet (worksheet A).
Worksheet B also has manual input in the column next to the columns that are
linked from worksheet A. When worksheet A gets sorted the manual input in
worksheet B doesn't sort with the other fileds.

How can I make them stay together?

Linked Cells and Sort Issues
 

Thanks for the assistance. Unfortunately Im not proficient at writing macros
but Ill do some research and give it a try.

"DownThePaint" wrote:

Hi Geraldine;
If you can put the manual inputs into Sheet A and then it will work. If you
cannot do that then you'll have to write a macro that will retrieve the data
from Sheet A and put it into Sheet B plus the sorting.

I hope it helps,


"Geraldine" wrote:

Hi All.

I've created a workbook where a group of cells from one worksheet (worksheet
B) are populated by way of a link to another worksheet (worksheet A).
Worksheet B also has manual input in the column next to the columns that are
linked from worksheet A. When worksheet A gets sorted the manual input in
worksheet B doesn't sort with the other fileds.

How can I make them stay together?