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

See David McRitchie's "getting started with VBA and macros" site.

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Don't forget the Macro Recorder which most times gives you an idea of what has
to be done.

Tweaking of the recorded code is necessary in some cases.

Tushar Mehta has a tutorial on tweaking recorder-generated code.

http://www.tushar-mehta.com/excel/vb...rder/index.htm


Gord Dibben MS Excel MVP

On Mon, 25 Jun 2007 17:10:27 -0400, "Linda RQ"
wrote:

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

Thanks...This looks very nice.

Linda

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
See David McRitchie's "getting started with VBA and macros" site.

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Don't forget the Macro Recorder which most times gives you an idea of what
has
to be done.

Tweaking of the recorded code is necessary in some cases.

Tushar Mehta has a tutorial on tweaking recorder-generated code.

http://www.tushar-mehta.com/excel/vb...rder/index.htm


Gord Dibben MS Excel MVP

On Mon, 25 Jun 2007 17:10:27 -0400, "Linda RQ"
wrote:

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