I have a document which imports a data table from another workbook which is
live. so when i run a macro it imports the live update. in my doc i then have
a status table that uses VLOOKUP's to place the live info into the status
table.

In addition to this there are two additional columns with update comments
and date of update comments.

So what i require is when i add update comments it assosiates itself with
that record. so that when i run the live import macro the update comments
will move in accordance to the new position of the rcord.

How would i get it to do this I HAVE NO IDEA???????

HELP?????

Right now your setup is having input come from both directions (source and
final destination). You need to set something up where you have 2 sources,
and 1 final destination.

Assuming your records have some field with a unique identifier, you could
set up your macro to copy (if you go with the following function, make sure
you copy/paste values only) the comments and their associated identifier to a
blank sheet before you bring in the new data.

Then, have another VLOOKUP function pull in any comments from the newly
created sheet into your main data sheet.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Gazz_85" wrote:

I have a document which imports a data table from another workbook which is
live. so when i run a macro it imports the live update. in my doc i then have
a status table that uses VLOOKUP's to place the live info into the status
table.

In addition to this there are two additional columns with update comments
and date of update comments.

So what i require is when i add update comments it assosiates itself with
that record. so that when i run the live import macro the update comments
will move in accordance to the new position of the rcord.

How would i get it to do this I HAVE NO IDEA???????

HELP?????