Recent content by jams

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