Afternoon folks, I do hope you can help.
I have a worksheet called "Daily MI". In cell A5, I need it to return some details from another sheet called "Car Data". The details are in the "Car Data" sheet as follows. Column F has a status - five possible statuses .... New, Old, Trade, Broken, Sold. I need cell A5 in the "Daily MI" sheet to display the counts of the statuses all in one cell.
Sold - 1
New - 5
Can this be done VBA or otherwise?