Search results

Check out the following, they have a UDF for exchange rates 'Samir Khan 'http://investexcel.net kanti

Hi Sudipto, Look at attached file cheers kanti

Hi Ratan, Hope the attached helps. I have used a helper column, but you can build the formula without it kanti

Hi Shahul, see attached

Check out the attached file

Hi Jack, Did you try Double Clicking on the bottom left corner of the cell you want to copy. If you place you cursor on that corner until it turns into a +, you can then double click the plus and it will copy all the way down.

Hi, Delete the Application.Run from each line and it should work. You can also replace Application.Run with Call kanti

Hi Robbie, see the attached file, I have tried to make all the parameters dynamic, so you can change the split. The formulas are in the highlighted cells kanti

Hi Yous can use VLOOKUP, see attached file

Hi, Try building code with Copy/Paste Special value on the cell where the link is. This will leave on the values in the cell and not the formula.

Hi Febausa, Have a look at the cell highlighted in yellow, it gives the formula that should go into L3

Hi, See attached pivot file

Hi Sambit, I have included a vlookup formula in your file. Please note that the invoice numbers on the sales data tab are formatted as text and not numeric

Hi Oren, Not sure if this would help, check out this link: http://www.teylyn.com/articles/excel-articles/xy-scatter-chart-with-quadrants/

Hi Kuldeep, Sorry, I do not know how to Encrypt the file at that level. We can programme in VBA password protection once the file is opened. Kanti

Hi Kel, I have used the Camera in Excel, to take a snapshot of the Pivot Table, and copied it to both your other sheets. The snapshot would update as the Pivot is updated.

Hi Kuldeep, Have a look at this link http://answers.microsoft.com/en-us/office/forum/office_2010-excel/workbook-encryption-with-macro-help/c0dd3057-7d4e-4b6a-a3c0-a2b66cd4d292

Hi Polarisking, Try formatting the cell to Numbers, with 0 decimal places. kanti

Hi Kel, Here is your file with the "Photo" of the Pivot

Hi KH_03, OK, you can try the Camera functionality in Excel, this will create a picture of your Pivot Table that you can drag aground the sheet. Hope this helps. kanti

Hi Igosusa, Please refer to the attached, I have highlighted the changed cells in yellow kanti

Hi Umesh, Convert your Data into a Table, and make the Table the source. Kanti

KH_03, The attached file has a pivot table, with a Report Filter in Row B. Changing the Project would change the Pivot

Hi Kuldeep, What level of Password do you want to reset. kanti

Hi Raj, See attached file. It uses the SUMIF