Find Jobs
Hire Freelancers

Microsoft Excel Floor Plan Data Connection

$30-250 USD

Completed
Posted over 4 years ago

$30-250 USD

Paid on delivery
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?
Project ID: 21941999

About the project

4 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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.
$30 USD in 1 day
5.0 (38 reviews)
4.6
4.6
4 freelancers are bidding on average $123 USD for this job
User Avatar
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
$55 USD in 1 day
5.0 (163 reviews)
6.6
6.6
User Avatar
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 client asking for my work. I am Alison certified for Microsoft Office and Microsoft Excel. So, you can Trust me for a Best output with complete satisfaction. Your work will be delivered well in advance with seamless communication & timely response until project is completed. As well as for any alternation and query we are available 24 x7. Looking forward for great business deal.
$250 USD in 7 days
5.0 (87 reviews)
6.3
6.3

About the client

Flag of UNITED STATES
Coeur d'Alene, United States
0.0
0
Payment method verified
Member since Oct 23, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.