Linked Cells and Sort Issues

  • Thread starter Thread starter Geraldine
  • Start date Start date
G

Geraldine

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?
 
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,
 
Thanks for the assistance. Unfortunately I’m not proficient at writing macros
but I’ll do some research and give it a try.
 
Back
Top