July 15, 2020
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)
October 5, 2010
The W2 you've supplied is completely empty so I don't understand the need for it? Why not just copy the W1 file and rename it W3?
Or is your intention to add data from W1 to another workbook? If so I'm still not clear on the need for an intermediate W2. You could use Power Query to get the data from W1 into W3.