Can someone please review my Macro and fix the issue of copy/paste data from 2 sheets

Hello All, Happy New Year!

I was wondering if a more experienced VBA/Macro can help assist me in fixing a macro that I recorded. Basically the issue is I am transferring data columns from one sheet to another. Data on sheet "POPO" will be copied and pasted to sheet "DATA_INPUT. I will be taking columns A, B, C, D, E, and H, will paste them into the new sheet. The issue I am running into is, many times the original sheet data will be missing values in certain cells, specifically column B in original tab only transferring over small of data to the new tab (column D). I believe this is due to the missing values in cells which causes the copying and pasting to stop at the missing cell.

if anyone asks, this is a repetitive report that I manually process 10-15 a day. I am hoping that macro can automate this process so I can concentrate on other reports. The original data size will vary.

Original sheet: POPO
New Sheet: DATA_INPUT



Macro

Please Login or Register  to view this content.

Administrative Note:

Sorry, but ...

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)