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)
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)