Hi All
I'm wondering if this is possible and if so I would greatly appreciate help with it.
I'm working between 2 sheets and I will use a Hotel as an example.
Sheet 1 has 2 columns, Floor# and Name.
Sheet 2 has 21 columns. The first column is the Floor#, the next 20 columns are names of...