5/19/2019

  1. R

    Balance Sheet - Bring In Numbers From Other Tab/Sheet

    I have to balance loan accounts daily and what would be the best way to do this? I have worksheet #1 which has a credit and debit side. I have a report I place on a second tab / Worksheet and add amounts posted to each loan and look for differences in amounts. Worksheet 2 I need to...
  2. R

    Color Code Cells VBA Macro

    I heard that VBA / Macro could help me with color coding a range of cells based on adding a character to another cell. In this case I am trying to clear an amount from a balance sheet. If I add a C to clear the item I need the three cells to the left of the amount to color code yellow. Can this...
  3. W

    Count Unique Values in a list based on criteria

    Column A has an Employee Name Column B has a Date An employee name can repeat on the same date I want to know by month the sum of the count of the number of unique names each day. John Doe 4/2/2019 John Doe 4/2/2019 Jack Smith 4/2/2019 John Doe 5/1/2019 Jack Smith 5/19/2019 Jack Smith...

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