Paste Value in Visible Cells only...

[eugchen]

seems so easy, but not working very well for me.

ill describe what is going on.

this is the source sheet

A1 = 296.24
A2 = 210.86
A3 = 110

im trying to copy these three "values" onto another spreadsheet in the following cells

B4
B8
B70

the cells in between (B5,B6,B7, and the ones between 8 and 70) are filtered out.

so i copy the three cells in the first sheet, A1-A3, then go to the second sheet. select the 3 cells (B4, B8, B70), then do Control+G, and select visible cells, then paste.

all three cells, B4,B8,B70 all showing 296.24. (not the 210.86 and 110 it is supposed to show in the 2nd two cells)

does anyone know what im doing wrong?

[Pepe Le Mokko]

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

[eugchen]

ok sorry. will recreate a sheet since its on two worksheets. but here you go. look on sheet 1 and 2.

[eugchen]

anyone? still cant seem to figure this out.

[Eastw00d]

yes, on each of the selections you get the copied cells, so in this case 3 cells under each other for the 3 selected cells. So in total 9 cells are filled with the 3 subsequent cells.
If you unfilter the range in sheet2 you see what has happened.

If you copy the 3 cells to only one cell in sheet to, let's say "B4" all three of them are copied, but only one of them is visible due to the filtering.

Cheers
Erwin

[eugchen]

not sure i understand. how do i accomplish this then? i want the data in cells A1, A2, A3 to go into B4, B8, B70.

[AliGW]

You asked what you were doing wrong - post #5 tells you. You can’t do what you want.