G
Guest
How can I set up a sheet where I would input a list of names and numbers
sorted numerically, and have that data automatically placed in alphabetical
order on another sheet.
The application is a simple key locker i.e.
Sheet 1
num desc
001 front door
002 back door
003 firehouse
004 apple house
sheet 2 would automatically display as
desc num
apple house 004
back door 002
firehouse 003
front door 001
the printed output is most important so I could just sort before printing.
But if the automation is possible it would be very interesting to see how
that could work.
Any ideas?
sorted numerically, and have that data automatically placed in alphabetical
order on another sheet.
The application is a simple key locker i.e.
Sheet 1
num desc
001 front door
002 back door
003 firehouse
004 apple house
sheet 2 would automatically display as
desc num
apple house 004
back door 002
firehouse 003
front door 001
the printed output is most important so I could just sort before printing.
But if the automation is possible it would be very interesting to see how
that could work.
Any ideas?