Hello Team
I am trying to find a way to avoid all these time consuming clicks in order to copy paste special and divide.
I am always working with reports where figures need to be divided by 1000. Is there any way to:
1) run a macro through a keyboard shortcut key in order to divide all the selected cells by 1000 (ideal solution), or
2) copy 1000 from a cell and then use a macro to copy paste special and divide. (works fine as well if Option 1 is not possible).
Please find attached a very simple file. Let's assume that this is my generated report and I want to divide all the values by 1000.
Many thanks in advance
Yannis
Bookmarks