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![ROFL :rofl: :rofl:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f923.png)
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
![ROFL :rofl: :rofl:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f923.png)
Any help would be greatly appreciated!