Data available : A range of data in a column. Some of the cells are blank.
My requirement : Is there any formula wherein I can copy data from the range in the column to another column in another sheet. I need to copy only filled cells. I also need to have a command which will automatically copy data by the click of one button maybe!! I tried a macro but it doesn't work.