One thing you can do:

Use, say, Sheet1 for importing from Excel. Write your comments on the
right column.

Next time you import use Sheet2. Next to the data in Sheet2 enter the
formula (say in D2):

=INDEX(Sheet1:$D$2:$D$1000,MATCH(1,($A$2:$A$1000=A 2)*($B$2:$B$1000=B2)*($C$2:$C$1000=C2),0))

It is an array formula, thus use Shift+Ctrl+Enter to enter it. Copy it
along the column to import the comments.

Select all of Sheet2 data (Ctrl+* is an easy way). Copy and Paste
Special to Sheet1 using only Values.

Does this help?
Kostis Vezerides


DTTODGG wrote:
Hello -
I'm not even certain how to ask the question.
Everyday I export a file from Access into an .xls.
This .xls file looks the same as the Access file except:
1) I've inserted a new column "A" which concatenates 2 columns
2) I have added a column with some conditional statements

I would like to add a "note" column to this spreadsheet, but, everytime I
re-import the data from access, it does not keep the rows attached to the
"notes" column.

BEFO
NameA NameB Age Notes (not from Access, keyed in Excel)
ANDY SMITH 25 "Doesn't like tomatoes"
MATT JONES 32 "Likes Grapes"

AFTER:
MICKEY MOUSE 18 "Doesn't like tomatoes"
ANDY SMITH 25 "Likes Grapes"
MATT JONES 32

I want the "Doesn't like tomatoes" to follow ANDY, regardless of what row he
ends up on because of calculations made when importing. Matt should still say
"Likes Grapes" and Mickey should be empty because I just imported it and have
not added notes yet.

Thanks a whole bunch!