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!