vb auto data sort when entry 2 cell

Hi

If you have a fixed number of machines, the could you make the summary sheet in a matrix format with the week days across the top (Mon...Sun), and the machine names down column A.

That way you could use Vlookup to bring back the amount for each machine for each day and have them all together. If a machine doesn't pay out for a day, then the result would be 0.

rylo

hi,

thanks for getting back to me, i have posted this in 2 forums. Im sorry if have offended you or any one on in the other fourm by posting in both. kinda new to whole computer thing, is post in 2 fourms like cheating on the misses? Was not aware of this, sorry

http://www.excelforum.com//showthread.php?t=634301
http://www.mrexcel.com/forum/showthread.php?t=304982

thanks
norman

In attached file I inserted two macro that can help you.

I hope it's what you need.

Regards,
Antonio