Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filling down a selection
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically filling a cell from a worksheet based on a selection | Excel Worksheet Functions | |||
Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
filling information from one cell and filling another. | Excel Worksheet Functions | |||
Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue. | Excel Programming | |||
Filling multiple cells based on 1 combo box selection | Excel Programming |