Vba Excel, Need to copy Sheets and past one line below main sheet.

[dmcovey1993]

What I wanna do:

At the end of this program I wanna add to it and make it Copy All 1D_1, 1D_2, 1D_3, 1D_4, 1D_5, 1D_6. An past them Onto Sheet called Comingsoon_report here is the catch some times there may be only up to 1D_5 or only up to 1D_3 I don't want it to Error out if that was to happen. Also I want it to post 1 line Below any text in Cell A on the page Comingsoon_report

Can any one help me I am new to VBA.
Please help

Please Login or Register  to view this content.

[dmcovey1993]

Can Any One Help?