Macro to copy data and paste to another worksheet if criteria met

[kesbutler]

Greetings,

I have report that is unformatted and contains no headers. I need to copy certain cells and paste to another worksheet in the same workbook. I have made several attempts but cannot get it to function correctly. I am not new to excel but am to macros.



Report Macro.xlsx

[kesbutler]

Forgot to mention the data I need to copy/paste: In the example it would be:

B7
B10:B13
C10:C13
D7
D10:D13 (these rows I need to split the value and date into two columns)
F7 (only the B/G:B string)
F9 (only the LEAD-IND:L string)

The report continues with the same type of data formatted the same way for as many 1000 rows. There is not the same number of empty rows between the data throughout the report. and there is random data in between. Column A will always contain NDC if there is a number in the adjacent cell same with RX-Name in column C there will also be data in the adjacent cell D. There is always an emplty row above Field Name O.

Is there a way to copy only the cells I need to another worksheet.