locked
Macros for copying data from multiple sheet to multiple sheet RRS feed

  • Question

  • How to VBA code if I want to copy data from one excel workbook which has data in 3 different sheets to be copied to different excel workbook with 3 sheets?

    I have 2 excel workbook named as W1 and W2, each excel workbook consists of 3 sheets named as A1, A2, A3 and B1, B2, B3 respectively.

    W1 would be an open workbook and W2 would be a closed workbook in a specific path.

    I need to copy selected data from

    W1 A1 to W2 B1
    W1 A2 to W2 B2
    W1 A3 to W2 B3

    The selected data would be a single cell data (cell H5 and N3) and multiple cell data (cell B12 to Q21)

    After data copy and paste, need to save as to create W3 (workbook 3)
    Wednesday, July 15, 2020 1:42 PM

All replies

  • Collect data from multiple sheets into one with Consolidate function. If you want to collect data from multiple sheets into one sheet in the same workbook, you can apply the Consolidate function in Excel. 1. In a new sheet of the workbook which you want to collect data from sheets, click Data > Consolidate.
    Wednesday, July 15, 2020 2:55 PM