I need help calculating this.

[TroyM]

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

[William DeLeo]

If you explain what exactly you are hand calculating (i.e. what numbers go into LW, 2W, 3W and YTD), then I'll be able to help.

[Tushar Mehta]

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 <[email protected]>,
[email protected] 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
>
>

[TroyM]

If you explain what exactly you are hand calculating (i.e. what numbers go into LW, 2W, 3W and YTD), then I'll be able to help.

Ok i was sent this file to take over. at the end of each column (LW, 2W, 3W, etc.) are all the totals (which adds up correctly) When i type in the TW, the following week 2W will have that number and TW will have a new one. Everything adds up correctly, i just need to find a way to make the TW numbers i type in auto-add in the LTD and YTD.

[William DeLeo]

1. I still don't feel I have enough info to help in any real way. I sent you a private message with my email so if you'd like my help send me the file.

2. Although I didn't want to say it, at first glance I'd have to agree with TM ... bad initial design.