I want to automate the report in Excel. I would like to understand which module can cope with the necessary tasks:
1. Compare cells in in different columns (eg b1 and e1), if the value in them is the same, copy the value from the adjacent cell to another (eg D1 in C1). Total ~ 100 lines.
2. Copy the specified range of cells to another sheet in a specific place.
3. (optional) The ability to tint cells.
Tell me what you can use?