Copy from last row

[saravanan1981]

Hi,
Please refer example file attached.

In attachment I need a Macro to find last low and copy and paste.

Need to find number in last row of column "B" from first table. Here it is B10. Please not the last row cell could change data to data. it could be B4 or B5 or B6 etc. But it will not go beyond row number 10.
Copy the same and paste in B17

Need to find number in last row of column "C" from first table. Here it is C10. Please not the last row cell could change data to data. it could be C4 or C5 or C6 etc. But it will not go beyond row number 10.
Copy the same and paste in C17

Need to find number in last row of column "D" from first table. Here it is D10. Please not the last row cell could change data to data. it could be D4 or D5 or D6 etc. But it will not go beyond row number 10.
Copy the same and paste in B18

Need to find number in last row of column "E" from first table. Here it is E10. Please not the last row cell could change data to data. it could be E4 or E5 or E6 etc. But it will not go beyond row number 10.
Copy the same and paste in C18

[JBeaucaire]

B17: =INDEX($B$5:$G$10, MATCH("Grand Total", $A$5:$A$10, 0), 2)
C17: =INDEX($B$5:$G$10, MATCH("Grand Total", $A$5:$A$10, 0), 3)

B18: =INDEX($B$5:$G$10, MATCH("Grand Total", $A$5:$A$10, 0), 4)
C18: =INDEX($B$5:$G$10, MATCH("Grand Total", $A$5:$A$10, 0), 5)

[nigelog]

vba alternative

Please Login or Register  to view this content.