Help needed for Autofilling accross and then sorting the entries.
I have tried this code to autofill cells to the right of the last column that has an entry in row2
Whenever a new name and information is entered into our matrix, will copy and paste the name in row 2 of the last column entered, however the formula in rows 1, 3 4 and 5 need to be autofilled to the right. Information on the named person can possibly extend 1000 catagories under them (rows)
This is a "growing" workbook, where additional information will be in rows and Columns
Most important, I would like to try to Sort ACCROSS these columns - to alphabetically sort the names - (1000 rows down must follow the names). When I do this, then empty cells always show up before the alphabetical sort does, because I sorted out to column AMA, but I never know which the last column is, so I would also have to use the "last column- code" for the sort.
my code is below
and I have attached a small slice of the matrix
Thank you.
Bookmarks