Macro to extract rows from another files

**harsh767** · 07-15-2012, 01:22 PM

Hi Everyone!!

I am trying to create a report file which can pull rows from another excel file
and paste into MASTER SHEET in my open workbook.

1. ROW A,B,C,F,H
2. ROW A,B,I,L

I am not a macro expert but m trying to learn. Attached worksheet will give
you general idea what i basically want to do..

Will appreciate any help.....

Thanks!

**Leith Ross** · 07-15-2012, 02:38 PM

Hello harsh767,

Welcome to the Forum!

Are you copying from one open workbook to another?
If so, are both workbooks open in the same instance of Excel?
Which worksheets will have their data copied to the Master worksheet?
What are the cells to copied and where will they placed on the Master sheet?

**harsh767** · 07-15-2012, 02:53 PM

Thanks for replying Leith!

1. Ya I am copying from One work book to another (Master Sheet)

2. Only mastersheet is open. Extract button will allow to select the file from its location. Extract the data to copy to MASTER SHEET.

3. I want to copy specific Rows from primary and secondary files. Both will have only first worksheet.

4. Row A,B,C,F,H,K to Master sheet. (is it possible to change rows for both as per the need?)

5. They will be copied to first six rows of master sheet starting from A2. Same thing with secondary file but it will start from seventh row.

**Leith Ross** · 07-15-2012, 03:04 PM

Hello harsh767,

In summary, you want to copy 6 rows of data from the each of the other 2 workbooks. The first workbook you want to copy the data from the first workbook to the cells in columns "A,B,C,F,H" on the master sheet. The second sheet will copy cells in columns "A,B,I,L" of the master starting below the first six rows copied from the first workbook.

Does each row on the first workbook only contain 5 cells? For example, say the first rows is A1:E1. Will these cells will copied to A2,B2,C2,F2,H2 on the Master sheet?

**harsh767** · 07-15-2012, 04:55 PM

Hi Leith,

Ya exactly. Both sheets have around 10-13 rows but
I want to copy only specific 5 rows from it. The
5 whole rows from primary will be copied to master sheet
A2:F2 and other worksheet rows will be copied to h2:m2.
Each row has around 400 contact details.

Thanks!!