Copy Data from 1 Sheet to Another

P

pai

Hello Experts

I have PO ( Purchase Order) around 64K

All are in Same Column and Row, First PO Start From A1:J63, and after
2 Blank Rows i.e. A64:J65 , There is another PO (A66:J128 and So on,

Cross Posted (http://www.mrexcel.com/forum/showthread.php?t=481002)
http://www.excelforum.com/excel-general/737068-copy-data-from-1-sheet-to-another.html




In another Sheet I have Summary Report

Now, what I want to Display Yellow Colored Cell in Summary Sheet Like
This

Means i have to Get Data from Column A,C,I ( A7,C15,I6,I7,I27)

And, Then i want A72,C80,I71,I72,I92)

That Mean After Every 66th Row i want the Data, the Format is Same But
the Information is different




Is it Possible With Formula or I have to Copy Paste these information


Any Solution is Much Appreciate
 
P

Pete_UK

Put these formulae in the cells stated in the Summary sheet:

B1: =INDEX(Sheet1!B:B,(ROW(A1)-1)*65+7) to get B7
C1: =INDEX(Sheet1!I:I,(ROW(A1)-1)*65+6) to get I6
D1: =INDEX(Sheet1!I:I,(ROW(A1)-1)*65+7) to get I7
E1: =INDEX(Sheet1!C:C,(ROW(A1)-1)*65+15) to get C15
F1: =INDEX(Sheet1!I:I,(ROW(A1)-1)*65+27) to get I27

Then you can just copy these formulae down as far as required.

Hope this helps.

Pete
 
P

pai

Put these formulae in the cells stated in the Summary sheet:

B1:    =INDEX(Sheet1!B:B,(ROW(A1)-1)*65+7)        to get B7
C1:    =INDEX(Sheet1!I:I,(ROW(A1)-1)*65+6)             to get I6
D1:    =INDEX(Sheet1!I:I,(ROW(A1)-1)*65+7)             to get I7
E1:    =INDEX(Sheet1!C:C,(ROW(A1)-1)*65+15)       to get C15
F1:    =INDEX(Sheet1!I:I,(ROW(A1)-1)*65+27)           to get I27

Then you can just copy these formulae down as far as required.

Hope this helps.

Pete

Thanks Pete_Uk

Woks Like a Treat
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top