Hey all,
I am extremely new to Excel and have been "tinkering" with it for around
2 weeks now, and have come to the conclussion that i need to start learning
macros. I have recently been given a task of making a worksheet that gathers
data from multiple sheets and places that info into a single sheet once an
hour. Although the process I used was more than likely the least efficient it
still works fine. The data is recorded for each hour and via formulas
populates a "Reports" sheet. I need to learn how to make a macro that will
copy a selection on the "Reports" sheet, paste it into a new e-mail and sent
it from clicking on a single button. I figured out how to make a button from
reading the posts in this forum, but am at a loss as to how to make a macro
that will change sheets, select a range of cells,copy it, then open Outlook,
make a new email, paste it, send it, and then return to the original sheet,
but to cells below the ones previously filled in. Any and all assistance
would be greatly appreciated, as I am eager to see this sheet finally
finished.