• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel question by Edbrugman

E

Edbrugman

New Member
Good evening
I have a question about the booking calendar I use for our B&B.
When I make a booking, it shows in the Dates tab and on the calendar.
What I want the booking to be transferred to the studio booked in the studio tabs.
Can someone help me with that.

Kind regards Ed
 

Attachments

  • sample sheet.xlsm
    102.9 KB · Views: 17
Convert the table on the Studio 1 sheet to a normal range.
In cell A6:
=FILTER(Tabel1,Tabel1[Studio]=1,"No bookings")
That's it.
Similar for the other Studio sheets.
 
Last edited by a moderator:
p45cal
The attachment works perfectly thanks again.
When I put the formula in the formula bar and press enter I get a popup that the formula doesn't work!
 
Good evening / Afternoon (I'm from the Netherlands)
I have a question about excel, I have explained in the attachment what I would like.

kind regards Ed
 

Attachments

  • example sheet.xlsm
    29.9 KB · Views: 2
Edbrugman
As You've read from Forum Rules ...
How to get the Best Results at Chandoo.org
  • Use Relevant words in the Title and in the tag Box, This will aid future searches.
Could You give/modify more relevant words for the Title?
 
bretlee21
You should open a new thread based Your looking.
Please reread Forum Rules -
How to get the Best Results at Chandoo.org

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org

This thread belongs to Edbrugman
 
You must log in or register to reply here.
Back
Top