I have a 2900 line spreadsheet from top to bottom with information about
rooms and organized by it's room number:
example:
col a: b : c : d:
101: Main Lobby: Lobby is 590 Sq ft
102: Janitors Closet: 15 sq ft
103: Elevator room: 15 sq ft
103: Elevatior room 2: 24 sq ft

I want to be able to have one source page where I can type the room number
in and then allow it to show and then print the room number. No data filters
that's ok but not what I'm looking for. Some rooms have like 20-25 lines of
information while some only has 3-4. Macro is ok but how?
--
Jeff