Junior Member

Posts: 1

Auto populate from list on separate sheet

I work in a hotel and I'm working on a system to improve the fluidity between the front desk and housekeeping departments.

On one sheet I have a list of every room number and then the room type in the adjacent column. ie A1: 800, B1: NPK.

What I need now is when I'm on a separate sheet and I put in 800 in the Room column that it will auto populate "NPK" into the adjacent type column.

I've tried a few things already but nothing's worked yet. Any help would be appreciated.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Populate excel sheet based on values in a separate sheet	Andi	Excel Discussion (Misc queries)	3	September 17th 09 02:53 PM
auto populate a list	khuff	Excel Discussion (Misc queries)	1	July 1st 09 07:23 PM
Need to auto-populate a list.	Labkhand	Excel Discussion (Misc queries)	16	October 29th 08 12:35 PM
Auto populate from list/source	James	Excel Worksheet Functions	8	August 17th 07 02:56 PM
Auto populate from list/source	Ron Coderre	Excel Worksheet Functions	0	August 17th 07 01:48 AM

All times are GMT +1. The time now is 12:02 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us