What you are doing may have worked -- or may have appeared to have
worked -- in the past but it is bad design.

By overwriting information in a cell and keeping only a YTD figure,
there is no audit trail. If there was an error in the past there is no
knowing if it was corrected and if a correction was attempted if it was
done correctly.

While I am not an expert on the subject, my guess would be that if you
work for a company subject to Sarbanes-Oxley and your work is part of
the financial reporting chain or part of the internal management
controls system, the CEO cannot possibly certify the company as "in
compliance."

Obviously, you are welcome to continue doing what you are doing but you
may want to talk with your boss / accounting / audit group to figure
out how to retain an audit trail of sales information. Basically, you
need to timestamp every change and *never* allow an 'undo' of a
transaction once it is committed to persistent storage.

FWIW, with a proper system, the YTD can be computed quite easily.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

I need help doing this. I work for a music company and i have to enter
in sales once a week. I'll try to explain it the best way i can. And
will attach a picture to help.

When you get the picture opened; every week i type in numbers under
"TW"=This Week sales when i do that i have to get a calculator and add
the numbers i just typed in for TW into the YTD and LTD. That is what
takes be forever.

So is there anyway whatever gets typed in the TW auto calculates into
YTD and LTD? Thanks alot!

http://img340.imageshack.us/img340/5254/untitled5vk.jpg


--
TroyM
------------------------------------------------------------------------
TroyM's Profile: http://www.excelforum.com/member.php...o&userid=29939
View this thread: http://www.excelforum.com/showthread...hreadid=496409