Windows 7 - Advance Macro help

Asked By William G on 13-Aug-12 10:07 AM
Hi All!

I have spreadsheet that will be used for employees to track their service w=
ork.=20
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 t=
ab as a summary and then I can use that tab for reporting.=20

My Macro will have a Macro Button for the employee to press to save the ent=
ered 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 'ente=
r' 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 sampl=
e of the layout information:=20

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 knowled=
ge 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




Don Guillett replied to William G on 13-Aug-12 02:19 PM
work.=20
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.=20
ntered work and file (I can set that up), but the macro will paste the valu=
es on the 'Summary' tab but then re-enter the formula that links to the 'en=
ter' tab on the following line for the next employee to enter. So, the Macr=
o will need to know the last cell of the spreadsheet that continues to chan=
ge as more information continues to be entered by employees. Below is a sam=
ple of the layout information:=20
edge of Access (even using the Microsoft Templates is a bit overwhelming). =
I am open to suggestions on this project.

Send your file with this msg and a complete explanation with exmaples to dg=
uillett1 @gmail.com