Filtering blank rows of three columnand copying data from non blank rows of another column

[skml]

Dear Sir,

I have attached workbook named TIME_DATA.xls. The workbook contains two worksheets. Rawdata and Output.

Kindly provide a macro code for the following scenario

1. In the worksheet named Raw data, if the rows of Column Text named A, B and C are blank, then it should copy data from non blank cells of column text

named D and paste in the same format mentioned in the Worksheet named Output

Regards

[skml]

Dear Sir,

Till now no response.

Kindly provide me a macro code.

[MarvinP]

Hi skml,

You don't have any blank cells in the raw data tab in cols A,B or C. More than an attached you need to show us what is expected.

[skml]

Dear Mr Marvin

Thanks for your response

I will explain with example

If column 12, 13, 14 is blank then it should fetch data of non blank cells from column 15 and copy to worksheet named output

If column 20,21,22 is blank then it should fetch data of non blank cells from column 23 and copy to worksheet named output

Similarly the macro code should work for 31 days.

[skml]

Dear Mr Marvin

I hope it is clear for you.

Kindly let me know if you need further inputs.

Regards

[jindon]

Please Login or Register  to view this content.

[skml]

Dear Mr Jindon

Tested.

Excellent. Working fine.

Appreciation and thanks for your immediate response.

Regards