How to choose from multiple sheets

[ctaylorhill]

Hi everyone,

First of all I want to apologise I am a bit weak in my termination so may not describe my problem well. This is because I am reasonably new to using Excel and VBA.

I’m a college student, and we have been given a new project. The main idea of it is to input data for a hotel, (it’s not a booking system) it’s just entering what rooms have been booked, at what price and then what pricing band that falls into. The data has to be laid out in fortnights, I have decided (In hindsight I wish I had done it another way) to put a fortnight on a sheet (26 sheets in all) as well as 14 days full of room bookings there is a daily summary and then a fortnight summary. There’s a 27th sheet that is used as the annual summary (Collecting all of the fortnightly summaries).

I have set out all of my 26 fortnight sheets and have them working with all the correct formulae, as well as the annual summary sheet.

I am at the issue now of how I am going to get my 50 rooms data (Which I am doing via a custom form) into a pre laid out sheet; I understand I have to work out what fortnight the data will need to be inserted into. But I am confused as to how I am going to do this. I am planning to do this on one “Save” button as this button will do extra things as well as this so it will be done by VBA.

I hope this all makes sense. I have added some images if it helps.

I will appreciate any help with this!

[shg]

Welcome to the forum.

Please read the forum rules about thread titles (and in general) and then amend your title accordingly.