M
MikeM
Hi,
I am trying to automate a few tasks at work and would like to get
Excel to do a few different things. I am new to excel programming, so
if someone could just give me a shove in the right direction I'd
appreciate it.
When we open a workbook I would like to always have it open to a "Main
Menu" area. Then I would like to be able to choose "P" for payroll
and the correct sheet would open.
I also would like to be able to automate inserting a blank payroll
sheet into the active sheet. So I think it would go like this...
I would finish with this weeks data entry area on an employees sheet
in the payroll workbook, and I would like to insert a blank data area
for next weeks payroll... So is it possible for me to start a macro
that would insert 20? blank lines beginning at A23 (for instance -
moving all other data areas from previous weeks down), go to another
sheet in the workbook copy a blank payroll entry area go back to the
sheet I just left and paste the new data area into the sheet starting
at A23. I would like to be able to invoke this macro from any one of
6 sheets and have it insert a new data area into whatever sheet I have
active at the time.
Is that possible and can someone point me to some coding to get me
started? I can pretty much get what I want by recording a macro in
excel ... but then it only goes to the sheet I use to record the macro
from ... it doesn't work on another employees sheet.
Thank in advance,
Mike
I am trying to automate a few tasks at work and would like to get
Excel to do a few different things. I am new to excel programming, so
if someone could just give me a shove in the right direction I'd
appreciate it.
When we open a workbook I would like to always have it open to a "Main
Menu" area. Then I would like to be able to choose "P" for payroll
and the correct sheet would open.
I also would like to be able to automate inserting a blank payroll
sheet into the active sheet. So I think it would go like this...
I would finish with this weeks data entry area on an employees sheet
in the payroll workbook, and I would like to insert a blank data area
for next weeks payroll... So is it possible for me to start a macro
that would insert 20? blank lines beginning at A23 (for instance -
moving all other data areas from previous weeks down), go to another
sheet in the workbook copy a blank payroll entry area go back to the
sheet I just left and paste the new data area into the sheet starting
at A23. I would like to be able to invoke this macro from any one of
6 sheets and have it insert a new data area into whatever sheet I have
active at the time.
Is that possible and can someone point me to some coding to get me
started? I can pretty much get what I want by recording a macro in
excel ... but then it only goes to the sheet I use to record the macro
from ... it doesn't work on another employees sheet.
Thank in advance,
Mike