I'm trying to transpose information (names) from one worksheet to another
within the same workbook. I can do it on the same worksheet by using the =
sign then clicking on the box that i want to transpose. However when I
attempt to do this in another worksheet I get an error that says #value. Any
suggestions