|I'm glad you know what your talking about, because I don't.|
You'll have to be a bit more specific.
What does your sheet look like, what cells are you using?
values of 100,200,300,400, etc. to be inserted in cell A1 and based on the selection, I need a corresponding number to be automatically placed in cell B2.
So if 100 goes in A1, you want 100 in B2?
Cell B1 is the Moment
Do you mean it's a time cell, like =NOW()?
How does that fit into the whole scheme of things?