Profile
Achievement
cueballrawn's Recent SnippetsTagged list
- All /
« Prev 1 Next »
Selecting different values from a data validation drop down list will populate the same cell, i.e. it will create a concatenating list separated by commas.
Amend the "If Target.Column" values to set the columns this applies to.
0
902
posted 7 years ago by cueballrawn
This inserts a new column in the active worksheet and lists all the worksheet names, using a row for each name. Useful if you have lots of worksheets names that you want to reference accurately.
0
954
posted 7 years ago by cueballrawn