Conditional Copy If Data Available

[vikas_newports]

Hello
Good day, I want to copy data from Site One and Site Two to Main sheet under the very next row ... if data is available in Site one and SIte two (except Header)

I tried Macro Recording but Macro can not think logically so I am here to request you to help

File attached

[davesexcel]

You want the blank cells in column E based on the row count in column D

Please Login or Register  to view this content.

[vikas_newports]

I apologize for the wrong attachment ... Now the correct file is attached

You want the blank cells in column E based on the row count in column D

Please Login or Register  to view this content.

[vikas_newports]

Any expert ?