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