Hi Andy See if this is what you wanted. I have changed the year to 2018 to match the data for testing purpose. You can delete the dates you ente...
Hi David What is the error message? Can you post your actual file with (without the personal data)? A few records will do, as I need to see w...
Hi Dan 1) Copy the data 2) Open the clipboard 3) Select the cell to paste and press F2 (or double click the cell) 4) From the clipboard pa...
Hi David Give this a try. Sunny
I hope those data you given are dummy as they contain some sensitive data such as bank a/c no etc.
Hi Maurizio You are welcome and Merry Christmas. Sunny
Hi Lam Lee Your source data should not have blank cells. All cells must be filled up. In you example, fill in the blank cells in the PAYOR colum...
Hi Maurizio If you need a macro then try this: Sub FormatCell() Dim i As Long For i = 6 To 35 If Cells(i, 2) <> "" Then ...
Hi Radu Not too clear about your formatting requirement. Is it using same patterns with different colors for positive and negative? See if this ...
Hi Maurizio Why don't you use a Conditional Formatting? In the attached I first set the default color for column G to RGB (0,255,255) I then ...
Hi Julie Please refer attachment. You will need to set the macro to run on a specific sheet. I have set it to the Report sheet. Hope this ...
Hi Maurizio Thanks for your lengthy explanation It doesn't matter whichever method you chose. Achieving the desired result is the most importan...
Hi Maurizio You can also have a look at these two links to see if they help: Sunny
Hi Maurizio Thanks for your kind words. I would highly recommend that you learn Pivot Table as it is incredibly powerful and versatile tool. ...
Hi Maurizio Attached is another method using PivotTable. Sunny