Need help on copy data and paste to the specific columns in another worksheet

Hi everyone,

Sorry that I am new in VBA. I would like to copy data from Tables 1 to 4 (Data) and pastes to the specific columns in another worksheet (Expected Result).

Table 1 NO_ISSUED: from row 1 to 99 (from column A)
Table 2 ISSUE_DATE: from row 100 to 199 (from column B)
Table 3 NET_LIST_SA: from row 200 to 299 (from column B)
Table 4 PRICE_DIFF_PERCENT: from row 300 to 399 (from column B)

Knew that I should use array function to do so, but I still can't find success.

Have attached sample Excel with dummy data. Thanks for your advice.

Hi nelsonlauo,
try this

Please Login or Register  to view this content.

Thanks a million, nilem. My question is solved. You are awesome.

Thanks, Pepe. This post I have marked as SOLVED. =)