I am trying to figure out (starting slowly here) how to use the VBA in excel. It seems that
we do a lot of the same thing everyday using a excel workbook to make reports, etc.
Here are my questions / goals:
I can plot a command button in excel using the toolbox...but how do I name the button?
Can a command be done to create a new workbook based off of a range given from the
current workbook? I only want to copy and paste a certain range...and the values of
each test block...no formulas. Can I use a template so report will not have to be formatted
my way every time? Concurrently, can this new workbook have a specific name given to
it and saved in a particular place on my C: drive?
These questions will get me started...I just think that we can save a lot of time with some automation.
Thank you all!!!