Hi all,
I currently have a macro that copies the whole of Column K, which is dynamic and could be from K2:K10 or K2:K100000.
This data is copied and pasted into Column L and it is sorted and the blank cells removed. This data is then copied to A2 of Sheet1, where a Pivot is then created from this data.
However, say for example the data is K2:K4242 with a number of these being blank. When this is copied from Column L into Sheet 1 the Pivot still selects K2:K4242 despite the last 2000 cells being blank.
THis then causes problems for the pivot, as it counts the blanks etc.
Any ideas how to get around this?
Kind Regards,
Chris
Bookmarks