Hey All,

In column E I have a list of numbers. I want to round all of them to the nearest number in the following list:

400
600
800
1000
1200
1400
1600
1800

The closest I can find is this example, but I really am stumbling on where to start with it:
http://excel.bigresource.com/Track/excel-bQaNOgRp/

I dont need an error dialog box either for simplicity.

If there's a way to do this with a regular macro set of actions great, but if not if you could help me do it via VBA i can work that too.

I will most definately give good ratings to ANYONE that may be able to help me.

Thanks!

- Brandon