Search results

I want to calculate percentage of column total by the item which exists in another column. This i have to do it in Pivot table.Could somebody help me on this. I have uploaded the file here.

I tried connecting the same slicer(s) to multiple pivot tables using the same source data. After I added a new pivot table and having the new pivot table selected, I went to the Slicer icon drop down and was going to select "Slicer connections", but it is grayed out. Is there a step that I...

Hi DaveTurton Firstly thanks for your help. As you said i have inserted my code between the statements you mentioned above. but it did not work for me. I am not sure if i am doing it in correct way. I created a new module and placed my piece of code between the statements you provided.Is...

Dear seniors, I have a question on the macro events here. Below is my code. This performs the below Operations’ Private Sub SaveAsTabDelimited(ByVal sFileName As String) With ActiveWorkbook .SaveAs Filename:=sFileName, FileFormat:=xlText, CreateBackup:=True End With End Sub Public Sub...

Hi All, Are there any good resources,as good as Chandoo.org, to learn about MS Access. Thanks in Advance

Hi Everyone, Here is the problem. Let us just assume that the cell A1 contains word "santhosh" Now my question is when we make some changes to cell A1, the cell B1 should return the time of such changes.(say it as 12/23/2011 11.57 am) Can we develop a formula in cell B1 to track such changes.

A1 B1 C1 D1 E1 Reference No Date Submitted Description Reason Code TE Mgr/Supv Comments When The cell E1 is filled with a data, automaticlly a reminder mail should come to our oulook inbox stating that This Cell has been filled.Please...

thank you so much luke.

There are 3 Excercises. Kindly answer this. Excercise1 Below are Marks of different students of 6 subjects, Final result is pass if the candidate has got alteast 40 marks in each of the subjects. He his marks is less than 40 in one subject, His final result is fail. Please create a formula in...