I have a worksheet and it contains one row of information that I want to
autofill down and subtract numbers like below:



A B

Row1 Widget 500



Now I want to make a macro/code that will fill down until the number in row
B equals 1. Row B can change, in the example it is 500, but it could be
272, 25, 1000 etc...



So after running the macro the spreadsheet would look like below:



A B

Row1 Widget 500

Row2 Widget 499

Row3 Widget 498



I know there is an autofill method, but I just want the user to put in the
information in the first row, execute the macro/code and let Excel do the
work. This information will then be pulled into a Mail Merge Document and
labels will be printed, in the above example, there will be 500 lables,
Widget 1 through Widget 500. Any assistance in coding the Excel part would
be greatly appreciated.