Search results

Sir here I posted my requirement as in Column G of Invoice Cash Cheque. Hoping you do the needful

Sir I want to sum each party's by pary Bill Amount, Cash Received, Cash Transfer, Cheque Received, Goods Return etc... I mean, In Invoice-Cash-Cheque sheet, Sum each Party's transaction by with its Narration; Column B (Customer Name) Column C (Narration Heading) I have posted a Macro for...

Sir I think my question confused you. Sir I need a formula for as per in last post.

I copy paste the formula in col G but noting happened Please check Invoice-Cash-Cheque sheet

how many if can we use in one command line

Sir, In Invoice-Cash-Cheque sheet Column C contain Bill No..... , Credit Note , Cash Transfer etc.. I want to add in the same sheet Col. G if Col. C Contain Bill No.... Then Invoice , If Credit Note then Goods Return Etc..

Sir I want all party name in one sheet Party Name Invoice Amount Cash Received Discount Given Credit Note Sales Return Cash Transfer 1 2 3 4 5 6 7 8 9 10 11

Thank you Sir

Sirs, I Want to Add Column G As Invoice if column C contains Bill No...... And if column C Contains Credit Note then add to Goods Return. as in Sample data Invoce-Cash-Cheque sheet.

Sir I got a code like below,but I want to sort out and copy each party's sum of sales, cash received, cheque received, discount given, goods return etc. in a new sheet w. Sample file attached. Can somebody give a solution? That is Total of Invoice amount, Total of Cash received, Total of Cash...

Sir I got a code like below,but I want to sort out and copy each party's sum of sales, cash received, cheque received, discount given, goods return etc. in a new sheet w. Sample file attached. Can somebody give a solution? That is Total of Invoice amount, Total of Cash received, Total of Cash...

Sir I got a code like below, but I want to to sort out and copy each party's sum of sales, cash received, cheque received, discount given, goods return etc. in a new sheet w. Sample file attached. Can somebody give a solution? That is Total of Invoice amount, Total of Cash received, Total of...

Set sh = Sheets(1) 'Edit sheet name My sheet name is Invoice-Cash-Cheque

Sir, Can you modify the cod as I replied before.

Thank you so much sir.

Some error showing as follows When I run the macro its copy Sheet2 Heading also to the sheet1. Sheet2 Column A contains formula. Actually range is Sheet2 B2:F200 When I remove sheet2 Column A and Heading its copying properly. Can you modify this code as suitable for me Thanks and Regards

Sir, I want to copy from sheet2 to Sheet1; Copy paste special transpose wise.

Sir I don't want to delete the formula sheet. I need macro for other purpose. As in the sheet1 of uploaded workbook, I need Total of Invoice amount, Total of Cash received, Total of Cash Transfer, Total of Discount given, Total of Credit note for Each party. In the requirement sheet there is...

Sir still I did not receive any response for this question.

I have excel workbook contains Name and address as on the format of sample workbook sheet2. I want to copy it in the format of sheet1 of sample workbook. Sheet1 data contains in alphabetical order.Data of Sheet2 starts from B2. I need a macro for copy this data from sheet2 to Sheet1 as the...

I need a VBA solution for do that Each party and its relevant sum showed in separate column party name Bill Amount Cash Received Cash Transfer Discount Given Credit note etc...

I need a VBA based solution sir