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

    Complex Formula help needed

    https://www.dropbox.com/s/1dz5cn9cidj8lxt/ISO%20Version%208.xlsx?m
  2. T

    Complex Formula help needed

    Dear Faseeh, I was out of town and unable to respond, I made changes as per your instruction but still failed to resolve. Please help, uploaded in my dropbox a file name ISO Version 8, would appreciate if you pleae have a look and make necessory changes for me. Regards,
  3. T

    Complex Formula help needed

    Dear Faseeh, I think you forget to save file. Will you please redo the work for me please. Regards,
  4. T

    Complex Formula help needed

    Thanks Faseeh, For Karachi we are using office van so formula is different for Karachi. BTW, can suggest about overall enhancements of this workbook. Regards,
  5. T

    Complex Formula help needed

    https://www.dropbox.com/s/oysqvr9r2ksr0yf/ISO%20SHEET%20FOR%20CHANDOO.ORG%20-%20Copy.xlsx
  6. T

    Complex Formula help needed

    https://www.dropbox.com/s/oysqvr9r2ksr0yf/ISO%20SHEET%20FOR%20CHANDOO.ORG%20-%20Copy.xlsx?m Dear SirJB7 Above is my complete workbook, highly appreciated if you can help to improve. Regards, Sohail Tareen
  7. T

    Complex Formula help needed

    Dear All, I have 3 WS in a work book for logistic planning. In WS 1, I named a range "City" where I have multiple city names with Data validation list. Then I have second WS where I have 2 differnt columns named "D_T" representing diffrent type of delivery and then I have another column named...
  8. T

    Use of (NOW) or TODAY command

    Dear Narayan, Any luck ?
  9. T

    Locking of Cells

    Thanks for the reply however this is not i am looking for. I already locked the required cell n now wanted cursor to jumped to next cell where a input is req by user.
  10. T

    Locking of Cells

    Dear XL Gurus, I have few cells which contains formulas, I wanted cursor access to only those cell where data entry needed and as soon data entry on such cell completed cursor should jump to next data entry cell. Thanks in Advance. Tareen
  11. T

    Use of (NOW) or TODAY command

    Thanks Narayn for the reply, I am sorry I am a new to XL world and didnt know how to use Macros or how to play with VB, let me discribe my wish. I have a workbook consisting of 5 WS, I have a master WS where I have different dates, the most important is the ISO/Document Date, in this field I...
  12. T

    Use of (NOW) or TODAY command

    Thanks indeed Narayan, is there a way I can restrict users of this workbook to use only CTRL;??
  13. T

    Can I save a complex and long formula and use in differnt WS

    I am a new xl user, so if possible pls suggest a link where i can get some tips on UDF. I tried but failed.
  14. T

    Use of (NOW) or TODAY command

    Dear Jason, I tried but unable to get the result, will you please guide me step by step for use of Ctrl+
  15. T

    Can I save a complex and long formula and use in differnt WS

    Dear All, I have a very complex and long formula in WS1, is there a way I can save this formula using Name or macro and use in WS2.
  16. T

    Addition of days/Weeks in current date

    Sorry Customer!E5 has TODAY() command, just wanted to clearify :)
  17. T

    Use of (NOW) or TODAY command

    Thanks Faseeh, but I wanted to have an automated process. I have multiple user for this sheet and I as said earlier, though I need current date in one column automaticaly but once sheet saved by user that particular column locked its value. Giving liberty to users to cut and past is not possible...
  18. T

    Use of (NOW) or TODAY command

    I have a column where I use (TODAY), so i can know when this sheet created, when I open this xl next day defently it will use system date and will replace the column. Is there a way once a user send me the xl sheet with a system date of his own column got locked?
  19. T

    Addition of days/Weeks in current date

    Thanks guyes. I use following formula and its works for me. =IF(Q7="By Sea",Customer!E5+49,IF(Q7="By Air",Customer!E5+30))
  20. T

    Addition of days/Weeks in current date

    Hi, I have a worksheet for logistic planning. I have to add 6 weeks in current date if user select option of Via Sea Shipment and in case Via Air shipment I wanted to add 4 weeks in today's date. I am not familure with VB so like to use a formula for this problem. Thanks in Advance...
  21. T

    Date_Update

    Hi, I have a little bit differnt problem and need your help. I have to add days based on some crietaria, like if user select option of Shipment via Sea, then I wanted to add 6 weeks in current date.
Back
Top