Search results

Now when I double clip Data data validation Combo Box it is showing Run time error and showing this command line Set wsList = Sheets("requirment") Sir I want only use Highlight color field Macro in in requirement sheet only

Sir, if you have little time please following things.There is some errors in the macro. Eg. Jackson Pvt. Ltd there is sales return 1800 not showing in output sheet & discount given also not showing in output sheet. calculation should need to make Col. B with Col.G Sir please check Pivot Table...

Ok

Sir here with I uploaded a sample file. In Invoice-Cash-Cheque sheet contains Selected Row Highlighted Macro Requirement sheet contains other macro I would like to add Selected Row Highlighted Macro in requirement sheet also.

Ok Sir

I need to use all these macro in one sheet. Can we modify both Private Sub Worksheet_SelectionChange(ByVal Target As Range) suitable to work in one sheet. Is it possible ?

Sir when I change the code then Color selected row not working. Here is full macro data validation list. I don't know why its not working. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, _ Cancel As Boolean) Dim str As String Dim cboTemp As OLEObject Dim ws As Worksheet Dim...

Thanks sir

I would like to use 2 private sub in one sheet as given below. First one is used for data validation list, and a combobox . Second one is used for Highlight selected Row. How I can use both these 2 code in one sheet 1st One Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim...

Sir, in PivotTable itself can we use this formula?. Because in my Invoice-Cash-Cheque sheet (as in the uploaded sheet) don't have similar data in particular Columns. Sir my question is can we add apply the formula in PivotTable by add another value filed. I mean insert another calculated field...

Thank you so much Sir, It is working good.

Sir, Can we use add then Subtract formula in Pivot table as need a balance column in that table. Eg. Add Invoice(H5) Cheque Paid(D5) Cheque Return(F5) then need to subtract Cash Received(B5) Discount(G5) Sales Return(I5)...

I apologize my mistake. It was just happened due to my hurry. I wrongly attached that file. I know you were spending your time for helping others. I think it just happened on only this post. So please close this chapter here. Ok. Thanks & Regards

Sir how to add sum value Sum of Field1 in Pivot table

Sir I don't have enough knowledge about Pivot Table so that I suggest for macro. Can you explain how you create this table.

Thanks sir, Can you explain how can make this table.

Sir Can you remove this post because still I did not receive any right solution.

I need a macro which can Total each customer transaction with its Narration. How It possible? Total of Customer by Customer with its Narration like below Customer Name Bills Cash Received Cheque Received Sales Return .... Each narrations total should come one by one column. Sample file...

Sir still I didn't get a right answer. I think my post my be complicated to solve.

Sir Still I did not get a right answer. I think my posted question be complicated

Thanks a lot for kind help sir.

Thanks for your kind information

Sirs, above I posted a clear picture what I require, please look into this matter

Sirs, Suppose I have an Excel Sheet, and its column C contains Narration like Bill No.1568, Bill No.1569, Bill No. 1570, Cash Received, Cheque Received, Credit Note, Cash Trasfer to A/C etc.. I want to add Unique Text in Column G as Like Below Bill No.1568 - Invoice...