1) The macros only work on the specific row of the spreadsheet that I use
when recording the macro.

2) Once I figure out (with your assistance) how to generalize the
reformatting macros, I'd like to tie them to a button on the spread sheet so
that I can do my cut and paste, highlight the specific new entry, and apply
the macro(s) at the touch of a single button.

Due to the low volumes of data Im dealing with I would prefer to apply this
€œprocess€� on a row by row basis so I can visually catch any straggling data
quality problems that might crop up while the other window with the source
data is still available. I do not want to attempt the €œautomation€� of the
data capture from the IE (browser) window, as the location of the data can be
rather variable and not worth the effort given the continuing evolution of
the web application. Cut and Paste is a very acceptable way to grab the data
I need.

I've "built" my button, so my task is linking it to a macro that I want run
when you click/double click on it. I'm a pretty sophisticated Excel user as
far as using functions and "pretty printing" (fonts, justifications,
backgrounds, building pull down list, et cetera). This is my first attempt
to build some macros to perform some of these functions automatically for me,
so I'm sure this question ranks up there as User Brain Damage.

I think I'm about 85% of the way to where I want to be, but I'm missing some
basic knowledge piece and the Help files that I've found just don't seem to
address these issues.

Anybody have any pointers on what I'm doing wrong or need to do that I'm not
doing in order to complete this little project?

Ancient, See if this will help you with getting started with Macros click on
the link below to visit David McRithchie's site
http://www.mvps.org/dmcritchie/excel/getstarted.htm


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Ancient_IT_ guy" <Ancient_IT_ wrote in
message ...
1) The macros only work on the specific row of the spreadsheet that I use
when recording the macro.

2) Once I figure out (with your assistance) how to generalize the
reformatting macros, I'd like to tie them to a button on the spread sheet
so
that I can do my cut and paste, highlight the specific new entry, and
apply
the macro(s) at the touch of a single button.

Due to the low volumes of data I'm dealing with I would prefer to apply
this
"process" on a row by row basis so I can visually catch any straggling
data
quality problems that might crop up while the other window with the source
data is still available. I do not want to attempt the "automation" of the
data capture from the IE (browser) window, as the location of the data can
be
rather variable and not worth the effort given the continuing evolution of
the web application. Cut and Paste is a very acceptable way to grab the
data
I need.

I've "built" my button, so my task is linking it to a macro that I want
run
when you click/double click on it. I'm a pretty sophisticated Excel user
as
far as using functions and "pretty printing" (fonts, justifications,
backgrounds, building pull down list, et cetera). This is my first
attempt
to build some macros to perform some of these functions automatically for
me,
so I'm sure this question ranks up there as User Brain Damage.

I think I'm about 85% of the way to where I want to be, but I'm missing
some
basic knowledge piece and the Help files that I've found just don't seem
to
address these issues.

Anybody have any pointers on what I'm doing wrong or need to do that I'm
not
doing in order to complete this little project?