Search results

Thanks bobhc i will check this. Sent from mobile

Thanks Narayan courtesy link works which have some VBA coding but Activesheet.Cells.Select not working. can you tell me what mistake i m doing when using below statement. Activesheet.Cells.Select Thanks Pavi

Thanks for your reply Narayank... I am ExcelVBA dumbo... can you please tell me where is Immediate Window in VB editor. Regards, Pavi

Hi bobhc thanks for your reply... I tried copy move sheet but this also not working... Regards, Pavi

sorry... I am using Excel 2010.

Hi All, Please help me.... I have protected sheet i want to copy data from that sheet and want to paste in other excel but unable to copy from protected sheet. Thanks Pavi

Thanks kaushik for your reply... Actually I not yet received the Salesmen Target from respective country or area. I just want your suggestion on dummy data. For salesmen & Customer parameter is Amount. @Hui Sir, Raja's question is related to my post only. Raja Cost column refering...

Hi All, Please suggest me any format for my report. Regards, Pavi

Hi Ninjas & All, please share me report, Format & idea on below topic. 1. Weekly salesman performance against target 2. Area performance against budget-Dashboard 3. Customer Performance Tracking https://www.dropbox.com/s/8jvq917i6rnqsuh/Book1.xlsx Thanks Pavi

Hi sgmpatnaik, Thanks for your kindness. I will use your formula now but try to find out without adding Product1 & Product2 we will get the same result. May be Hui or Chandoo can find alternate to this solution. Thanks once again Mr. Naik for your support. Thanks Pavi

Hi sgmpatnaik, Thaks for your reply sorry for late reply as I reach home just few hours before. Actually formula didn't work. plase check file also I put figure what I want. http://www.2shared.com/file/ROwaevMq/Sumif.html Thanks Pavi

Thaks Koi... But.... I have around 7 different file which i have to do the same excercise. If you have some other formula which will work faster will be appreciate. Thanks Pavi

Hello sgmpatnaik, check below. https://www.dropbox.com/s/qu6ljjg5lihj6yg/Sumif.xlsx?m Regards, Pavi

Hello sgmpatnaik/Suresh Kumar Please check below link http://www10.zippyshare.com/v/14455188/file.html .. Thanks Pavi

Hi All, Please help me in below formula. I have data in below format. Product1 in E6 Brand1 in F6 Brand2 in F7 Product2 in E9 Brand1 in F9 Brand2 in F10 data is going till row 238 I want total of (Product1)Brand1 and Brand2 I want total of (Product2)Brand1 and Brand2 I have subtotal...

Thanks Faseeh, I made mistake in my question. below formla working fine. =IF((ROW(A1)+6)/7-INT((ROW(A1)+6)/7)<>0,"",OFFSET(Dealer!D$6,ROUND((ROW(A1)+6)/7,0)-1,0)) but want to tell you onething you are great and I am dumpo didn't understand anything how formula works... Thaks a...

Thanks Kaushik, Actually I am in office and unable to upload the file. 1. yes i want to paste the data but there are lots of customer so i want formula for that. 2. see there is no criteria just simple B1 and C1 from sheet1 will paste in B1 and C1 in sheet 2 then B2 and C2 from sheet1 will...

Hi All, I have 2 sheet in a same file sheet1 contain all customer no. & Customer Name. i.e. B1:C80 Customer No. & Customer Name and sheet2 have some format like Customer No. in B6 and customer Name in C6 then 6 blank row then B13 Customer No. C12 Customer name which i want from sheet1...

Great Hui... Thanks i will learn with your chart... Can you please help me for dynamic date range in this chart it will great. Regards, Pavi

Thanks Hui... I go through all your hyperlink chart, but what i want is something different. I uploaded the sample file which make you understand what i m looking for. Thanks for your time hui. http://www.2shared.com/file/uCLJ-faF/SalesData.html Regards, Pavi

Hi All, Please help me to too add target axis in my Hyperlink Roll over Chart. i.e. for each salesmen i want to show his monthly target when user roll over pointer on particular salesmen. I am using chandoo's Hyperlink Roll over Chart technique. Regards, Pavi

Thanks Narayan, Actually still not confirm that I will use my data for report or Respective RM's will send the data that's why i will not decided what to do but my GM ask me the format how can we publish the report. That's the reason I ask suggestion from expert like you and all Ninja's...

Hi All, Please suggest what should be in mind to Design the Sales Monitoring system. Hierarchy wise... Yearly Target for Regional Manager and What is the plan to achieve the Target then Sales Supervisor Target then Salesmen Target. Regional Manager Reporting to GM Sales Supervisor...

Thanks Narayan... now i got it... Regards, Pavi

Hi Narayan, When i m trying to use , in formula its not accepting only ; acceting in all formula. why its happening... I checked your new file its used same formula which i used in my file but for me its not working and in your file its working. Please help.. Thanks Pavi