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.
Bookmarks