Macro to input data on specific cell based on range of another cell data

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!

Thanks for the help! Attached is the file requested. It states a price table to show where I get my 100 and 275 and so forth from. THANKS!

sample.xlsx

Originally Posted by 6StringJazzer

Welcome to the Forum!

The explanation is a bit confusing. If you input 15, it makes sense that you would want something to go into the column 1-20, since 15 is in the range 1-20. But why do you put 100 in that column? Where do all those other numbers come from (275, 375, 475)?

I suggest attaching a sample file showing your data layout with examples of what you want the results to look like and an explanation of how to get those results.

To post a file:

1. Under the text box where you type your reply click the Go Advanced button.
2. In the next screen look above the reply box and click the "paper clip" icon. You will get a pop-up screen.
3. In the pop-up, click Add then Select to select a file from your local drive
4. Click the Upload button to upload the file
5. Click Done to attach it.

It will be displayed as an attachment underneath your post text. Alternatively as the last step you can click the Insert Inline button and a hyperlink to the file will be inserted directly into your post text in the spot where your cursor is set at the moment you click the button.

Hello, please see attached file on my last post