guest

  1. P

    Emailing from (?) Pivot data

    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...
  2. H

    Call Word document (with mergefields ready) and MailMerge it from Excel (all hosted on Sharepoint)

    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...
  3. J

    Booking Tracker

    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...
  4. K

    macro beginner

    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...
  5. E

    Sum of All Numbers Inside the Parenthesis

    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...
  6. M

    String query

    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...
  7. S

    Combine 3 columns, but keep on separate rows

    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...
  8. D

    External Data with additional columns

    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...
  9. G

    Macro to sort results by placing them into individual worksheets

    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...
  10. A

    IF Function

    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...
  11. E

    Rooming list

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top