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

Search results

  1. smittal

    Want to link a file with folder and sub-folders (at same location)

    Good Morning All. i don't know whether it is logically possible or not but, what i am trying to do .. i am making a dashboard for senior management and currently we are handling more then 150 clients. There is a specific location where all the files and folders are saved. A folder (org name)...
  2. smittal

    Hotel booking engine module in Excel

    Thanks to all. Problem solved.
  3. smittal

    Nested Data Validation

    Thank you so much Narayank991 sir. This is the thing i was searching from last 1 year.:);)
  4. smittal

    The pain you feel today is the strength you feel tomorrow. For every challenge encountered there...

    The pain you feel today is the strength you feel tomorrow. For every challenge encountered there is opportunity for growth.
  5. smittal

    Nested Data Validation

    Hello All, i am in dilemma for this thread from around more than an year. i already read http://chandoo.org/forum/threads/requesting-help-on-data-validation-based-on-information-from-a-different-cell.4529/#post-23667 link on chandoo.org website but sorry, my Requirement is little different...
  6. smittal

    Hotel booking engine module in Excel

    Hello Luke!! Sorry for delay...formula suggested by you works perfect :)... but just a slight confusion here.. should we use "<" function with lookup condition..or "<=" let eg, Arrival Departure Room type Rooms 20-Jul-13 21-Jul-13 Standard single 1...
  7. smittal

    Hotel booking engine module in Excel

    The no of rooms column is <Room booked by customer>
  8. smittal

    Hotel booking engine module in Excel

    sorry, i have done editing 3 times bt still its looks unreadable... :(
  9. smittal

    Hotel booking engine module in Excel

    Perfect Luke... Thank you so much...Kindly suggest one more thing.. just add No of Rooms also.. Arrival Departure Room type no of rooms 17-Jul-13 18-july-2013 Standard single 4 17-Jul-13 18-july-2013 standard single 5...
  10. smittal

    Hotel booking engine module in Excel

    Hello Luke, i am re-posting the link, please check if this is working.. https://www.dropbox.com/s/dj259dogqym52ld/Forums%20Sharing%20Sheet.xlsm
  11. smittal

    How can we apply vlookup in ms Access ?

    just select the tab1.emp_code and drag the same to tab2.emp_code.. then you will be able to see the line, which called Inner Join. https://www.dropbox.com/s/aiswifqwc4y8bed/Reservation_master.accdb link is attached here. just open and try too read Booking_cancellation Query in Design View
  12. smittal

    How can we apply vlookup in ms Access ?

    Hello Jitendar, You can apply vlookup in Access with the Help of Joins...Let me explain.. you have two tables with same fields (Vlookup criteria).. just select the field of 1st table and without droping match the same field in second table. now, a join is exists and when you double click on...
  13. smittal

    How to send only current sheet in email ?

    Hello Jitendar, You can try this..... https://www.dropbox.com/s/x5inayh2zwarlp2/SendMail%28Attachment%29Testers.xls
  14. smittal

    Vacation [SOLVED]

    Because we are creating an array here!!!
  15. smittal

    Hotel booking engine module in Excel

    Hello, I am creating a booking engine module for a hotel website. As every hotel has defined number of rooms with defined room category, the concern is in checking the availability of a particular room type for a particular date. The purpose of the module is that if a user enters arrival...
  16. smittal

    VBA code to automatically merge excel tabs in new master sheet [SOLVED]

    Thank you all for suggestions, Thanks SirJB7..i was not aware about this option (search part). Will do it and if not get the appropriate result.. will get back to you
  17. smittal

    VBA code to automatically merge excel tabs in new master sheet [SOLVED]

    Good Afternoon all, can anyone please suggest the VBA code to automatically create a master from another excel tabs. i dont have any idea regarding same. :( Thanks to all in advance.!!
  18. smittal

    VBA code to automate mail with pictures [SOLVED]

    Would request you all to please close the same. Thanks
  19. smittal

    VBA code to automate mail with pictures [SOLVED]

    Gud Morning All, i request you to please confirm whether it is possible to use pictures in automate email through VBA. Many thanks in advance for same.
  20. smittal

    VBA code to automate mail with pictures [SOLVED]

    Good morning to all, i have used below code for same... please suggest what should i change in same to get the picture download in automate mail body: &#39; Don&#39;t forget to copy the function RangetoHTML in the module. &#39; Working in Office 2000-2010 Dim rng As Range Dim OutApp As Object...
  21. smittal

    Want to Add New sheet for every new client thru VBA code automatically [SOLVED]

    Thanks SP for the same. problem solved :)
  22. smittal

    VBA code to automate mail with pictures [SOLVED]

    Hi, can anyone please suggest VBA code to automate mail that supports pictures also. a link is attached here in which i want add picture in outlook body well but its not supporting. https://www.dropbox.com/s/98jk411zod6uea6/Ajanta%20confirmation%20voucher.xlsx please suggest the code for...
  23. smittal

    Want to Add New sheet for every new client thru VBA code automatically [SOLVED]

    i want to tag this topic with [solved]. please suggest
Back
Top