Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question on VBA Insertion of Additional Sheet
Hi, Everyone -
I'm continuing to work on our agency Payroll Sheet.... seems like a "never-ending battle".... ;) I have a quick couple of questions that I was hoping to obtain some imput on: Within my Payroll Sheet, I have what is called a Data Entry Sheet where the employee manually enters their hours (both paid and Leave), and the numbers are fed over to the actual Payroll Sheet where everything is more or less calculated out and summarized. We now have an employee that will need a SEPERATE Data Entry Sheet for each project he works on, so that he will have one actual Payroll Sheet but 15 seperate Data Entry Sheets. What I would like to do is to set up a VBA button that, when pressed, XL will copy the original blank Data Entry Sheet (along with all formatting and security settings) and insert the copies sheet as a new sheet. Can someone help me out with the code strips to make this possible? Thanks. Frank |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question on VBA Insertion of Additional Sheet
Hi Frank,
I don't know if I can be helpful here, but I had a question: You wrote: I have what is called a Data Entry Sheet where the employee manually enters their hours (both paid and Leave), and the numbers are fed over to the actual Payroll Sheet How are the numbers fed over to the actual payroll sheet? If you copy the Data Entry Sheet 15 times, how will the payroll sheet now about them and add them up? Dan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question on VBA Insertion of Additional Sheet
On Apr 28, 4:13*pm, dan dungan wrote:
Hi Frank, I don't know if I can be helpful here, but I had a question: You wrote: I have what is called a Data Entry Sheet where the employee manually enters their hours (both paid and Leave), and the numbers are fed over to the actual Payroll Sheet How are the numbers fed over to the actual payroll sheet? If you copy the Data Entry Sheet 15 times, how will the payroll sheet now about them and add them up? Dan Hi, Dan - Thanks for the quick response. I'd be the VERY FIRST to admit I'm a novice at programming, so this may seem extremely rudamentary. The tool that I have created as "Test" works like this: I manually created 5 new sheets by Cntrl+C the original Data Entry Sheet so that now I have (1) the summary Payroll Sheet itself where it takes the daily- entered hours off the original Data Entry Sheet; (2) the original Data Entry Sheet; and (3) the 5 new Data Entry Sheets. The way it KIND OF works is that the employee would enter hours on the individual Data Entry Sheet, for each seperate project which would then feed over into the original Data Entry Sheet and the hours would get "summed" up for each day. Then those hours would feed over into the Payroll Sheet itself. I can email you a copy if you'd like.......... Does this explain it a little better? Thanks again. Frank |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question on VBA Insertion of Additional Sheet
Hi Frank,
Well, it seems that you can manually add the sheets you need, but you want a macro to do it, right? I would start with recording the macro while you manually insert the new sheets. Then let's see what code you get. Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
additional question on camera ... | Excel Discussion (Misc queries) | |||
Can I allow insertion of pictures into a protected excel sheet? | Excel Discussion (Misc queries) | |||
picking correct number with < additional question | Excel Discussion (Misc queries) | |||
Master Sheet Row Insertion | Excel Discussion (Misc queries) | |||
Selection change: additional question | Excel Programming |