Search results

thanks bobhc, but I would like to keep on adding full year forecast which can not be appear in one page....is there any way where I can squeeze the data and show this information in better visual...

All, I have one sales forecast file where I would like to add some information but the data outlook is not visible while I printed on A4. Is there any way to make file visible with all information. file template is uploaded for the reference, please review and update. appreciate for your...

Dear All hope you all doing great, As usual need your expertise, I need one format to track the service jobs to be converted in to sales in a fast track. following are the steps to followup this jobs till it closed and invoiced. please help me how to develop format to track and followup where...

Dear balli, Thany u so much for ur response, the way u did is almost to the point. Just couple of things to be added. Categories should be come up with three branvhes ruh, jed & dmm. Last thing i dont want the data for the previous years just need for 2014. Please tell me how to show only...

Dear Somendra, find attached format i developed to plot the data manually, but its time sucking job. i dont want this to be update on weekly bases. please advise some short cut and time saving tricks to update this. regards Jams

coloumn "O" is booking months and "P" Sales months and i need both coloumns for 2014 only. Coloumn "N" is probility in %, so i need these % against each month. lets say march 2014 shows 10 jobs in booking at coloumn "O" then which jobs are falling at what probility % according to Coloumn "N"...

Dear Somendra, Thank you so much for continous track, let me explain to you, you will find categories in coloumn "H" i need this categories values month wise in priority percentage that is coloumn "N" 100,% 80%, 70% and more. this information is required for my manager to keep track...

Dear Bobhc, My request does n't mean to response every one, those who are intrested to help I will be gald to them. by the way you can go through my entire writeup i never mentioned urgent any where except please and help. still I appologies deeply if my thread made any inconvinence in this...

sorry to say that i have not tried very much in pivot, Value in LC in quotation value very important column.

Please can any one come forward to help in the above request. Regards Jams

Dear All, Need your expertise, find attached quotation pipeline activity report for three branches from KSA in this file we have 7000 quotations. I would like to develop this file with priorty percentage. required sample format is also attached. please advise either i have to use Pivot /...

Dear Narayan, second file is uploaded for refernce. sri, i will try your formula but still its not clear to me. regards Jams

for more reference file is uploaded. in this file i want to select coloumn A & B at the same time and want to compare this data with other file. your immediate response is highly appreciated.

Dear all, I have an issue, i need to select two coloumns to apply vlook for comaprision for example, lets i have data in coloumn A and B and i want select this two coulumns and want serach see these data is available in other sheets. Regards Jams

Dear smallman & Lohith, above both ways are working. many many thanks and appreciate you both for express response, may good bless you and keep on rocking every time. Regards Mohd Jameel

for more refernce sample file is attache for your review.

Dear All, Hope all r doing great, once again i need your immediate response from you all to the following issue: i have large HVAC parts data consist if 7,646 rows, where as in this data some part numbers and there qty are repating / duplicate and i want this repating part number and their...

thank u very much Dear Lohith, hope it will work, apprciate u and god bless you always. regards Jams

Dear All, I need your cool response to my below request. I have an excel file consist if 10,545 coloumns, data transfered from AS400. File is uploaded for your reference. if you see this file coloumn B is one line data but this is splited to many lines and same thing repeating in C and D...

thank u boss, i got it and I appreciate for you kind response good bless u. regards Jams - AP

Dear Narayan, thank you very much for ur response, I tried this its working well but i need total hours in numbers at E6 not in time format please advise. Jams - Khammam

need your valuble inputs. please comeup....

Dear All, I have file with the following information please I request some one to advise me how to take total hrs by applying formula in excel Start Time End Time Total Hrs 07:00 PM 06:30 AM 11.5 07:00 AM 06:30 AM 23.5 (One day full) above starting time is in C6 cell...

first of all thanks a lot for ur valuble inputs and appreciate for your precious time. Dear SirJB7, Sir I appologies if i did some thing wrong here. one thing i want to clear that I am new user to this forum next time i will take care before posting any comment. forgive me if take ur hardtime...