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-gene...o-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

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

On Jul 14, 10:29*am, pai <hardeep.kan...@gmail.com> wrote:
> 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-gene...a-from-1-sheet...
>
> 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

On Jul 14, 5:07*pm, Pete_UK <pashu...@auditel.net> wrote:
> 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
>
> On Jul 14, 10:29*am, pai <hardeep.kan...@gmail.com> wrote:
>
>
>
> > 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.excel......
>
> > 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

Thanks Pete_Uk

Woks Like a Treat

You're welcome, Hardeep - thanks for feeding back.

Pete

On Jul 15, 9:46*am, pai <hardeep.kan...@gmail.com> wrote:
>
> Thanks Pete_Uk
>
> Woks Like a Treat