I need a macro that will create new column, copy only formulas and conditional formatting from the last column and paste it into the new column is this possible at all???
Thanks for help
Dan
Printable View
I need a macro that will create new column, copy only formulas and conditional formatting from the last column and paste it into the new column is this possible at all???
Thanks for help
Dan
Yes, very much possible. But since the conditional format, and formulas could work differently depending on its referencing, it will be better if you post a sample file that resembles the scenario / situation in your original file.