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