Microsoft Excel Floor Plan Data Connection

We are creating an Excel booking-type sheet for local events, and would like to connect names with the rooms of a floorpan we are developing. I want to be able to add a name, connect the room number, and for that name (and any others with that room number) to show up in that room. I want them to wrap-text (rather than showing up as a single sentence), and to only allow a certain number of entries per "room". I've attached the file we would like to work with. The first column is the attendee's last name, the second is the first name, as we must sort them by last name. The third column is the full name which is what will be imputed into the room grid, and the fourth column is their corresponding room assignment. What I would like to be able to do is to type the room assignment in the fourth column, then to have the corresponding name in the third cell populate in that specific room. It seems that this should be just a quick formula solution, so what will it take to make this happen?

Beceriler: Excel, Veri İşleme, Visual Basic, Microsoft Office, Veri Girişi

Daha fazlasını gör: free microsoft excel customer data entry, microsoft excel data extract, data microsoft excel jobs bangalore, kinds data entry microsoft excel, bpo floor plan excel, data scrubbing microsoft excel sheet, excel data connection as400, microsoft excel data input macro, excel script update data connection, microsoft excel data entry jobs, data microsoft excel adobe photoshop, microsoft excel macro data internet explorer, dwg villa floor plan free data base, microsoft excel data entry experience, types data entries microsoft excel, types data entry microsoft excel, vba excel floor plan, excel 2007 odbc data connection vba, excel floor plan outsourcing, Microsoft Excel Web scraping Data scraping

İşveren Hakkında:
( 0 değerlendirme ) Coeur d'Alene, United States

Proje NO: #21941999



Hi, I have understand the project requirement & interested to make floor plan template for this project. Please send a message so we can discuss more & start the project. Thanks.

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(38 Değerlendirme)

Bu iş için 4 freelancer ortalamada $123 teklif veriyor


Hello? How are you? I am excited to work with you on this project. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom formula, etc... [login to view URL] Daha Fazla

$155 USD in 3 gün içinde
(101 Değerlendirme)

Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thank you, Asad Khan

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(163 Değerlendirme)

Hi, I have good Microsoft Excel skills with years of experience as well as I have complete number of projects for Excel to manage data and sorting. You can check my profile feedback section and you will know what my cl Daha Fazla

$250 USD in 7 gün içinde
(87 Değerlendirme)