guest

I'd appreciate some guidance, please. I'm running a dinner where each member can invite guests. I'd like to use Excel as the data source to send an email to each member's email address, with the body containing details of each guest (name, diet, confirmation etc). I've created a pivot table...

I have to setup a series of mail merged forms for my school to invite guest speakers to our classrooms. For that, I have setup a table called Guest_Speaker_MM. I've already created all the merge fields and tested them using manual mail merge and they worked fine. However, when these files...

Hi Everyone, I am trying to create a booking tracker, for example if I input start and end date per guest/room, this days will be highlighted on calendar. One room can have different guest on different dates range. I was using if(and(vlookup, but only able to have first guest info on the...

hello all, i'm a beginner of macro i want to create a form template to record guest inquiry, trying to write some code on textbox(es) to speed up my daily progress however i get stuck with below issue, hopefully someone can help me out, superb thanks the data will be saved into sheet2...

Hello Guys! I'm currently working on a worksheet and i need help on the formula. Im trying to get the guest count from the long list given to me in an excel sheet where name of guest and head count is written together in 1 cell and in a single column. 1) I would like to get the sum of all the...

Hi. This must be so easy for you guys and gals I tried using........... Findstring = "GUESTCharlieBrown" LeftString = Left(Findstring, 5) GuestString = Findstring - LeftString ..........should have produced "CharlieBrown" What's wrong? Findstring is OK as "GUESTCharlieBrown" LeftString is OK...

I can't figure out how and if I can combine text from three different columns and place them in the same column, but in same row, I prefer an function. Example: <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width...

Dear all, Recently I have come across a problem regarding the use of pulling external data from XML files to Excel 2010. I work for a very small hotel. The hotel database we are using is very poor by any standard, so we cannot but make up its deficiencies by pulling some of its data to Excel...

Hi all, Looking for macro help. I need to have a downloaded csv/excel file sorted by "column X" and then have that row placed into individual worksheet tabs. An example would be: Column X Table for Member Table for Guest Table for Visitor Table for Member Table for Member Table for Guest...

Hi everyone, Need your advise to solve my problem as below example data; ARR = Arrival DEP = Departure A B C D 1 ARR DEP length of stay (night) Guest Name 2 26nov 2dec 6 Rihanna 3 30nov 5dec 5...

Hi! Please I need your help. I have created a rooming list for an event with say 120 guest. I have their check in and check out dates. I need to be able to calculate how many rooms I need for a particular night. The guests are booked between 23 Jan until 28 Jan. Their exact dates varies when...