Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advance Macro help
Hi All!
I have spreadsheet that will be used for employees to track their service work. I fell that it would be easier for them to key the necessary information on an 'enter' tab and have that information, by formulas, listed on another tab as a summary and then I can use that tab for reporting. My Macro will have a Macro Button for the employee to press to save the entered work and file (I can set that up), but the macro will paste the values on the 'Summary' tab but then re-enter the formula that links to the 'enter' tab on the following line for the next employee to enter. So, the Macro will need to know the last cell of the spreadsheet that continues to change as more information continues to be entered by employees. Below is a sample of the layout information: Enter tab: Date 11/30/2012 Name Code 1588 Equipment Car 1 Milage 141555 Description of work Repair Bumper Summary Tab: Line # Date Name Code Equipment Milage Description of work 1 8/11/2012 1889 Car 1 128,555 Oil Service 2 9/15/2012 1889 Car 1 132,551 Oil Service 3 10/20/2012 1889 Car 1 140,133 Break Service 4 5 6 I feel that Access maybe a better option, but I nor the client have knowledge of Access (even using the Microsoft Templates is a bit overwhelming). I am open to suggestions on this project. Thank you for your time!! William |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advance Macro help
On Monday, August 13, 2012 9:07:16 AM UTC-5, William G wrote:
Hi All! I have spreadsheet that will be used for employees to track their service work. I fell that it would be easier for them to key the necessary information on an 'enter' tab and have that information, by formulas, listed on another tab as a summary and then I can use that tab for reporting. My Macro will have a Macro Button for the employee to press to save the entered work and file (I can set that up), but the macro will paste the values on the 'Summary' tab but then re-enter the formula that links to the 'enter' tab on the following line for the next employee to enter. So, the Macro will need to know the last cell of the spreadsheet that continues to change as more information continues to be entered by employees. Below is a sample of the layout information: Enter tab: Date 11/30/2012 Name Code 1588 Equipment Car 1 Milage 141555 Description of work Repair Bumper Summary Tab: Line # Date Name Code Equipment Milage Description of work 1 8/11/2012 1889 Car 1 128,555 Oil Service 2 9/15/2012 1889 Car 1 132,551 Oil Service 3 10/20/2012 1889 Car 1 140,133 Break Service 4 5 6 I feel that Access maybe a better option, but I nor the client have knowledge of Access (even using the Microsoft Templates is a bit overwhelming). I am open to suggestions on this project. Thank you for your time!! William Send your file with this msg and a complete explanation with exmaples to dguillett1 @gmail.com |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advance Macro help
On Aug 13, 11:19*am, Don Guillett wrote:
On Monday, August 13, 2012 9:07:16 AM UTC-5, William G wrote: Hi All! I have spreadsheet that will be used for employees to track their service work. I fell that it would be easier for them to key the necessary information on an 'enter' tab and have that information, by formulas, listed on another tab as a summary and then I can use that tab for reporting. My Macro will have a Macro Button for the employee to press to save the entered work and file (I can set that up), but the macro will paste the values on the 'Summary' tab but then re-enter the formula that links to the 'enter' tab on the following line for the next employee to enter. So, the Macro will need to know the last cell of the spreadsheet that continues to change as more information continues to be entered by employees. Below is a sample of the layout information: Enter tab: Date * * * * * * * * * * * 11/30/2012 Name Code * * * * *1588 Equipment * * * * *Car 1 Milage * * * * * * * * * * 141555 Description of work * * * *Repair Bumper Summary Tab: Line # * * Date * *Name Code * * * Equipment Milage * * * *Description of work 1 *8/11/2012 * * * 1889 * *Car 1 * *128,555 * * * *Oil Service 2 *9/15/2012 * * * 1889 * *Car 1 * *132,551 * * * *Oil Service 3 *10/20/2012 * * *1889 * *Car 1 * *140,133 * * * *Break Service 4 5 6 I feel that Access maybe a better option, but I nor the client have knowledge of Access (even using the Microsoft Templates is a bit overwhelming).. I am open to suggestions on this project. Thank you for your time!! William Send your file with this msg and a complete explanation with exmaples to dguillett1 @gmail.com- Hide quoted text - - Show quoted text - Thanks Don!!!! Works great!!!! Thank you again for your help - one of these days I'll take a Macro Class :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to run a macro if I don't know the name in advance | Excel Programming | |||
Macro for HEAT chart - THANKS IN ADVANCE! | Excel Worksheet Functions | |||
Deleting rows with Advance Filter in recorded Macro | Excel Programming | |||
Macro to advance current row by 1 | Excel Programming | |||
Macro to advance current row by 1 | Excel Programming |