Spreadsheet: 865699d1712723659-does-sorting-a-range-with-the-left-most-column-hidden-also-sort-the-left-column-sort-with-hidden-columns
Sheet: Read Me

 | Filler: Append and delete records to one table in sheet Region 2 |  |  |  |  |  |  |  | Move to misc Excel |  | Name |  | Product
 | Every sheet: | Need note w formula |  | V all cell note formulas |  |  |  |  |  |  | [NAME] |  | A
 | V works for Macs |  |  |  |  |  |  |  |  |  | Al |  | B | [NAME]
 | Use tables, not ramed ranges--adjusting size for new and deletes is imp! |  |  |  |  |  |  |  |  |  | Alicia |  | C | [NAME]
 | Vstack doessn ot work in classroom 219 FOR Macs |  |  |  |  |  |  |  |  |  | [NAME] |  | D | [NAME] |  | If paper [NAME]
 | Vstack does not work in class 219 podium PC (excel 2021) |  |  |  |  |  |  |  |  |  | [NAME] |  | E | Opel |  |  | Find Available Skilled Employees
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  | F | [NAME] |  |  | Is cell in a range
 | https://support.microsoft.com/en-us/office/vstack-function-a4b86897-be0f-48fc-adca-fcc10d795a9c |  |  |  |  |  |  |  |  |  | [NAME] |  | G | [NAME] |  |  | Employee Client Skills
 | I can't assume each named range or column has same number of rows |  |  |  |  |  |  |  |  |  | [NAME] |  | H | [NAME] |  | Colon fails | Data Val allowable inputs = spill range of filter
 | VStack(Tables…) works only with commas separating each table |  |  |  |  |  |  |  |  |  | [NAME] |  | I | Wiletta
 |  |  |  |  |  |  |  |  |  |  | Anne |  | J | [NAME]
 |  |  |  |  |  |  |  |  |  |  | April |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | Helen
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | [NAME]
 | =VSTACK(INDIRECT(A16):INDIRECT(A17)) |  |  |  |  |  |  |  |  |  | [NAME] |  |  | Jessica
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | Rose
 | =VSTACK(Names_A:Names_D) |  |  |  |  | Colon fails |  |  |  |  | [NAME] |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | Crawford
 | I think colon is only for sheet1:Sheet 5 |  |  |  |  |  |  |  |  |  | Bethany |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | [NAME]
HQ sheet: | Works when I append records to table! |  |  |  |  |  |  |  |  |  | [NAME] |  |  | [NAME]
 | Works when I delete records from table! |  |  |  |  |  |  |  |  |  | [NAME] |  |  | Mathew
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | Lindsey
 |  |  |  |  |  |  |  |  |  |  | Brittany |  |  | [NAME]
 | See sheets @021, 2022, 2024=3, 2024 |  |  |  |  |  |  |  |  |  | Brook |  |  | [NAME]
 | A better example would be varoius regions or products all in current year |  |  |  |  |  |  |  |  |  | [NAME] |  |  | Jones
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Catie
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | CoCo
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Crawford
 |  |  |  |  |  |  |  |  |  |  | Dar
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Deb
 |  |  |  |  |  |  |  |  |  |  | Debbie
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Drake
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Edwardo
 |  |  |  |  |  |  |  |  |  |  | Ellen
 |  |  |  |  |  |  |  |  |  |  | Emily
 |  |  |  |  |  |  |  |  |  |  | Emma
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Farmer
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Geoff
 |  |  |  |  |  |  |  |  |  |  | George
 |  |  |  |  |  |  |  |  |  |  | Gil
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Hal
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Hans
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Helen
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Huber
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Ira
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Jessica
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Jones
 |  |  |  |  |  |  |  |  |  |  | Jordon
 |  |  |  |  |  |  |  |  |  |  | June
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Kathy
 |  |  |  |  |  |  |  |  |  |  | Kelly
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Kerri
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Lauren
 |  |  |  |  |  |  |  |  |  |  | Law
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Leta
 |  |  |  |  |  |  |  |  |  |  | Levit
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Lindsey
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Lunenburg
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Mandy
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Mark
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Mason
 |  |  |  |  |  |  |  |  |  |  | Mathew
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Meredith
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Morgan
 |  |  |  |  |  |  |  |  |  |  | Morris
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Nick
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Opel
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Paige
 |  |  |  |  |  |  |  |  |  |  | Parker
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Porsche
 |  |  |  |  |  |  |  |  |  |  | Rita
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Roberta
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Rose
 |  |  |  |  |  |  |  |  |  |  | Royal
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Sara
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Sue
 |  |  |  |  |  |  |  |  |  |  | Suzy
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Tiffany
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Ursula
 |  |  |  |  |  |  |  |  |  |  | Vic
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Wiletta
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Woods
 |  |  |  |  |  |  |  |  |  |  | Yizhen
 |  |  |  |  |  |  |  |  |  |  | Zach