Filter, copy, paste on same sheet

[KSpider]

Hope I can explain this right.
Ok , every morning I run a macro that compares the previous two day
prices for items. Now under certain circumstances I want to replace th
new price over an old price, if in fact it has changed over a certai
tolerence. Now I have a diff column, which I use to filter the change
over tolerence, what I have been doing is hand inputting the new ove
old prices. I tried copying the filtered list, but when I paste i
screws up. It starts in the cell I want, but starts pasting in th
hidden cells. Is there a way around this?
Hope I made myself clear.

For example :

Price 1 Price 2 Diff
a1=20 b1=20 c1=00
a2=15 b2=25 c2=10
a3=12 b3=32 c3=20
a4=33 b4=33 c4=00
a5=22 b5=75 c5=53

I will filter for differences, and will get rows 2,3,5 visible. I wan
to able to copy the visible cells of b2,b3,b5 and paste them int
a2,a3,a5

 

[BorderMan]

It's clear. Unfortunately, you can't copy non-adjacent cells into non-adjacent cells. However, if you can get the just the cells you want to another column, you can use the Copy, Paste Special, Skip Blanks option to copy the new column over column A, leaving the cells in column A you want to keep and overwriting the cells with the new values

Hope that helps.

 

[Jim Rech]

Further to Borderman, perhaps your example was simplified but it's okay to
copy all of column B to A since the rows where A & B are the same will not
change anything. If the situation is more complex maybe a macro can do an
intelligence compare and copy.