Im trying to compare two columns and highlight the red cells in one sheet which are missing in the other one. It works fine but having dificulties in restarting cela loop... Did try to do it using do while but no luck as well.
Another thing which im strugling with is writing a code to open those files. Having troubles with path... Found lots of solutions online but none of them works for me...
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.