I am trying to do a simple reservation sheet where if the name is selected on the 'calendar' sheet in cell B1, and a room is chosen in cell C1.. then the 'reservation' sheet will read in cell column C the same information that is in sheet calendar cell C1 according to the persons name ... otherwise i would like it to read whatever the information entered on the reservation sheet is.
Is this possible???
Thank You
Last edited by angebis; 04-16-2015 at 01:44 PM.
Thanks for the title change
Im a little confused about what you want here?
Are you pulling from Reservation INTO Calendar?
You have Dan's name in Calendar B1 and room 3 in C1, but Dan did not use room 3, he used room 8? Room 3 was used by Mark and Joe.
Perhaps explain in a bit more detail, so we can understand your requirements better
Last edited by FDibbins; 04-16-2015 at 04:02 PM.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
A few adjustments. Don't use full columns, it takes forever to calculate.
Last edited by Jacc; 04-16-2015 at 07:38 PM.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Right Dan is in Room 8. But looking at the calender, I would like to move him to room 3. So i would like to change his room fromthe calendar sheet and have the reservation sheet match that room... Thus what I would like to do .. if I selelect any name on he calender sheet and select a room for them on the calender sheet I would like THAT room to be entered in the originally reservation sheet. (IF no room is selected then i would like it to just be what the reservation sheet says it is.)
Does that make things more clear?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks