Cell Linking

Mindfull

I have a database and a sheet linked to it which is fetching few of the database columns.

Whenever I sort data in the database the data in the other sheet (linked sheet) is not getting sorted.

Any suggest how i can keep the data in the linked sheet intact?

Paul Newcome

Ok. And how exactly is the data in [Primary Column]@row being populated?

Paul Newcome

Are you currently using cell links or formulas?

Mindfull

@Paul I am using Cell linking.

Paul Newcome

Do you have a column on both sheets that contains unique data per row?

Mindfull

I have a column which has auto generated Number/ID. is that you are asking about?

Paul Newcome

Yes. That can work. You would need to make sure that this column matches on both sheets, and then you can use formulas with cross sheet references to pull the data.

=INDEX({Column to pull from other sheet}, MATCH([Auto-Number Column]@row, {Other Sheet Auto-Number Column}, 0))

Mindfull

I am not pulling all the columns from the source datasheet, hence will this work for it?

Paul Newcome

Yes. You would only need to specify which columns you wanted to pull. You would have a series of formulas similar to above. One for each column you want.

=INDEX({1st column you want to pull from other sheet}, MATCH([Auto-Number Column]@row, {Other Sheet Auto-Number Column}, 0))

=INDEX({2nd column you want to pull from other sheet}, MATCH([Auto-Number Column]@row, {Other Sheet Auto-Number Column}, 0))

=INDEX({3rd column you want to pull from other sheet}, MATCH([Auto-Number Column]@row, {Other Sheet Auto-Number Column}, 0))

So on and so forth only selecting whichever columns you want.

Mindfull

Paul I tried it but it is throwing #NOMATCH error I am using the following

=INDEX({Word Order #}, MATCH([Primary Column]@row, {Document Name AC Power}, 0))

Mindfull

Paul also NOE that I am linking the Primary column to the Work Order # first and then using it in formula.

Paul Newcome

What is in this range? {Document Name AC Power}

Mindfull

It is the name of the column/range as  {Other Sheet Auto-Number Column},

Mindfull

My mistake Paul, it should have been the following way.

=INDEX({Document Name AC Power}, MATCH([Primary Column]@row, {Word Order #}, 0))

Paul Newcome

Ok. And how exactly is the data in [Primary Column]@row being populated?