Paul, thanks for taking a look.
I start by copying the contents of the MASTER SAVE tab and paste values
into Cell A1 of Worksheet tab.
I then run the macro NCFL_cleanup to get rid of everything on that page
except the single column of data I want to use.
The idea is then to paste the column of
Can you attach an example?It's difficult to guess what MIGHT be happening based
on your description.
When you "copy" the data into the cells, are you pasting the entire contents or
have you tried to "Paste Special -> Values"?
Are the values numeric or alpha-numeric?
It's possible when you copy
Hi All, I searched for an answer on this first but I'm hoping for some
easy, good advice.
Using VBA, I have preloaded some cells with formula-based conditional
formatting. When I copy a column of data into these cells, the conditional
formatting does not take effect.
Also, formulas in