Copying certain cells from one column

Closed
Emma - Jan 21, 2012 at 05:33 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 21, 2012 at 06:31 PM
Hello,


I want to copy certain cells depending on their value contents from a column into another column but follow their order. If some cells are not to be copied depending on the criteria used then their position should appear blank on the new column. For example the cells in original column say A1 to A5 are 1002, 2003, 2020, 1700, 1050. Now I want to copy only cells with numbers less than 2000. Then the new column, say B should appear as 1002,...,...,1700, 1050. i.e B1=1002, B3=1700, B5=1050. It means they should maintain the ir position in rows as was in the original column.

Can you help me with an excel Macro to do this?
Thanks
Emma

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jan 21, 2012 at 06:31 PM
in an empty cell in row 1 e.g. B1 copy this formla

=IF(A1<=2000,A1,"")

copy B1 dwn
0