Add the “Loop” command to continue your API until no more cells with data are found. Insert the command to start at the next column when the query reaches the end of cells with entered data. Define the selection either by number of cells to be included in the API or by the range name. Add the code to include all cells in the data sheet that have entries. Add the first point of the range you wish to combine in a single column and click “Select” to start the query. Open the “Developer” tab on the Access Tool Bar and click on “Visual Basic” or press "Alt-F11." Go to the “Insert” command and open the sub-routine page.Įnter the Sub and Combine commands to establish what you want for your end result. In the dialog box that appears, give a name to the selected range.
Navigate to the “Name a Range” selection toward the bottom of the menu and click on it.
Use your cursor to highlight the data table and right-click on the highlighted table. Select and name the multiple column data table you want to convert to a single column.
0 kommentar(er)
