importing data (vlookup) whitout a link to the original data

[barri1981]

Hi,

I am looking to a way to import data from a list
[TABLE="width: 459"]
<colgroup><col span="3"><col><col span="3"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]cola[/TD]
[TD]fanta[/TD]
[TD]sprite[/TD]
[/TR]
[TR]
[TD]320[/TD]
[TD]JAN[/TD]
[TD]CAR[/TD]
[TD]STANDARD[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]EXTRA[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]12-Jan[/TD]
[TD]13-Jan[/TD]
[TD]RETOUR[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]USED[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]321[/TD]
[TD]PIET[/TD]
[TD]TRUC[/TD]
[TD]STANDARD[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]EXTRA[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]12-Jan[/TD]
[TD]14-Jan[/TD]
[TD]RETOUR[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]USED[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]322[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]STANDARD[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]EXTRA[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]RETOUR[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]USED[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
I would like to import the range to the right of by example 320 in another file (wrkbk2), that works with vlookup and some creativity.
But at the end of the month in the source file, all lines who are "done" are deleted.
At that point i lose the values in wrkbk2, how do work around that.

 

[barri1981]

[TABLE="width: 459"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]cola[/TD]
[TD]fanta[/TD]
[TD]sprite[/TD]
[/TR]
[TR]
[TD]320[/TD]
[TD]JAN[/TD]
[TD]CAR[/TD]
[TD]STANDARD[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1/12
[/TD]
[TD]02/12
[/TD]
[TD]

EXTRA​

<strike></strike>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]USED
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]321[/TD]
[TD]PIET
[/TD]
[TD]TRUC
[/TD]
[TD]STANDARD
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]03/12[/TD]
[TD]14/12[/TD]
[TD]EXTRA[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]USED
[/TD]
[/TR]
[TR]
[TD]322[/TD]
[TD]PAUL[/TD]
[TD]PLANE[/TD]
[TD]STANDARD
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]04/12
[/TD]
[TD]05/12
[/TD]
[TD]EXTRA
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]USED[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
This table should be better