How do I either:
(a) retrieve the numbers after each # in a sheet (i.e. if it's #143 ==> 143) and put them on a separate sheet, OR
(b) hide all information on a worksheet except for the numbers after each #.
In essence, I would like to create an array of each of these numbers so that I can use that array to identify those numbers as rows on a separate worksheet.
(a) retrieve the numbers after each # in a sheet (i.e. if it's #143 ==> 143) and put them on a separate sheet, OR
(b) hide all information on a worksheet except for the numbers after each #.
In essence, I would like to create an array of each of these numbers so that I can use that array to identify those numbers as rows on a separate worksheet.