Hi,
Can anyone create a VBA function or macro to extract all numbers highlighted in red in my worksheet to sheet 2. In sheet one, there are a few hundred numbers highlighted in red among many not highlighted numbers. I don't want to copy/paste one by one because it may cause errors. I want the computer to extract all number highlighted in red to sheet 2 and leave ten spaces below it. Ex.
123 456 901 756 146 486 146 156 183
Like this, I you can't, just help to make a macro to extract all numbers highlighted in red to sheet 2.
Please help. Thank you.
Bookmarks