Hi All,
I'm really struggling with copying a range over from one column in my filter to another.
I've been using the following technique but no luck so far:
Select range
Ctrl + G
Go to special
Select visible cells only
Go over to range in another column
go to special
select visible cells only
Ctrl + V
This is then coming up saying it can't do multiple ranges, am I doing something wrong? I swear excel has lost some functionality over the years I used to find all of this easy
Any help would be greatly appreciated!
I'm really struggling with copying a range over from one column in my filter to another.
I've been using the following technique but no luck so far:
Select range
Ctrl + G
Go to special
Select visible cells only
Go over to range in another column
go to special
select visible cells only
Ctrl + V
This is then coming up saying it can't do multiple ranges, am I doing something wrong? I swear excel has lost some functionality over the years I used to find all of this easy

Any help would be greatly appreciated!