I need some help on creating a macro in excel. I followed on how to record
but I think I am missing a step in the begining. This is what I am trying to
do.
I exported some information from Access into Excel. I then copy the
information and paste it in what I call MASTER-I have headers and footers in
this spreadsheet.
I then I to format the spreedsheet before I can submit it. That is what I
what the macro to do. I want it to change column B to have the date in
mm/dd/yyyy the font to be 12 and then I need to insert a row between each
line of information. I then need to border the information in each row. Can
someone please assist me with this? Oh one more thing each row needs to be
15.75 high.
Thanks

Click on Tools Macro RecordNewMacro then fill in a macro name with
something meaningful, like FormatMyData,.....then proceed to perform all hte
operations you want to do by hand, and when finished, do Tools Macro
StopRecording, and you are done..........save the workbook. Then, the next
time you want to do those things just do Tools Macro Macros then select
the name you assigned to it and click RUN.........

If if doesn't work out, post back and someone will help you edit it, or
write one for you.....

hth
Vaya con Dios,
Chuck, CABGx3



"Chey" wrote:

I need some help on creating a macro in excel. I followed on how to record
but I think I am missing a step in the begining. This is what I am trying to
do.
I exported some information from Access into Excel. I then copy the
information and paste it in what I call MASTER-I have headers and footers in
this spreadsheet.
I then I to format the spreedsheet before I can submit it. That is what I
what the macro to do. I want it to change column B to have the date in
mm/dd/yyyy the font to be 12 and then I need to insert a row between each
line of information. I then need to border the information in each row. Can
someone please assist me with this? Oh one more thing each row needs to be
15.75 high.
Thanks