Hi Everyone,

I generally use excel to make nice forms and basic sorting, and basic
calculations. I just exported some data from a data mining program into an
excel spreadsheet. I then used this spreadsheet as a linked table for an
access database in an update query. I use a patient number field to link my
data. I had trouble with this column and the only thing that worked to make
the data compatable with my access data was to create a new column and I
used this expression =TEXT(B2, "0"). I then had to use
this column to link my data. I also have to delete the first column and
rename the sheet, do an advanced filter to remove my duplicate records. Is
a macro what I need to learn to do? I have used a macro before but it was
given to me by someone else and he lead me step by step on where to paste it
and how to assign a key combo to use after I typed a fraction. It made any
number
into a fraction with superscript/subscript.

I am a self taught computer person, I went to school for Respiratory Therapy
and have
no programming classes, I just basically know that Visual Basic exists and
can sometimes
understand what it's doing.

So...where and how do I get started? I have a feeling this will be
something that will
be needed more and more by me. Right now, I do this weekly on 3 reports.

Thanks,
Linda