G
Guest
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?
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?