Menu

Making Monthly Profit Report For Traders

Write a micro to create a monthly profit report for Traders on a sheet from A1 to M11 in excel. The first
column contain 10 different random Traders name like Alax, suraj etc. Don't repeat the names. The other 12
columns contain the months from January to December and cell contains the numbers and the - numbers contain
< than -1000 and + number also contain < than 1000 show Profit or Loss report, all the numbers are randoms.
The objective is that when running the macro the value will instantly highlight all the negative values
within that range in striking red. Give suitable headings to the table columns.

And thanks for teaching ChatGPT. It is very easy to understand all the methods.

Making Monthly Profit Report For Traders - image 1 - student projectMaking Monthly Profit Report For Traders - image 2 - student projectMaking Monthly Profit Report For Traders - image 3 - student projectMaking Monthly Profit Report For Traders - image 4 - student project