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

    Formula For Total Charges Based on Dates and Holidays

    Dear Chihiro, your last post is very helpful for me clarified my mind how to build such a sheet. Thanks also Tech56 for his query. But calculation goes wrong when I change just a rate at periods, and total changed to Holiday rate of $ 140. The total never recovered even if I retrieve the...
  2. Z

    A Proper Formula to Calculate depending several Criteria

    Crosspost: https://www.excelforum.com/excel-formulas-and-functions/1311350-a-proper-formula-to-calculate-depending-several-criteria.html#post5305057 Hi to All, I am not sure whether a formula is possible to calculate based on the selected criterias on my attached file because there are really...
  3. Z

    Vba to populate inputs on multi Sheets with Index Sheet and hyperlink between

    Crosspost https://www.excelforum.com/excel-programming-vba-macros/1309288-vba-to-populate-inputs-on-multi-sheets-with-index-sheet-and-hyperlink-between.html#post5294291 Hi everybody, As being seen in my attached example file which is also very similar to my original, I have 4 constant sheets...
  4. Z

    Need help to export used ranges of sheets to pdf

    Dear Alan, One more thanks for your support. I compiled your code with your referenced web site code as in below, now works fine. Regards Option Explicit Private Sub PrintPDF() Application.Run "StopAllEvents" If Sheets.Count >= 6 Then Dim x As Long Sheets("INDEX").Select For x = 2 To...
  5. Z

    Need help to export used ranges of sheets to pdf

    Ok Luke I will. Thanks for reminder
  6. Z

    Need help to export used ranges of sheets to pdf

    Dear Alan, I checked your referenced page but not get a right solution to print in a single pdf. I tried several possibilities but the the pdf file has lots of mistakes can not transfer the data on excel in well format and several blank pages occured. Hope to hear from you again. Regards
  7. Z

    Need help to export used ranges of sheets to pdf

    Dear Alan, Kindest thanks for your code, works excellent to build seperate pdf pages. Is it possible to gather (INDEX + HOTEL X + HOTEL Y) them in one pdf file as pages and save to the same directory of excel sheet? Regards
  8. Z

    Need help to export used ranges of sheets to pdf

    Dear Alan, Thanks for your concern. I need sheets starting from INDEX (2nd Sheet) till last sheet to be printed (Sheets CALC & HELPER1-2-3 excluded). Last sheet number is variable can be lead to 150-200 and all ordered after HELPER3. Sheets with HELPER title are hided in my original workbook...
  9. Z

    Need help to export used ranges of sheets to pdf

    Hi, My example workbook is attached. In my original there are 5 contstant (3 of them are hided) sheets and various number (may lead to 200 sheets) of sheets after 5 constants. I need a vba to export the used ranges from 5th row to last used starting from the 2nd one to the last to a single pdf...
  10. Z

    Transfer Periods to New Sheet with Different Format via Vba

    Hi, My excel file is attached. How can the periods in Sheet1 can be transferred to Sheet2 with vba as in that format? Details are explained in excel file as well. Thanks in advance for kindest helps
  11. Z

    Calculation depending the criterias

    Sure your last version seems pretty to use. The .xls file is the final output file after running my macro to transfer hotel contract rates to a simple version. The dates under the letters A, B, C... are periods, the figures on yellow ribbon refers number of allotments (rooms to be reserved) that...
  12. Z

    Calculation depending the criterias

    :) Become more complicated than my expectation. Your file is nice to see prior calculations but can not understand - & + & Stress Buttons performance maybe I am missing something. However I was failed sometimes to enter new dates to be calculated gave some Warnings. Dear my pdf file (normally...
  13. Z

    Calculation depending the criterias

    Thanks indeed really seems nice. But honestly no need for a chart because this sheet is needed to provide instant calculation when a customers ask for holiday. For new terms or new customers I must make a new calculation and so on. I do want to state what I try to manage with your help: I have...
  14. Z

    Calculation depending the criterias

    Hi. I checked seems making right calculation. As far as I see you transposed the data in Data Sheet. Hope to hear soon. Regards
  15. Z

    Calculation depending the criterias

    Hi. A- Yes it will be in that sheet. Hotel data (prices, etc) is picked from another workbook via vba and formatted as in Sayfa-1. A1:B8 is the area to enter the parameters to find accurate price for that term. A- I added OVERNIGHT area to be away from user failures because some requests are...
  16. Z

    Calculation depending the criterias

    Dear Vletm, Thanks for your kindest reply calculation in B7 seems worked well at my several tests. I made some changes on file (can be assumed as final file) and attached here. So can it be possible to adobt your vba according to this file? Details: - I added OVERNIGHT Row below of dates and...
  17. Z

    Calculation depending the criterias

    Hi, My excel table is attached. The areas on the top involved the criterias to get the sum on TOTAL area defined with details on the right. My questions can be summarized as: 1) How can the data in B3, B4 & B5 auto populated regarding the data below? 2) How can the sum be auto calculated...
Back
Top