Hello,

I´m in need of a Macro or several macros I don´t know that does the following. I have a column in which I input some data. Let´s call it pounds. Next to that column I have several more, 1-20, 21-30, 31-50, 50-100, and 100 or more. All these are pounds. Under the first column ¨pounds¨, I will input the number of pounds, and I want the macro to place another number under the corresponding column based on the ¨pounds¨column. For example: If I input 15 pounds, that should input 100 under the 1-20 column. My data table is the following:

1-20 = 100
21-30 = 275
31-50 = 375
51-100 = 475
....

PLEASE HELP!

THANKS!