debtor

  1. P

    Match data by month

    Hi to all of you, kindly require to provide me support for a VBA code so that, to match debtor’s amounts based on months. Therefore that the months have a stable row “C4” : “O4” including “Total” column and also the data have stable range “A3500” : “O3595”. The adjusted data I would like to...
  2. L

    to look up value on another sheet but 2 rows down

    Hi Mr Excel, I am trying to do update doubtful debt provision for the year end. I have opening balance of doubtful debt worksheet where Column A is for Debtor number Column B for outstanding at the beginning of the financial year Now i would like to bring value from AR Ageing analysis to column...
  3. P

    Insert columns and fill down the formula "SUM"

    Hi all, I would like to use a VBA code, so that, to insert columns next to years 2018 & 2019 and fill down the formula to “SUM” each year separately. Therefore, that the columns are not stably. I present below the original data and the expected result. Thank you all in advance <!--[if gte...
  4. A

    Create multiple tables from one table (VBA code please)

    Hi, I have a table where rows range is inconsistent. I need to separate this table in multiple different tables based on customer. This table changes all the time. It can have more or less rows. Following is the table before and after sorting: Before Sorting <tbody> Customer Current >30...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top