Autoupdate sheet/ workbook, yet keep content

G

greenfalcon

Hi, i have a quick question, i am building a timesheet in excel for m
company. By testing it out, and sending it to all the employees we ar
always finding new things to add, or formatting issues to fix. I wa
wondering if it was possible to add functionality by instead of sendin
out an email every time that i make a change to the master version an
for my fellow co-workers to have to re-enter in all there data, i
their a way for excel, or a plug-in that allows it to check anothe
version, if it is different, then update itself, yet keep the pas
imputed information.

I could even have it only update one sheet that always remains blank
so that the changes will only become effective on their new payperiod.

Are there any ideas or is this not possible.

Thanks

Jaso
 
J

jeff

Hi, Jason,

Yes you could pretty much do what you're asking, but
I think it really depends on how much time you have to
program the VBA code to do that. A while back, I created
a timesheet system with auto-lookups for project codes
and departments, and a system for the employees to email
to a secretary where some macros I wrote in Outlook
grabbed them, massaged the data, and created a report that
was sent to finance/payroll.
Nice and cheap, but I wound up spending a lot (too much!)
time in your shoes, modifying and correcting the users'
data because we had become "too automated" in a sense
for our users.

I simply recommend saving all changes until a set day,
say Friday pm or Monday first thing, to put jout a new
version.

Have your people know where to pick up the master version
each week and use that - don't accept old versions.

Talking from experience....good luck
jeff
 
Top