jmaocubo
04-06-2010, 09:13 AM
Hello everyone
I have a table that has a listing that will have invalid references (deliberate).
It is possible to get this table and copy to another, but only the valid.
The size of the table is random....
Source table:
5 |#REF!
2 |1
2 |#REF!
5 |#REF!
5 |30
5 |40
7 |#REF!
… |…
Destination table:
2 |1
5 |30
5 | 40
… …
Imagining that the source table starts in A1 and the target table in N53
I thank you
Regards,
Miguel
I have a table that has a listing that will have invalid references (deliberate).
It is possible to get this table and copy to another, but only the valid.
The size of the table is random....
Source table:
5 |#REF!
2 |1
2 |#REF!
5 |#REF!
5 |30
5 |40
7 |#REF!
… |…
Destination table:
2 |1
5 |30
5 | 40
… …
Imagining that the source table starts in A1 and the target table in N53
I thank you
Regards,
Miguel