Copy Data of Total

[howard]

I have 'total" in Column A

I need a macro to copy data appears 4 rows below "Total" to the cell below the last row of data before total as follows:

1) The data in Col A:C below Total (Col A) to be copied to Cols A:C after the last row of data
2) The Total in Col D below Total (Col A) to be copied to Col E after the last row of data
3) The Total in Col F below Total (Col A) to be copied to Col F after the last row of data
4) The Total in Col I below Total (Col A) to be copied to Col D after the last row of data



Your assistance in this regard is most appreciated