Dear Experts,

I hope you can provide me with a solution to the following problem I have.

Column A contains both whole numbers and non-whole numbers (decimals). I
wish to write some simple code to tell excel to copy cells that contain whole
numbers only from column A into another column B located elsewhere on the
sheet.
For example, Column A may have whole numbers in every third or seventh cell
(Random). I would like these values to be transferred to column B in order as
they appear.

How do I approach this problem? I understand that I may have to use the IF
function, however I do not know how to implement it.

Any information will be greatly appreciated. Looking forward to hearing from
you.

Kind regards

Eddie